SQL Server Always On Availability Groups: The Senior DBA’s Field Guide (US$2995)

A skilled database administrator is the key to successfully implementing and maintaining a highly available SQL Server database. This instructor-led training class is specifically designed for senior database administrators responsible for designing, implementing and managing a SQL Server Always On Availability Group.

In this live 3-day class, attendees will learn:

  • Fundamentals of Windows Server Failover Clustering (WSFC) – the underlying platform that makes SQL Server Always On Availability Group possible – from the external dependencies like Active Directory and DNS to quorum and cluster configuration
  • Designing and implementing a Windows Server Failover Cluster to meet both high availability and disaster recovery requirements
  • Designing and implementing common topologies of SQL Server Always On Availability Group solutions for a single- or multi-data center deployments
  • Leveraging additional SQL Server Always On Availability Group capabilities such as readable secondary replicas, backup preferences, distributed availability groups and basic availability groups
  • Managing and monitoring SQL Server Always On Availability Group implementations
  • Effective troubleshooting of availability issues for both the Windows Server Failover Cluster and the SQL Server Always On Availability Group

About the instructor: Edwin M Sarmiento is a Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.

Bonus: attendees will also get 1 year access to:

  • SQL Server High Availability and Disaster Recovery on Udemy (value: US$ 315). This course covers all of the high availability and disaster recovery features in SQL Server and how to leverage them.
  • Windows Server Failover Clustering for the Smart SQL Server DBA (value: US$ 545). This course covers the basics and fundamentals of Windows Server Failover Clustering to successfully design, implement and manage SQL Server failover clustered instances.
  • How To Build A Personal Lab for Deploying SQL Server on a Windows Server Failover Cluster (value: US$ 95). This course walks you thru building an affordable lab environment for emulating a multi-data center deployment of a stretched, multi-site failover cluster in preparation for installing and configuring either a SQL Server failover clustered instance or Availability Group

Schedules:

 
This is a live online class. We host it in GoToMeeting, live with Edwin M Sarmiento on webcam, with a 60-minute lunch (my lunch) break. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close