How to Close Connections to an MS SQL Database
When you attempt to take a database offline in Microsoft SQL Server and it fails, it usually means that active connections or transactions are preventing …
Windows Server
How to Detect Orphaned Users in MS SQL Server
Today, I will share a technical tip that I recently used during an SQL cluster migration. I needed to check for “orphaned users” after restoring my …
Protected Users - Secure Your Credentials Against Mimikatz & Co
In the world of technology, information security is a constant concern. For those of us managing enterprise networks, protecting user credentials is a top …
Fixing the "CatalogVersion" Issue Between SCCM and WSUS
In this article, we will discuss an issue that can occur after recovering WSUS or SCCM. This issue results in software updates no longer installing on SCCM …
MSSQL - tempdb Takes Up Too Much Space - Disk FULL
The issue we will address concerns the excessive growth of the “tempdb” database. To determine the cause of this problem, the first step is to launch SQL …
Reinstall WSUS and the Software Update Point Role in ConfigMgr
I recently encountered synchronization errors with the Software Update Point in SCCM/MECM. The SUP role in ConfigMgr manages the WSUS server role. I …
Find the SCCM (MECM) Site Code Using PowerShell
The SCCM (MECM) site code information is stored in WMI, so we can retrieve it using PowerShell.
Find an AD Group Using a Wildcard
If you try searching for an AD group using the “dsa.msc” tool, you’ll notice it cannot search for a group based on a partial name. It doesn’t support …
Package Manager for Windows => Chocolatey
As you probably know, Windows introduced its own package manager “winget,” built into Windows 11. But before that, or if you have different needs or …
Windows - Built-in Users, Default Groups, and Special Identities
Hello! It’s been a while, so today I’ve reformatted a table from ss64.com into three distinct tables detailing the different groups and users in Windows.
Restart a Remote Server via Command Line (CMD)
How to restart a remote server via command line (CMD).
Find a Service Account (MSA) in AD - Hidden Accounts
Are you searching for an account in AD but can’t find it? It might be a Managed Service Account (MSA). Here’s how to locate it!