DevOps Practices for the Database Team

on YouTube ↗31m

" summary

Argues for putting all database artifacts in version control and running schema changes through CI/CD with migration frameworks like liquibase, flyway, dbdeploy so database changes package with the app. Shows automated sandbox provisioning using docker images for DB sandboxes, scripts that generate grants and boilerplate, a tablespace-mapping pipeline, and expand-and-contract refactoring to keep old and new schemas working. Recommends rolling forward rather than complex rollbacks and deploying frequently (example: regular weekly releases) to reduce risk.

AI-written summary · about

" chapters (5)

1. 0:00Start
2. 1:32WHAT DOES DEVOPS MEAN FOR THE DATABASE TEAM?
3. 2:43Put all database artifacts in version control Everyone should be able to see all the artifacts of the system.
4. 4:05Generate as much database boiler plate code as possible. Put the code generation in a pipeline
5. 8:52Write database migration during development time. Pairing with the DBA's is important to understand production size and data complexity

" related talks

• 45mEnabling Continuous Delivery with Database PracticesPramod Sadalage · Agile Singapore Conference 2016
• 46mDatabase DevOps - It is Possible!Stephanie Herr · DevOps World | Jenkins World 2019 San Francisco
• 36mUnlocking the Benefits of Database DevOps and AutomationKellyn Gorman · PowerShell + DevOps Global Summit 2025
• 33mBringing DevOps To The DatabaseBaron Schwartz · DevOpsDays Chicago 2019
• 38mGetting Along With Your Db Ops TeamNick Demaster · DevOpsDays Salt Lake City 2016
• 50mBringing DevOps to the DatabaseSteve Jones · SQL Server Virtual Conference 2021
• 05mMaking Database Changes a Tier one ArtifactRobert Reeves · swampUP 2017
• 27mDevOps and the Database BottleneckDan Zentgraf · DevOpsDays Boston 2019