Worried and nervous about meeting deadlines on deploying your SQL Server Always On solution? Struggling with lack of confidence on your design? Are outages taking over your personal life that you can no longer focus on the things that really matter?
I've got you covered.
You need to deploy or manage a SQL Server Always On Availability Group but do not have a clue about where to start. The Microsoft documentation isn’t helping and you are wasting a lot of time figuring things out on your own.
You lack the confidence to deal with it because you feel like you have inadequate knowledge. What’s worse is that unexpected Always On Availability Group outages are taking over your personal life, causing too much stress and anxiety. And you’re worried that the next outage could cost the company loss of revenue and, potentially, your job.
This is specifically for you. This online course is designed for senior database administrators and systems engineers responsible for designing, deploying, and managing a SQL Server Always On Availability Group.
Course Outline
- Verifying and Modifying Quorum Configuration
- Configuring Windows Server Failover Cluster Networking
- Testing Failover
- 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)
- Building a 4-replica SQL Server Availability Group
- Viewing Availability Group Properties
- Testing Application Connectivity and Availability Group Failover (21:39)
- Configuring Dedicated Network for Availability Group Replication Traffic
- Configuring a Distributed Availability Group
- Conmfiguring Basic Availability Groups
- My Favourite Tool for Network Connectivity Testing (18:39)
- Replicating SQL Server Logins
- Replicating SQL Server Agent Jobs
- Availability Groups as Failover Cluster Resource Groups
- Viewing Cluster Resource Dependencies
- Configuring Resource Group-level Policies
- Configuring Resource-level Policies
- Configuring Availability Groups Listener Name DNS settings for Multi-subnet Failover Clusters (16:42)
- Configuring Readable Secondary Replicas
- Configuring Read-Only Routing
- Configuring Load Balancing of Read-Only Workloads
- Running Integrity Checks: DBCC CHECKDB (14:35)
- Configuring Backup Preferences (8:04)
- Adding or Removing a Database in the Availability Group (7:25)
- Adding or Removing a Secondary Replica
- Modifying Availability/Replication Modes (5:32)
- Temporarily Suspending and Resuming Data Synchronization (3:13)
- Dealing With Different Database File Paths Between Replicas (5:25)
- Performing Planned Manual Failover of Availability Groups (6:20)
- Performing Forced Manual Failover of Availability Groups (6:36)
- Configuring Flexible Failover Policy
- Modifying Session Timeout Period (3:47)
- Performing Index Maintenance (7:12)
- Managing Statistics (5:49)
- Installing Service Packs and Cumulative Updates (54:39)