Introduction to SQL Server 2012 AlwaysOn The content in this unit provides an introduction to SQL Server 2012 AlwaysOn, a new high avialability and diaster recovery solution. Hands-On Labs Working With SQL Server 2012 AlwaysOn Availability Groups (RTM Update) In this lab, you will learn to use the new Availability Group feature in SQL Server 2012 to provide a high availability and disaster recovery solution to an application with multiple databases. This lab will teach you how to create an Availability Group and how to configure a virtual name to allow the application to seamlessly failover. You will also learn how to monitor the Availability Group status using the new management views. Videos Presentation: Introducing High Availability and Disaster Recovery with SQL Server 2012 AlwaysOn This presentation provides an overview of the new high availabilty and disaster recovery capabilities provided by SQL Server 2012 AlwaysOn, including Availability Groups, partial containment and contained users. Demo: Configuring SQL Server 2012 AlwaysOn Availability Groups (part 1 of 2) This demonstration shows how to create a SQL Server 2012 AlwaysOn Availability Group and how to add an additional replica to an existing Availability Group using the SQL Server Management Studio Availability Group wizards. Demo: Configuring SQL Server 2012 AlwaysOn Availability Groups (part 2 of 2) This demonstration shows how to create a SQL Server 2012 AlwaysOn Availability Group and how to add an additional replica to an existing Availability Group using the SQL Server Management Studio Availability Group wizards. Presentation: SQL Server 2012 AlwaysOn Availability Group Connectivity This presentation covers application connectivity to AlwaysOn Availability Groups using Availability Group Listeners. Demo: Configuring a SQL Server 2012 AlwaysOn Availability Group Listener This demonstration shows how to configure an Availability Group Listener for a SQL Server 2012 AlwaysOn Availability Group. The Availability Group Listener provides the Virtual Network Name that enables the automated seamless failover capabilities to applications using the Availability Group databases, as well as the read-only routing capabilities for Read Only Secondaries. Presentation: Introducing SQL Server 2012 AlwaysOn Readable Secondary Replicas This presentation provides an overview of SQL Server 2012 AlwaysOn support for readable secondary replicas which can help maximimize hardware utilization by servicing read-only workloads like backup and reporting. Demo: Maximizing Hardware Utilization with SQL Server 2012 AlwaysOn Active Secondary Replicas This demonstration shows how to configure an Availability Group environment for Partially Contained Databases to allow for easy failover from one Replica to another, as well as how to configure Readable Secondaries in an Availability group to maximize the utilization of the hardware in the environment by offloading Read Only workloads to the Secondary Replicas. This demo will show how to extend the automated seamless failover capabilities to Read Only applications using the Availability Group Listeners Read Only Routing capabilities. Presentation: Introducing SQL Server 2012 AlwaysOn Failover Clustering This presentation provides an overview of failover clustering imporvements introduced in SQL Server 2012 AlwaysOn. Demo: Configuring SQL Server 2012 AlwaysOn Failover Clustering This demonstration shows how to configure the flexible failover policy for SQL Server 2012 AlwaysOn Failover Clustering.