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!
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.
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