You work with SQL Server Always On Availability Groups on a regular basis.
You are comfortable using SSMS, the wizards, and T-SQL to manage your complex AG implementations.
But you want to automate your administration tasks and leverage your PowerShell skills.
This is for you.
Course Outline
Program Introduction
Available in
days
days
after you enroll
Setting up your DBA workstation
Available in
days
days
after you enroll
Installing a Windows Server Failover Cluster
Available in
days
days
after you enroll
Windows Server Failover Cluster Configuration
Available in
days
days
after you enroll
- Verifying and Modifying Quorum Configuration (10:38)
- Configuring Windows Server Failover Cluster Networking (16:09)
- Testing Failover (7:29)
- Configuring DNS Registration Behavior for Multi-subnet Windows Server Failover Clusters (6:36)
- Configuring Cluster Heartbeat Settings (17:19)
- Applying the Concepts of Site-awareness for Multi-Subnet/Site Configuration (40:24)
Deploying SQL Server Always On Availability Groups
Available in
days
days
after you enroll
- Building a 4-replica SQL Server Always On Availability Group (31:13)
- Viewing Availability Group Properties (13:04)
- Testing Application Connectivity and Availability Group Failover (18:02)
- Configuring Dedicated Network for Availability Group Replication Traffic (21:15)
- Configuring a Distributed Availability Group
- Configuring Basic Availability Groups
- My Favourite Tool for Network Connectivity Testing (18:39)
Configuring SQL Server Always On Availability Groups
Available in
days
days
after you enroll
- A Note on Change Management (6:05)
- Replicating SQL Server Logins (8:39)
- Replicating SQL Server Agent Jobs (8:53)
- Availability Groups as Failover Cluster Resource Groups (14:58)
- Viewing Cluster Resource Dependencies (7:32)
- Configuring Resource Group-level Policies (11:15)
- Configuring Resource-level Policies (16:14)
- Configuring Availability Groups Listener Name DNS settings for Multi-subnet Failover Clusters (16:42)
- Configuring Readable Secondary Replicas (10:46)
- Configuring Read-Only Routing (16:28)
- Configuring Load Balancing of Read-Only Workloads (10:22)
Managing SQL Server Always On Availability Groups
Available in
days
days
after you enroll
- Running Integrity Checks: DBCC CHECKDB (9:02)
- Configuring Backup Preferences (9:04)
- Adding or Removing a Database in the Availability Group (5:53)
- Adding or Removing a Secondary Replica (7:28)
- Modifying Availability/Replication Modes (4:12)
- Temporarily Suspending and Resuming Data Synchronization (5:18)
- Performing Planned Manual Failover of Availability Groups (3:28)
- Performing Forced Manual Failover of Availability Groups (6:36)
- Configuring Flexible Failover Policy (4:02)
- Modifying Session Timeout Period (6:32)
- Performing Index Maintenance (5:34)
- Managing Statistics (5:49)
- Installing Service Packs and Cumulative Updates (54:39)
Monitoring SQL Server Always On Availability Groups
Available in
days
days
after you enroll
Troubleshooting Common Issues in SQL Server Always On Availability Groups
Available in
days
days
after you enroll