Finding the Queries That Use the Most CPU, and What Each Source Misses
Plan cache, procedure stats, Query Store, dm_exec_requests and the ring buffer each name a different top CPU query. Tested on SQL Server 2019 and 2025.
Tempdb Latch Contention on SQL Server 2019 and 2025
Reproducing tempdb PAGELATCH contention with 48 sessions on SQL Server 2019 and 2025: which pages the waits hit, and how to name them.
WSFC Health Checks for SQL Server DBAs: PowerShell and DMVs
Read-only Windows Server Failover Cluster health checks for DBAs: FailoverClusters cmdlets, cluster DMVs, and why Test-Cluster needs care.
Migration Runbook Rollback Points for SQL Server Upgrades
Which steps of a SQL Server 2019 to 2025 upgrade can you undo? Tests of backup, attach and compatibility level, and a runbook with a point of no return.
Setting Up and Monitoring Log Shipping with T-SQL
Set up log shipping with T-SQL, then test what the msdb monitor tables, sp_help_log_shipping_monitor and alerts 14420 and 14421 report.
Connection Pool Exhaustion: Reproducing the Timeout and What SQL Server Sees
A PowerShell test that leaks SqlClient connections until the pool times out, what sys.dm_exec_sessions shows, and the fix with proper disposal.