HA - DR in SQL Server - Putting the Puzzle Pieces Together and Planning for the Future

Explore the comprehensive landscape of High Availability and Disaster Recovery in SQL Server through this conference talk from PASS Data Community Summit. Delve into the rich set of HA and DR capabilities, understanding their functionality and architectural implications across Linux and Windows platforms. Learn about major HA options, including Backup/Restore, Log Shipping, Database Mirroring, Always On Availability Groups, and Failover Clustering. Discover new developments such as Automatic Recovery of Corrupted Pages, Distributed Availability Groups, and Direct Seeding. Gain insights into SQL Server Failover Cluster Instances with various storage solutions, including Premium File Share, S2D, and the new Azure Shared Disk. Examine the differences between Linux and Windows HA implementations, and get a glimpse of upcoming features like Distributed Network Names with Virtual Network Name & Azure Load Balancer. Equip yourself with the knowledge to make informed decisions when choosing and implementing HA/DR architectures for your SQL Server environment.

Intro
Disaster recovery
High Availability
Backup/Restore
Log Shipping
Database Mirroring
Always On Availability Groups
Automatic Recovery of Corrupted Pages
Distributed Availability Groups
Primary Site
Direct Seeding
Failover Clustering
SQL Server Failover Cluster Instance with Premium File Share
SQL Server Failover Cluster Instance with S2D
NEW SQL Server Failover Cluster Instance with Azure Shared Disk
NEW Distributed Network Names (DNN) With Virtual Network Name & Azure Load Balancer
Linux vs Windows HA