Presentation: Architecting Availability Groups

architecting-availability-groups-page-banner

Track: Database Administration / Data Architecture

Level: 200 – 300

Abstract:

You are a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you are considering AlwaysOn Availability Groups. This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over cluster instances, multi-subnet, and a hybrid approach that I call disaster-recovery-on-the-cheap. It will also include their exclusive features such as read-only routing and backup off-loading. In addition, you’ll learn how to use the Availability Group Listener correctly and why you should be using Windows Server 2012 R2 or above, along with some of my own personal lessons learned.

Presentation recording

Materials

Conferences I have presented at

SQLSAT386_SPEAKING sqlsat500_logo_small SQLSat526

Some feedback I have received

sqltheron-feedback

ag-feedback-1ag-feedback-2 SQLSatBoston-500-medium

SQLSAT526 Feedback