SQL 11 HADRON Learning Series – part 5

Microsoft CSS team released a new post of their learning series on SQL Server 11 HADRON. In this article they share how is the synchronous commit request processed and what is behind the scenes of that process. You can read the article here.


SQL 11 HADRON Learning Series – part 4

CSS SQL Escalation Services are continuing their learning series on SQL Server 11 HADRON. In their latest article they write about page level repair and its enhancements in the latest release. It also shows and some new features of the SSMS GUI introducing the “Resource Assistant” and the colorful timeline thingy Smile

The article can be read here. Enjoy! Winking smile

Step-by-step setup of Always ON (HADR ON) feature in SQL 11 (video)

Following is a video of a step-by-step setup of SQL Server 11 AlwaysOn availability group feature from Gopal Ashoc (Product manager for SQL Server High Availability). The video demonstrates both enabling and configuring the Failover cluster and configuring SQL Server HADR ON with adding databases to the availability group.

You can watch the video on Youtube here.


SQL 11 HADRON Learning Series–part 3

The latest post from this series discusses running consistency checks on a replica database. Most of you probably have struggled with running DBCC on a production database on regular basis so I have to say this new possibility kind of eases every DBA having a VLDB that has to be checked.

You can read the full article here.


SQL 11 HADRON Learning Series–part 2

The second article from the series is on new DMVs supporting the HADRON. You can read it here.

As noted in the article, these series are based on the pre-release of SQL Server 11 so take that into consideration when you read it.


SQL 11 HADRON Learning Series

Here is a beginning of a series provided by CSS Escalation Services that targets the new feature of SQL Server Code Name “Denali” or SQL 11. The series is aiming at providing description of HADRON from supportability perspective.

Here is the link to the article: http://blogs.msdn.com/b/psssql/archive/2010/12/07/alwayson-hadron-learning-series-what-is-hadron.aspx

It is definitely something you would like to follow so you can get familiar with the support of all new coming with the new SQL Server version.