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.
Azure SQL Managed Instance Differences That Catch DBAs During a Migration
Azure SQL Managed Instance differences from SQL Server that affect a migration, checked against Learn, plus a read-only query to find them on-premises.
Auditing Microsoft Entra ID Authentication in SQL Server
Find Microsoft Entra ID logins and users in SQL Server 2022 and later from T-SQL, and learn which Entra settings only the Azure portal or CLI can show.