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 the operation from completing. Here’s how to close connections to an MS SQL database and resolve this issue.
31 Jan, 2024
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 database on a new cluster. To do this, I wrote a small T-SQL script, and I will explain it in detail.
30 Jan, 2024
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 priority. Today, I’ll introduce you to a special group in Active Directory (AD) - the "Protected Users" group, and why its use is crucial in our fight against attack tools like Mimikatz.
12 Jan, 2024
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 clients.
13 Jun, 2023
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 Server Management Studio and access the "tempdb" database.
13 Mar, 2023
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 attempted a WSUS reset, but it ended up causing more issues. To fix this, I decided to start fresh by uninstalling and reinstalling everything.
6 Oct, 2022
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.
21 Sep, 2022
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 wildcards.
19 Sep, 2022
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 preferences, you can use a third-party tool like the one I'll present today Chocolatey.
16 Mar, 2022
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.
1 Mar, 2022