How check for active trace flags in SQL Server

Dear reader, thanks for visiting!

The post has been moved to my new blogging site – http://www.mssqlinsider.com.

You can read the complete post there.

Advertisements

SQL 11 HADRON Step-by-step setup guide by CSS

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.

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.

SQL 11 or the new SQL Server CTP

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 Smile