The SQL Server Management Studio that ships with SQL Server Denali CTP1 is based on the Visual Studio 2010 shell. One of the advantages you will see right away is that if you have multiple monitors you can drag a query window to another monitor. This is some great stuff because currently I have two and sometimes 3 instance of SSMS running at all times.
Here is an example, of three query windows which are floating, you can easily drag any of these to another monitor
One thing that currently doesn't work is that if you have a syntax error, you can't click on the error in the messages tab anymore to jump to the line that caused the error. The closest thing you now have is the Error List, press on CTRL + \, E to see it
The problem with the Error List is that it works on design/parse time, if you happen to get the same error as at execution time then you can click on the Error List item and it will bring you to the line with the error, otherwise you are out of luck.
Here is what Object Explorer looks like
As you can see it is pretty similar to what was there before, there is a new folder called Sequences, you can read about sequences in this post here: A first look at sequences in SQL Server Denali
In SQL Server Code Denali, you can deploy your Integration Services projects to the Integration Services server. The Integration Services server enables you to manage packages, run packages, and configure runtime values for packages by using
environments. Here is just a quick screenshot tour.
First thing you need to do is creating a catalog, right click on the Integration Services folder and select Create Catalog
I will leave you with a 3 minute video I took of me clicking around in the new SSMS. It has a HD version so make sure you click on that to get a better resolution
Click on the SQL Server Denali tag to see all our SQL Server Denali related posts