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.
Reading an Inherited SQL Server Agent Job: Step Flow, Retries and History
Map the step flow of an inherited SQL Server Agent job from msdb, find unreachable steps and loops, and read retries and step 0 in sysjobhistory.
What a Linked Server Query Sends: Four-Part Names, OPENQUERY and EXEC AT
Which filters and joins reach the remote server in a linked server query? I traced four-part names, OPENQUERY and EXEC AT, and counted the rows.
Idempotent SQL Server Agent Job Deployment Across Many Instances
Why the scripted job fails on a second run, a deploy script you can rerun on every instance, and a query that finds job drift.