Deploying Docker for Database DevOps Dominance
summary
Claim: Docker plus CI/CD can make database changes testable and deployable automatically. The demo wires Azure DevOps to spin up a SQL Server container in Azure Container Instances, deploy database code from a database project or migrations, run tSQLt unit tests inside the container and then publish results — the run shows two unit tests passed. Tools discussed: Docker, SSDT, Flyway/Liquibase, Azure DevOps, build agents; cautions include data type changes, multi‑GB restores, load testing and rollback complexity.
AI-written summary · about
chapters (20)
- 0:00Introduction
- 2:25Why Database DevOps
- 5:00Definitions
- 6:25Advantages
- 9:20Docker
- 11:05Kubernetes
- 16:30Visual Studio
- 18:38Unit Testing
- 22:10Build Server
- 23:05DevOps Pipeline
- 24:16Additional Work
- 28:14Integration Tests vs Database Tests
- 28:49Mocking Databases
- 32:48Lookup Tables
- 39:34Additional Thoughts
- 47:04Database Deployment
- 47:59Replicating Data
- 49:09The Real Challenge
- 50:47Rolling Back
- 52:09Questions
related talks
46mDatabase CI/CD with Docker Containers and Azure DevOps
45mDev and Test Agility for your Database with Docker
01h 07mDev and Test Agility for your Database with Docker
50mDev and Test Agility for Your Database with Docker
50mBringing DevOps to the Database
30mDev and Test Agility for Your Database with Docker
50mA Deep Dive into DevOps Practices with Azure SQL
46mA Database DevOps Pipeline