Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Tuesday, 15 July 2014

Pre-SQLBits - Bristol SQL Server User Group - July Meeting


Monday 14 July saw the Bristol User Group meet with Brent Ozar talking on Are AlwaysOn Availability Groups Right for You? It was amazing that Brent came to share his in depth knowledge on AlwaysOn. He shared the pros and cons of what needs to be considered when creating this type of database architecture solution.

Brent has an amazing set of resources covering AlwaysOn. These are  found
http://www.brentozar.com/sql/sql-server-alwayson-availability-groups/ 

The Microsoft guides I found useful were:-

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups
http://msdn.microsoft.com/en-us/library/jj191711.aspx

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
http://msdn.microsoft.com/en-us/library/ff929171.aspx

Comparison of Failover Cluster Instances and Availability Groups
The core concepts between FCIs and Availability Groups are compared in this table taken from http://msdn.microsoft.com/en-us/library/ff929171.aspx
 

For more details and caveats see the full article http://msdn.microsoft.com/en-us/library/ff929171.aspx

No comments:

Post a Comment

Note: only a member of this blog may post a comment.