The Professional SQL Server High Availability and Disaster Recovery course explains the high availability and the disaster recovery technologies, their technical implementation, and different topologies that you can use when creating a highly available infrastructure with hybrid topologies. When you complete the course, you'll feel confident and look forward to changing the game with a robust and high performing infrastructure.

• Configure Replication, AlwaysOn, and Log Shipping in a production environment
• Use best practices to apply and troubleshoot Replication, Log shipping, and AlwaysOn
• Understand how to choose HA and DR topologies for your environment
• Design HA and DR for SQL Server
• Use PowerShell automation to configure Replication, AlwaysOn, and Log Shipping
• Use Transactional Replication to migrate from On-Premise SQL Server to Azure SQL Database

For an optimal student experience, we recommend the following hardware configuration:

• Processor: 1.8 GHz or higher Pentium 4 (or equivalent)
• Memory: 8 GB RAM
• Hard disk: 200 GB free space
• Internet connection

You'll also need the following software installed in advance:

• Windows 8 or above
• The latest version of Google Chrome
• An Azure subscription
• SQL Server Management Studio 17.2 or above
• PowerShell 5.1
• SQL Server 2014 SP2 or above - installed as named instance Server\SQL2014
• SQL Server 2016 SP2 - installed as named instance Server\SQL2016

You will need an Azure account for a few exercises in this course. If you don't have one, create a free account here. The latest version of SQL Server Management Studio can be downloaded from here. Installation instructions are also available on the same webpage.

Copy the code bundle for the course to the C:/Code folder.