Database DevOps with Containers

on YouTube ↗39m

" summary

Builds an automated pipeline that takes a nightly production backup, runs a SQL script to anonymize sanitize shrink data (emails become random_string@contoso.com, sa password replaced, recovery set to simple, files shrunk), restores a Windows backup into SQL Server 2019 on Linux (binary compatible), bakes the sanitized database into an image with docker build -> docker run, and pushes it to a registry for CI (Jenkins/GitHub Actions). Demo shows the container starts, migration runs (wait ~80s), and developers can docker pull a ready dev database.

AI-written summary · about

" chapters (18)

1. 0:00Intro
2. 1:28DevOps
3. 7:07Containers
4. 13:12DevOps Pipeline
5. 13:29Database Migration
6. 21:07Connect to Database
7. 22:59SQL Server on Linux
8. 25:30Wrapup
9. 26:12QA
10. 26:49High Availability
11. 28:01Scale
12. 29:33SQL Server
13. 30:18SSIS
14. 31:28Other databases
15. 32:31Questions
16. 33:12Concerns
17. 35:38Data Masker
18. 37:57Outro

" related talks

• 54mA Database DevOps PipelineRob Richardson · Great International Developer Summit 2023
• 46mA Database DevOps PipelineRob Richardson · Øredev 2022
• 46mDatabase CI/CD with Docker Containers and Azure DevOpsChris Taylor · SQLBits 2020
• 45mDev and Test Agility for your Database with DockerJulie Lerman · Craft Conference 2019
• 50mDev and Test Agility for Your Database with DockerJulie Lerman · DevReach 2022
• 56mDeploying Docker for Database DevOps DominanceDaniel Mallott · NDC Sydney 2020
• 01h 07mDev and Test Agility for your Database with DockerJulie Lerman · NDC Oslo 2019
• 30mDev and Test Agility for Your Database with DockerJulie Lerman · DockerCon 2020