Dev and Test Agility for your Database with Docker
summary
Shows how to run SQL Server for Linux in Docker to make the database a first-class, versioned component for dev and test, with a real ASP.NET Core API, integration tests and automated schema changes applied by Flyway migrations. Uses docker-compose to orchestrate three containers (DB, migration, API), maps ports and volumes for persistence, and runs tests in CI via Azure Pipelines. Demonstrates a full cycle: images pulled (~4 min), fixes a race-condition with a short sleep, and ends with 9/9 tests passing.
AI-written summary · about
chapters (39)
- 0:00Introduction
- 3:43Unit testing
- 4:57Sharing source code
- 6:46Persistence
- 8:05Relational Database
- 9:14Database in Docker
- 11:23Sequel Server
- 12:53Docker Image
- 16:13Containers and Databases
- 18:45Docker is already running
- 18:59Docker is just like pulling packages
- 19:35Docker pull command
- 23:36Demo applications
- 23:54Docker run
- 24:45Docker entry point
- 25:42Small solution
- 28:07Visual Studio Code
- 30:18Migrations
- 30:52Test Data
- 31:16Running the API
- 32:36Testing the API
- 32:59Troubleshooting
- 33:47Moving Parts
- 34:43Running Again
- 36:01Race Condition
- 36:29Docker File Overview
- 37:18Docker Image Overview
- 37:58Compose Overview
- 43:09Connecting to the Database
- 44:35Connection string
- 44:47Migration
- 47:15Start from scratch
- 48:13DockerCompose
- 49:47Docker Compose
- 51:34Docker Compose vs API
- 53:18Docker Logs
- 54:48Tracking Secondary Data
- 56:28Sharing Secondary Data in a Normal World
- 57:11Changing to a New Branch
related talks
45mDev and Test Agility for your Database with Docker
50mDev and Test Agility for Your Database with Docker
30mDev and Test Agility for Your Database with Docker
56mDeploying Docker for Database DevOps Dominance
46mDatabase CI/CD with Docker Containers and Azure DevOps
54mA Database DevOps Pipeline
46mA Database DevOps Pipeline
39mDatabase DevOps with Containers