The Agenda

Ever since it was introduced in SQL Server 2012, availability groups (AGs) have been a source of interest, curiosity, and confusion. We’ve hit a point where many are seriously evaluating and looking to use AGs, but they are deceptively easy to deploy. While AGs share some common traits with both database mirroring and clustered instances of SQL Server (FCIs), the feature is its own entity. This full day pre-conference session will focus on getting you up to speed with AGs in SQL Server 2012 and 2014. Some of the major topics include:

• The real difference between FCIs and AGs – one of the sources of confusion since they both use an underlying Windows Server failover cluster (WSFC)
• Planning a WSFC for an AG deployment, including things like networking and hybrid scenarios that involve the cloud
• WSFC quorum for AGs
• Failure scenarios and how to recover from them
• Tips, tricks, and best practices for deploying AGs and their administration

If possible (dependent upon venue and cost), an AG lab may be possible during the day. Details will follow.