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.
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.
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.