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

This course covers the learning outcomes and goals of understanding High Availability (HA) and Disaster Recovery (DR) capabilities in SQL Server. It aims to help learners comprehend the various HA options available across Linux and Windows, make informed architectural choices, and stay updated on upcoming developments. The course teaches skills such as implementing Backup/Restore, Log Shipping, Database Mirroring, Always On Availability Groups, Automatic Recovery of Corrupted Pages, Distributed Availability Groups, and Failover Clustering. It also covers specific configurations like SQL Server Failover Cluster Instances with Premium File Share, Storage Spaces Direct (S2D), Azure Shared Disk, and Distributed Network Names (DNN) with Virtual Network Name & Azure Load Balancer. The teaching method involves discussing major HA options, tradeoffs, and hints, as well as exploring new developments in the field. The course is designed for SQL Server professionals, database administrators, system architects, and individuals interested in enhancing their knowledge of HA and DR strategies in SQL Server across different operating systems.