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