SQL Server and Kubernetes

Explore the fundamentals of running SQL Server in Kubernetes through this comprehensive conference talk from PASS Data Community Summit. Gain an overview of Kubernetes as the leading container orchestrator and learn about deployments, pods, and services. Discover how to deploy SQL Server to Kubernetes, persist data effectively, and utilize Helm for package management. Delve into chaos engineering techniques for SQL Server in Kubernetes using Space Invaders. Aimed at SQL Server DBAs and Developers, this session provides essential knowledge and code to kickstart your journey with Kubernetes, covering its benefits, components, and practical applications in managing containerized SQL Server workloads.

Intro
SESSION AIM To give you background knowledge (and code) to get started with Kubernetes
WHAT IS KUBERNETES? Kubernetes is a portable, extensible open-source platform for managing containerized workloads and services, that facilitates both declarative configuration and automation. It has a large, rapidly growing ecosystem. Kubernetes services, support, and tools are widely available
WHY LEARN KUBERNETES? Leading orchestrator Easy to deploy and mantain containers Quick to spin up containers High availability built-in Big Data Clusters
MASTER Components for controlling the cluster
SERVICES An abstraction over a set of pods Provides a stable networking endpoint Different types
PERSISTENT VOLUMES Just a piece of storage in the cluster Lifecycle independent of the pods Can be either dynamic or static
PERSISTENT VOLUME CLAIMS Request for storage by a user Request for size and access type Pods reference Persistent Volume Claims
A PACKAGE MANAGER
HELM Package manager for Kubernetes SQL Server available in the Helm Hub