Dear reader, thanks for visiting!
You can read the complete post there.
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.
Microsoft SQL Server code-named “Denali” – November CTP (or CTP 1) or the latest SQL Server engine was just released. You can download it from here.
So far I had no info on what to expect and I am eager to download the CTP and start playing. There is a bit of info already on what’s changed but I guess there’s a lot more to be released. Still there is somewhere to start the journey from: http://msdn.microsoft.com/en-us/library/bb510411(v=SQL.110).aspx
Well…happy downloading and let’s hope that the newer the better