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.
Finding Unencrypted SQL Server Connections, and the Instances That Accept Them
Use sys.dm_exec_connections to list SQL Server sessions that aren’t encrypted, check Force Encryption, and see how driver defaults changed.
Reviewing Max Server Memory and Lock Pages in Memory
A read-only query to review max server memory, min server memory and Lock Pages in Memory across many SQL Server instances, tested on 2019 and 2025.