Building and Managing High Availability Solutions with SQL Server 2016 and 2014

Course Length: 3 Days

Delivered: Virtually

OVERVIEW:

This course provides an in-depth review of SQL Server 2014 High Availability, including concepts for HA, drill-through of the various technologies available with SQL Server 2014, and how to implement high availability using those technologies.

TARGET AUDIENCE:

Those responsible for building and managing high availability solutions for SQL Server.

COURSE OBJECTIVES:

• 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

COURSE CONTENT:

High Availability Overview

• Basic aspects of High Availability

Windows Server 2016 High Availability Features Overview

• Overview of HA features in Windows Server 2016

SQL Server 2016 High Availability Features Overview

• Failover Cluster Instances
• Availability Group
• Log Shipping

Windows Server 2016 Failover Clustering

Installation

• Storage Configuration
• Quorum Configuration

Maintenance

• Patching/Upgrading
• Adding/Removing nodes to/from cluster

Monitoring

Troubleshooting

SQL Server 2016 Failover Clustering Instance

SQL Server FCI configuration

• Active/Active
• Active/Passive
• MS DTC

Maintenance

• Patching/Upgrading
• Adding/Removing SQL Server to/from cluster

Monitoring

Troubleshooting

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

SQL Server Inoperability

Inoperability

• With Integration Services
• With Analysis Services
• With Reporting Services