MPControl 500 error after removing WSUS and the SUP from SCCM

One thing I have found interesting, intriguing, and somewhat ironic is a glorious lack of need for Configuration Manager in my environment due to things like Azure AD and Intune. For the sake of patching, though, I have so many disconnected systems in my labs that it made no sense to maintain both a WSUS…

0

PS without BS: Let’s play “Where’s that MSI?”

That infamous folder c:\windows\installer can take up a lot of space and resources, more importantly, it’s cryptic when you see a bunch of numbered MSI and MSP files. What is this good for? Well, my favorite reason is that on occasion you can find the MSI of a software package that may require a manual…

3

Recovering a SQL database via T-SQL

So this post is courtesy of a late night database issue. One of my important SQL databases was coming up suspect, so what to do? Well, here’s some TSQL that may help, if you need to recover a database: USE master GO ALTER DATABASE YourDatabase SET EMERGENCY GO DBCC CHECKDB (YourDatabase) GO ALTER DATABASE YourDatabase…

0

Locked out of SQL…No More

I had an interesting issue come up at a customer where they needed to change SQL Memory and reattach a database, neither action they could accomplish. For some reason, they had no rights to do so (and should have). How to remedy this? Before doing this, you will need the SQL Server, Instance name (I’ll…

0

So, how do you prepare for a Microsoft exam?

A lot of thoughts go into Microsoft exams, and really it’s easy to overthink these. Whether you are doing it just to get a piece of paper, your boss is making you, or you actually are intending to learn and validate your skills, there are some techniques to keep in mind. Here are the ways…

0