1 – Introduction to High Availability
- Basic aspects of High Availability
2 – Windows Server 2016 High Availability Features Overview
- Overview of HA features in Windows Server 2016
3 – SQL Server 2016 High Availability Features Overview
- Failover Cluster Instances
- Availability Group
- Log Shipping
4 – Windows Server 2016 Failover Clustering
- Installation
- Storage configuration
- Quorum configuration
- Maintenance
- Patching/Upgrading
- Adding/Removing nodes to/from cluster
- Monitoring
- Troubleshooting
5 – SQL Server 2016 Failover Clustering Instance
- SQL Server FCI configuration
- Active/Active
- Active/Passive
- MS DTC
- Maintenance
- Patching/Upgrading
- o Adding/Removing SQL Server to/from cluster
- Monitoring
- Troubleshooting
6 – SQL Server 2016 Availability Groups
- 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
7 – SQL Server Interoperability
- Interoperability
- with Integration Services
- with Analysis Services
- with Reporting Services
