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.
THREADPOOL Waits: Reproducing Worker Thread Exhaustion in SQL Server
Reproducing THREADPOOL waits on SQL Server 2019: how max worker threads is sized, what new logins see, and finding the blocker through the DAC.
Testing AI-Generated DDL Against the Rules It Was Given
I asked an AI coding agent for CREATE TABLE DDL from a plain-English spec, then tested every rule on SQL Server 2019 and 2025. Several weren’t enforced.
Turning a Folder of DBA Scripts into a PowerShell Module
Package one-off DBA PowerShell scripts as a module: .psm1, .psd1 manifest, explicit exports, PSModulePath and side-by-side versions, tested in 5.1 and 7.