Enabling SQL Server Agent

Databases and Docker

Understanding Authentication Options

Demo Building an Image

A Quick Container Refresher

Unpacking the Run Command

Demo SSMS Connection Options

The Tension between a Database and a Docker Container

Demo What Happens When Our Image Goes Away

Docker Volumes and SQL Server

Unpacking SQL Server, Volumes, and Backups

The Problem of Schema Migration

Demo A Simple ( ) Schema Upgrade

How Backups Work in Our Situation

Upgrading Schemas with Flyway

Demo A Schema Upgrade with Flyway

Demo Upgrading an Arbitrary Backup with Flyway

Understanding the Nature of Schema Migrations

Introducing Docker Compose

Our Containers, Orchestrated

Demo Hello World in Docker Compose

Demo Orchestrating Our Containers with Compose

Resource Management with Compose

Demo Managing Performance in Compose