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.
SQL SERVER – The Future of DevOps for DBA
Unless you live under a rock, you have heard the word DevOps. Here I define it simply and share my thoughts on the future of DevOps for the DBA.
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.