Overview
Explore how to modernize SQL servers to a Kubernetes-based Azure Arc enabled SQL managed instance in this 50-minute SQLBits conference talk. Discover the architecture of Arc enabled data services and learn about built-in features such as automatic backups, high availability, disaster recovery, and monitoring. Understand the easy provisioning and deprovisioning process, and witness numerous demonstrations throughout the session. Delve into topics including Azure Arc enabled infrastructure, deployment options, comparison of Arc SQL Server vs Arc SQL MI, database engine features and management capabilities across deployment models, service tiers, high availability options for General Purpose and Business Critical tiers, Point in Time Restore capabilities, Azure Failover Groups, and a comprehensive summary of business continuity strategies. Presented by Dinakar Nethi, Senior Program Manager in the Azure Data team, this talk offers valuable insights for those seeking PaaS-like benefits for SQL Servers within their own infrastructure.
Syllabus
Intro
Azure Arc enabled infrastructure
What deployment option fits my application?
Arc SQL Server vs Arc SQL MI
Database engine feature comparison by deployment model
Management capabilities comparison by deployment model
Service tiers
High Availability-General Purpose
High Availability - Business Critical
Point in Time Restore - General Purpose
Point in Time Restore - Business Critical
Azure Failover Groups (DAG)
Business Continuity - summary
Taught by
SQLBits