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.
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.
Configuration Drift Between SQL Server Instances: Comparing sys.configurations to a Saved Baseline
Save sys.configurations from each SQL Server instance to a baseline table, then find options that differ, are missing, or need RECONFIGURE or a restart.
Logins, SIDs, and Kerberos from First Principles, Part 8: Auditing Logins with Service Broker
The series so far has answered who can connect ( showed even that requires asking Windows) and how they prove it ( and ). The closing question is who actually does. Group-based access means the…
Logins, SIDs, and Kerberos from First Principles, Part 5: Windows Groups and the Invisible Members
Every post in this series so far has dealt with principals you can see: a login row in sys.server_principals with a name and a SID. Windows groups break that comfortable assumption. Grant a group a…