Developing SQL 14 Server Databases with Docker 20
As our infrastructure world moves to containers, our databases should be no exception. This course will teach you how to work with SQL Server in a Docker container context.
What you'll learn
As our infrastructure world moves to containers, you need to understand how to move our databases to them as well. In this course, Developing SQL Server Databases with Docker, you’ll learn to create SQL Server Docker images. First, you’ll explore working with both Windows and Linux images. Next, you’ll discover how to resolve the tension between databases and container persistence. Finally, you’ll learn how to continually upgrade and manage your database schema. When you’re finished with this course, you’ll have the skills and knowledge of working with SQL Server images needed to containerize your database solutions.
Table of contents
- Version Check 0m
- A Quick Container Refresher 5m
- Demo: Looking at an Existing Windows Container 4m
- Unpacking the Run Command 4m
- Demo: Building a New SQL Server Windows Container 2m
- Building a Linux Image 1m
- Demo: Building a Linux Image 3m
- Understanding Authentication Options 5m
- Demo: SSMS Connection Options 2m
- Summary 2m
- The Problem of Schema Migration 5m
- Demo: Exporting to DACPAC 3m
- The Limitations of Data Tier Applications 3m
- Demo: A Simple Schema Upgrade 2m
- Upgrading Schemas with Flyway 3m
- Demo: A Schema Upgrade with Flyway 6m
- How Backups Work in Our Situation 1m
- Demo: Upgrading an Arbitrary Backup with Flyway 6m
- Understanding the Nature of Schema Migrations 2m
- Summary 1m
About the author
Chris B. Behrens is a writer, speaker and software developer, specializing in DevOps. He has been a developer and architect for more than twenty years focusing on small to medium size companies and the development changes they face. He focuses on his flavor of Fear Based Development, whereby a developer ranks their tasks in descending order of anxiety, and how to tackle them in that order. Chief among these anxiety-inducing processes is software deployment, a topic that Behrens focuses upon. He ... more