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.