Zero to Hero with SQL Server on Linux - DBA & Developers
summary
Same SQL Server binary runs on Ubuntu, RHEL and SLES and in containers; Microsoft provides Ansible system role (on Ansible Galaxy and built into RHEL 8.5) to deploy instances, configure XFS/FUA tuning and Pacemaker clusters in about 20 minutes, and a demo shows an Always On AG failing over between Windows VM, Linux VM and a container in ~10 minutes. Container and VM images live in Microsoft Container Registry and Azure VM marketplace with full support; published TPC‑C runs hit ~8M tpmC and a new Azure Key Vault connector (CU2 for SQL 2022) enables external EKM. Monitoring example uses Telegraf+Influx+Grafana.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 2:58SQL Server on Linux overview
- 9:24Always On on Linux demo
- 14:44SQL Server in Azure VMs/containers
- 18:40Best practice assessment
- 22:13Performance tuning & Ansible
- 28:14Manual performance config
- 29:40Business continuity & clustering
- 36:20Monitoring environments
- 38:51Azure Key Vault encryption
- 42:01Reference architectures
- 43:48Q&A
related talks
57mSQL Server Containers & Kubernetes - Going to Production!
30mDev and Test Agility for Your Database with Docker
46mSQL Server Containers
01h 07mDev and Test Agility for your Database with Docker
46mEmpowering Developers: Microsoft’s Commitment to Ope...
47mPods & Pages: Databases in Kubernetes
45mDev and Test Agility for your Database with Docker
39mDatabase DevOps with Containers