SQL Server Containers

on YouTube ↗46m

" summary

Explains running SQL Server Linux images with Docker and Dockerfile custom images, shows copying a .bak into /var/opt/mssql, restoring inside the container and querying on mapped port 1401, and demonstrates updating from CU6 to CU8 by stopping one container and starting another pointed at the same host volume so databases persist — the switch method for “patching” that allows instant rollback, plus pointers to Azure DevOps automation and Kubernetes-ready nonroot images.

AI-written summary · about

" chapters (13)

1. 0:00Introduction
2. 1:50What are containers
3. 3:45How do containers work
4. 4:50Linux and Windows containers
5. 6:40Portability
6. 9:55Images
7. 17:45Demo
8. 23:20Questions
9. 25:35Patching
10. 28:05Volumes
11. 30:50Customizing Images
12. 33:18Comments
13. 40:35Are Containers Ready

" related talks

• 57mSQL Server Containers & Kubernetes - Going to Production!Tejas Shah, Amit Khandelwal, OJ Ngo · SQLBits 2024
• 57mSQL Server Containers & Kubernetes - Going to Production!Tejas Shah, Amit Khandelwal, OJ Ngo · SQLBits 2022
• 30mDev and Test Agility for Your Database with DockerJulie Lerman · DockerCon 2020
• 39mDatabase DevOps with ContainersRob Richardson · Data Con LA 2021
• 01h 07mDev and Test Agility for your Database with DockerJulie Lerman · NDC Oslo 2019
• 56mDeploying Docker for Database DevOps DominanceDaniel Mallott · NDC Sydney 2020
• 50mZero to Hero with SQL Server on Linux - DBA & DevelopersTejas Shah, Amit Khandelwal · SQLBits 2024
• 45mDev and Test Agility for your Database with DockerJulie Lerman · Craft Conference 2019