StraightforwardSQL Database stuff with a side of memes

CI/CD

3 posts
Deploy at Low Priority

Deploy at Low Priority

A utility script for deploying schema changes without a maintenance window - using a time-based loop, lock checking, and GOTO to minimize blocking on busy SQL Servers.

How to 5 min read Blocking · Locking
Database CI/CD Basics (T-SQL Tuesday #177)

Database CI/CD Basics (T-SQL Tuesday #177)

A crash course on database CI/CD: source control as the source of truth, state-based vs migration-based versioning, and the many moving parts of automated database deployments.

T-SQL Tuesday 4 min read CI/CD
Testing the code (T-SQL Tuesday #156)

Testing the code (T-SQL Tuesday #156)

I picked the T-SQL Tuesday topic and still struggled to answer it. The quality of production code I value most: it has tests.

T-SQL Tuesday 2 min read Regex · CI/CD