Building and Managing High Availability Solutions with SQL Server

Along the course you will learn the basics on how to create a high available solution, along with the potential threats the platform may face. You will learn how to install Windows Server 2016, maintain it, monitor and troubleshoot your solution.

• Build a reliable High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016
• Manage a High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016
• Build Disaster Recovery Solutions
• Troubleshoot problems with High Availability in SQL Server 2016 and 2014

Experience administering a recent version of Microsoft SQL Server

• Basic aspects of High Availability

• Features Overview Overview of HA features in Windows Server 2016

• Failover Cluster Instances
• Availability Group
• Log Shipping

• Installation
• Storage configuration
• Quorum configuration
• Maintenance
• Patching/Upgrading
• Adding/Removing nodes to/from cluster
• Monitoring Troubleshooting

• SQL Server FCI configuration
• Active/Active
• Active/Passive
• MS DTC
• Maintenance
• Patching/Upgrading
• Adding/Removing SQL Server to/from cluster Monitoring Troubleshooting

• SQL Server AG configuration
• Sync/Async
• Read Only Routing and Load Balancing
• Direct seeding
• Distributed AG
• Maintenance
• Patching/Upgrading
• Adding/Removing files to/from database in AG
• Adding/Removing database to/from AG
• Monitoring
• Troubleshooting

• Interoperability
• with Integration Services
• with Analysis Services
• with Reporting Services