Bringing DevOps to the Database

on YouTube ↗50m

" summary

Claims that databases can be builds tests and releases like app code by putting DDL/DML into Git, running Azure DevOps pipelines for CI, using tSQLt unit tests and a curated data set, and automating releases to QA/staging/prod (demo shows CI failing on a missing primary key then passing after fix). Compares comparison vs migration scripts (pros/cons of SQL Compare style state sync versus ordered migration files) and stresses consistent environments, rollout automation, and selective manual rollback.

AI-written summary · about

" chapters (15)

1. 0:00Intro
2. 0:16Three Takeaways
3. 2:25What is DevOps?
4. 9:19The Application Development Pipeline
5. 10:48The Database Development Pipeline
6. 14:07Evolving Database Development
7. 22:26Database Continuous Integration
8. 24:37Database Testing
9. 31:55Generate the Update Script
10. 33:14Model/State/Compare based process
11. 34:18Migrations based process
12. 38:03Deploy the Code
13. 43:11Release Issues - Rollback
14. 45:23Release Issues - Environmental Data
15. 48:49Summary

" related talks

• 01h 00mContinuous Integration and Delivery for DatabasesJimmy Bogard · NDC London 2020
• 36mUnlocking the Benefits of Database DevOps and AutomationKellyn Gorman · PowerShell + DevOps Global Summit 2025
• 27mDevOps and the Database BottleneckDan Zentgraf · DevOpsDays Boston 2019
• 56mDeploying Docker for Database DevOps DominanceDaniel Mallott · NDC Sydney 2020
• 46mA Database DevOps PipelineRob Richardson · Øredev 2022
• 31mDevOps Practices for the Database TeamPramod Sadalage · DevOpsDays Chicago 2017
• 01h 00mDevOps for Your Relational Database FoundationsBrian A. Randell · NDC London 2021
• 46mDatabase DevOps - It is Possible!Stephanie Herr · DevOps World | Jenkins World 2019 San Francisco