AI productivity gains went up on every dashboard, and the release notes are the same length as last year’s. Writing code was never the constraint. Speed up one station and you get a taller pile in front of the station that is. Here is how to time your own line.
Writing Rerunnable Deployment Scripts for Database Changes
Write rerunnable deployment scripts with guarded schema changes, version records, and a dry run on a restored database copy.
DevOps for DBAs: Build, Test, Release and Monitor
DevOps for DBAs means bringing development and operations together for the whole software lifecycle. Here is a simple definition, the four steps of the loop, and what they mean for SQL Server.
Linting T-SQL: Rules Worth Automating in a Build
Use linting T-SQL to flag repeatable code risks, review catalog-based candidates, and automate confirmed rules without false certainty.
Putting a Database Under Source Control
Putting a database under source control starts with state or migration scripts, consistent object files, and a reviewable first commit.
Every Deployment Script Needs a Tested Undo Script
Write and test an undo script before deployment, preserve old module text and changed rows, and identify changes that require recovery.
Idempotent Deployment Scripts: Safe to Run Twice
Build idempotent deployment scripts with guarded schema changes, versioned data fixes, and repeat-run checks for the intended state.