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 …
SQL
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 …
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 …
Retrieve the Port of an SQL Instance in PowerShell
A quick tutorial to find the port of an SQL instance using PowerShell.
Retrieve the Last Backup Dates for All Databases in an MS SQL Instance
Here’s a handy SQL script to check when your databases were last backed up on an MS SQL instance.