SQL Server Always On Availability Groups: The Senior DBA’s Ultimate Field Guide
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 program is specifically designed for senior database administrators and systems engineers responsible for deploying and managing a SQL Server Always On Availability Group.
In this live 4-week hybrid consulting and coaching program, you will learn:
- 1) The simple and easy way to understand 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
- 2) How to design and implement a stable, reliable and highly available Windows Server Failover Cluster to meet both high availability and disaster recovery requirements
- 3) How to design and implement a stable, reliable and highly available SQL Server Always On Availability Group solution for a single- or multi-data center deployments from the most common topologies without reinventing the wheel
- 4) How to leverage additional SQL Server Always On Availability Group capabilities such as readable secondary replicas, backup preferences, distributed availability groups and basic availability groups while minimizing Total Cost of Ownership (TCO)
- 5) Effective management and monitoring of SQL Server Always On Availability Group implementations
- 6) The secret to 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 12-year former 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.
Consulting Time: You can share your (sanitized) architecture diagram with the group for open consulting. You can ask for feedback about why the design might not be achieving your objectives, and get Edwin’s recommendations to improve your uptime. Don’t want to share your company’s design? No problem – you can still learn from watching the architectures and questions from other members. You can even ask about urgent production-facing issues that need quick solutions.
You will also get 1 year access to:
- SQL Server High Availability and Disaster Recovery. 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. 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. 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
- July 05 – 30, 2021 08:00 AM-10:00 AM Eastern time online (check in your own time zone)
This is a live online program. We host it in GoToMeeting, live with Edwin M Sarmiento on webcam, with a 10-minute break. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way.