How many nines do we need? Introducing SQL Server AlwaysOn
With natural disasters like earthquakes and fires in the news so often, and the economy still struggling to stabilize, IT Professionals know that many disasters can shut down a SQL Server.
Microsoft has already implemented a lot of high availability solutions in previous editions of SQL Server, like failover clustering, database mirroring, log shipping,... But,when it comes to high availability, SQL Server 2012 changes the game for SQL Server deployments by introducing SQL Server AlwaysOn. You can increase application availability and get a better return on your hardware investments through a simplified high availability deployment and management experience.
In this session you will see the key capabilities and concepts of Database Availability and Instance Availability, deploying availability groups, configuration Application Failover using a Virtual Name, Initiating a failover to the secondary and possibilities with the active secondary.
Sorry, there are no downloads available for this session.
Pieter Vanhove is a SQL Server MVP and Database Consultant at
Kohera in Belgium and has been working with SQL Server since 2000. Performance
tuning, SQL audits, migrations and training are part of the job. Pieter has
also a profound knowledge in implementing high availability and disaster
recovery solutions and loves the new Azure stuff. Together with the SQLUG in
Belgium, he helps organizing SQL Server Days and is also a regular speaker at
Belgian and international events.
The video is not available to view online.