This course covers the enhancements and updates related to SQL Server 2016 Always On Availability Groups. By the end of the course, learners will be able to understand the new features and improvements in SQL Server 2016, such as security enhancements, failover support, DTC support, and Azure integration. The course teaches skills like configuring Availability Groups, implementing failover strategies, and optimizing performance through load balancing and log transport compression. The teaching method includes presentations, discussions, and demonstrations. This course is intended for database administrators, SQL Server developers, and IT professionals looking to enhance their knowledge of SQL Server 2016 Always On Availability Groups.
Overview
Syllabus
Intro
Technical Assistance
HA/DR: Backup & Restore
Other AG Components & Concepts
Failover Cluster Topology
Availability Group Topology
Prototypical Architecture of AGs with Local Non-Shared Storage
Best Practice: Hotfixes & Updates
AGs Enhancements: Fewer Dependencies
SQL Server Standard Edition Support Now that DBM has been marked for deprecation, this is welcome now!
Azure Integration
AGs Enhancements: Security
AGs Enhancements: Failover
AGs Enhancements: DTC Support
AGs Enhancements: Direct Seeding
Log Transport Compression Defaults & Options
Readable Secondary Round-Robin Load Balancing
Readable Secondary Azure Support
Read-Only Secondaries: Licensing & Performance
Best Practice: SORT_IN_TEMPDB
AG Performance Enhancements
Always On AGS: SQL 2016 vs. SQL 2014 (Hekaton)
Unleashing the Power of SQL Server 2016
SQL 2014 vs. 2016: Log Transport Performance (Engine)
SQL Server 2016 Async vs. Sync: Network Bandwidth Support
SQL Server 2014 vs. 2016 CPU% on Primary vs. Transactions (Sync, 3 Replicas, 3 Trials)
Taught by
PASS Data Community Summit
