SQLskills IECAG - SQL Server 2019
Issued by
SQLskills
This badge shows attendance of the SQLskills Immersion Event on Clustering and Availability Groups. IECAG teaches you how to plan for, implement, and maintain AlwaysOn Failover Clustered Instances and AlwaysOn Availability Groups in SQL Server using best practices and real-world experience. Topics covered: Windows Server Failover Clustering, AlwaysOn Failver Clustered Instances, AlwaysOn Availability Groups, and leverages factors and decisions made in successful case study implementations.
- Type Learning
- Level Advanced
- Time Days
- Cost Paid
Skills
- Appropriate Use For Combining FCIs With AGs For High Availability And Disaster Recovery
- Choose Appropriate Windows Server Version And Why It Matters
- Deploying A Failover Clustered Instance (FCI) For SQL Server
- Design And Resolve Workload Issues With Readable Secondaries
- Effectively Using Dynamic Management Views (DMVs) For Troublehsooting
- Implement SQL Server FCIs As A Part Of An Availability Strategy For SQL Server
- Knowledge Of I/O Concepts And I/O Subsystems For SQL Server
- Limitations And Usage Of Advanced Availability Groups In Enterprise Edition
- Limitations And Usage Of Basic Availability Groups In Standard Edition
- Limitations And Usage Of Distributed Availability Groups
- Migrating To AlwaysOn Availability Groups From Database Mirroring
- SQL Server Database Structures
- SQL Server Internals
- Understand Foundation Of Windows Server For Use With SQL Server AlwaysOn Failover Clustered Instances And AlwaysOn Availability Groups
- Understanding Requirements And Best Practices For Failover Clusters Within Windows Server