Explore the comprehensive options for high availability in Azure SQL through this informative conference talk. Learn how to translate traditional SQL Server concepts like backup and restore, failover cluster instances, and Always On availability groups to Azure SQL's business continuity solutions. Dive into the architectures underlying various availability options and their impact. Discover how to meet specific SLA, RTO, and RPO requirements using Azure SQL's built-in capabilities. Gain insights into service tiers, availability zones, geo-replication, and auto-failover groups. Understand how to make informed choices for your database availability needs and effectively monitor performance. Access valuable resources to further enhance your knowledge of Azure SQL availability features.
Overview
Syllabus
Intro
Upcoming Sessions
Questions and Sharing
Azure SQL
Backup and restore
Layers of availability
General Purpose High Availability
Business Critical High Availability
Hyperscale High Availability
Service tiers - SQL Database and Managed Instance
What is an Availability Zone?
Active geo-replication vs auto-failover groups
Making the right choices
Zone redundant database - General Purpose service
Monitoring availability
Resources
Taught by
PASS Data Community Summit
Related Courses
-
Plan and implement a high availability and disaster recovery environment
-
Azure SQL fundamentals
5.0 -
Ensure business continuity and implement disaster recovery for SAP solutions on Azure​
-
Architect migration, business continuity, and disaster recovery in Azure
-
Azure SQL High Availability and Disaster Recovery
-
HA - DR in SQL Server - Putting the Puzzle Pieces Together and Planning for the Future
