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
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
Retrieve the Port of an SQL Instance in PowerShell
A quick tutorial to find the port of an SQL instance using PowerShell.
12 Aug, 2021
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.
30 Mar, 2021