SQLBits 2014

Using SQL Servers AlwaysOn Availability Groups

In this session we will look at the features which are provided with Microsoft SQL Server 2012 and 2014 as part of the "AlwaysOn" features including site to site configurations to allow of a large scale high availability solution.

In this session we will look at the features which are provided with Microsoft SQL Server 2012 and 2014 as part of the "AlwaysOn" features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution.

Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database.  We will also look a unique use case using SQL Server 2012's Always On feature to scale out the reads to synchronous read only copies.