SQL Server Containers & Kubernetes - Going to Production!
summary
Claim: customers run full SQL Server engine on Linux containers in production, with cross‑platform Always On failover between Windows VMs, Linux VMs and Kubernetes containers using the DH2 clustering stack. Tools are Microsoft Artifact Registry images (Ubuntu or UBI), mssql‑conf/adutil for Kerberos keytabs, Helm/Ansible playbooks and a DH2 operator for k8s. A recorded demo boots three instances, configures AG with five commands in 50–90 seconds, moves a 20–30 GB database and references up to 8 million TPMs.
AI-written summary · about
chapters (28)
- 0:00Introduction and welcome
- 6:12Agenda and session goals
- 7:20Deployment and overview
- 9:01Platform and OS support
- 12:36SQL engine consistency
- 12:52SQL abstraction layer
- 13:10Container configuration
- 15:30Support and features
- 17:17Feature parity and limitations
- 19:30Always on demo
- 20:16Architecture validation
- 20:27Hybrid environment benefits
- 20:38Failover demonstration
- 20:49Operational workflow
- 21:01Update cadences
- 21:55Open source ecosystem
- 22:06Automation playbooks
- 22:41Development and QA
- 24:35Active directory support
- 28:33Automating AD setup
- 28:44Permissions and rights
- 34:15HA and clustering stack
- 35:04Cluster selection
- 36:41K8s and HA
- 38:28DH2i Enterprise overview
- 38:50Ease of use deployment
- 39:31Key vault and references
- 40:26Conclusion and wrap-up
related talks
57mSQL Server Containers & Kubernetes - Going to Production!
46mSQL Server Containers
47mPods & Pages: Databases in Kubernetes
30mChaos Engineering for SQL Server
30mDev and Test Agility for Your Database with Docker
43mSQL Server 2019 Big Data Clusters Architecture
39mDatabase DevOps with Containers
46mContainers - You Better Get on Board!