Let's Get Scary and Continuously Deploy Database Changes

This talk explains how to automate database deployments in a CI/CD pipeline and manage schema changes while preserving access to data. It briefly covers automated testing and demonstrates state-based and migration-based approaches using tools such as SSDT and Flyway.

Syllabus

Introduction
Agenda
Automation
Data is a problem
Data stores
transactional databases
safe changes
dropping changes
naming changes
Renaming a column
Renaming a table
Protecting against broken business logic
Unit testing is your friend
Stack Overflow example
Time Check
Managing Database Source Code
Why are we always rolling forward
Item potency
SQL Server Data Tools
Rename
State Changes
Running the Migration