SQL Server Containers & Kubernetes - Going to Production!
summary
Claims that the exact same SQL Server binary runs on Linux and in containers via same SQL engine, demonstrates an Always On availability group failing over between a Windows VM, an Azure Linux VM and an AKS container using the dh2 cluster stack, and shows a custom image enabling Active Directory via Kerberos keytab. A Kubernetes operator deploys three SQL instances and configures AG with 5 commands <90s (demo uses a ~20–30 GB DB); reference architectures report 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!
50mZero to Hero with SQL Server on Linux - DBA & Developers
47mPods & Pages: Databases in Kubernetes
46mSQL Server Containers
30mChaos Engineering for SQL Server
46mDatabase CI/CD with Docker Containers and Azure DevOps
59mMigrate and Modernize with Kubernetes and Windows Containers
43mSQL Server 2019 Big Data Clusters Architecture