Class 2 – Mission Critical Availability - Availability Groups and Failover Clustering

This course is level 300 - 400 and is targeted at an audience of DBAs, Developers & Architects.

Businesses today expect a database platform that will always be available and protected against the most likely planned and un-planned causes of downtime. Fortunately, for the SQL Server professional, there are now many tools and features that Microsoft include in the SQL Server product that can be used to meet that availability requirement.

This session discusses and demonstrates the AlwaysOn high availability features in SQL Server 2012, specifically failover cluster instances and availability groups. Their benefits, considerations, and limitations will be reviewed along with common architecture patterns for their deployment.

  • Module 1: Defining and meeting availability requirements(45 minutes)
    This module looks at how to define the availability requirements of a database platform and the terms used to define those requirements such as recovery time objective, as well as considering the difference between high availability and disaster recovery. The module then reviews some of the generic technologies used to deliver high availability, such as load balancing, clustering and mirroring.
  • Module 2: AlwaysOn Failover Clustering Instances, including Windows Failover Clustering (80 minutes)
    Here we review the capabilities of failover clusters, and importantly, why despite being a mature technology they are still an important tool in the high availability toolbox. As well as discussing and demonstrating a SQL Server failover cluster, the pre-requisite knowledge about Windows failover clusters is also covered.
  • Module 3: AlwaysOn Availability Groups, including Readable Secondaries (90 minutes)
    Module 3 focusses on a new feature of SQL Server 2012, Availability Groups, and looks at their capabilities and how they work. Demonstrations of using Availability Groups to provide both highly available database platforms and real-time reporting data reinforce the knowledge just taught about them.

Dates: Friday 26th October 2012

Veune: Microsoft Auditorium, EPDC2, South County Business Park

Registration: 13.00 – 13.30

Class: 13.30 – 17.30

€100 if booked individually or €350 for entire series

For further information contact: or call 01 2933883

Register Now


  • Gavin Payne

    Gavin Payne

    Gavin is a Microsoft Certified Master and Senior Consultant working for Coeo, a UK Consultancy & managed services provider dedicated to SQL Server. His blog can be found at


  • Prodata SQL Centre of Excellence
  • Microsoft

Other Information