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 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$ 200, was 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
This is a live online class. We host it in GoToWebinar, live with Edwin Sarmiento on webcam, with a 75-minute lunch break. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way. For more information, check out the Training Logistics PDF for our online classes.
Instant Replay Access – you can stream a recorded version of your class for one year. The recordings will be available here online one week after your class finishes. It’s the best of both worlds: live training with great Q&A, plus the ability to brush up over time.
Class dates & times:
- December 20-22, 2017 (Weds-Fri) online 9:00-5:00 Eastern (14:00-22:00 UTC) (click to see in your own time zone)