Tag Archives: SQL Server Denali

If you are aware of SQL Server Editions in the past versions of SQL Server, there is a slight changes in the line up of Editions in SQL Server 2012. It is slated to be released in the first half of 2012.There is one new Edition being introduced in SQL Server 2012 and few old ones are being retired.

The 3 main Editions are going to be Enterprise Edition, Business Intelligence and Standard Edition. The other Editions such as Developer, Compact and Express Editions are continued.

Business Intelligence Edition is a newer Edition announced for SQL Server 2012 and the Editions such as DataCenter, Workgroup Editions will be retired. Business Intelligence Edition supports up to 16 Cores and supports 2 Node Failover Clustering.

If you are using SQL Server Management Studio in SQL Server 2008, 2008 R2 or above, you can acces the previous versions of SQL Servers from the Management Studio as shown in the picture below. I am using SSMS in SQL Server Code-Named Denali (CTP 3) and I am connected to a SQL Instance of the same version as that of the Management Studio. I am also connected to another SQL Server which is SQL Server 2000.

In order to open the activity monitor, I right-click on the connected server (SQL 2000 here…) and choose Activity Monitor from the popup menu.

We get the following error indicating that we cannot access activity monitor of SQL Server 2000 instance inside Management Studio.

The reason for this is, SQL Server Activity Monitor in SQL Server 2008 and above, utilizes the Dynamic Management Views (DMVs) introduced in SQL Server 2005. Whereas, activity monitor in SSMS 2005 is designed for backward compatible so that we can still be able to work with SQL Server 2000.

Microsoft has released Community Technology Preview 3 (CTP3) for its next version of SQL Server code named Denali. As I had done in the past, I downloaded a copy and started exploring the new release. The below screen shot is the splash screen for the Management studio.

There are plenty of new features in this version of release. I look forward to share those as I stumble upon them.

Categories

Categories

Disclaimer

The opinions and views posted in this blog are purely my personal views, they do not endorsed or represented that of my Employer or by Microsoft SQL Server.

The code/scripts and any kind of tips published in this blog are "AS IS", though they have been tested before publishing on the blog. However when following any kind of advice available in this blog, or usage of the code the user should take due diligence, and the Author is not responsible for any kind of damages occurred due to the usage.