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.
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
The article can be read here. Enjoy!
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.
The following step-by-step guide is provided by Microsoft SQL Server CSS engineers based on the CTP version of SQL Server 11 or code-name Denali. The guide can be found here.
I urge you to read it and just note some of the specifics which probably will not be changed upon final release of the product. I am talking about things like HADRON instances are stand-alone instances, you must first enable the feature on service level and creating availability groups. Some of the screens/features/setting might be changed or removed by the time the RTM is released but still this is as much as we can get with the current version.
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.
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.
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.