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.
Finding and Fixing a Plan Regression with Query Store
A plan regression reproduced on SQL Server 2019 and 2025: finding it in Query Store, forcing the good plan, automatic plan correction and PSP.