Should I Move My Production SQL Server Workloads to Containers

Explore the pros and cons of containerizing production SQL Server workloads in this comprehensive conference talk from PASS Data Community Summit. Delve into the architectural differences, advantages, and disadvantages of running SQL Server in containers. Trace the history of SQL Server containerization, examine industry trends, and understand the potential and challenges of this approach. Learn about data persistence, container lifecycles, patching, and high availability considerations for SQL Server in containers. Gain insights to make informed decisions about whether to move your production SQL Server workloads to containers or maintain traditional deployment methods.

Intro
What is this talk about
Agenda
Should I Move My Production SQL Server Workloads to Containers
Is Running SQL Server in Containers Hard
History of SQL Server
Big Data Clusters
Industry Trends
Windows Server 2016
Project Pacific
Kubernetes
SQL Server Interest
Containers
Container Life Cycle
Power of Containers
Two Fundamental Issues
Data Persistence
Containers for SQL
Containers for Windows
The Potential
The Downside
Patching
High Availability
Challenges