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.
Trigger Archaeology: Mapping Nested and Recursive Trigger Chains
Map which SQL Server trigger writes to which table before you change a legacy schema, and see what happens at the 32-level nesting limit.