They now use the VS2010 Shell. Whether that is an improvement is a matter of taste, I guess. But there is now an option so that new tabs are place rightmost. But the tab order is still messed up if a tab falls out of sight.
You now have the full power of customising the keyboard. But the customisation dialogue is just as difficult to use as it is in VS. And there is no built-in keyboard mapping for SQL 2000 anymore, which is bad.
If you like Intellisense, I think they claim to have improved it. (I don't use it, so I can't judge.)
There is a new "Profiler" that uses Extended Events, which is the new trace facility in SQL Server going forward. From a GUI perspective, the Extended Events node is more difficult to use I think, but that is also because X-Events are more powerful.
There is a learning curve. Profiler is still there, but since SQL Trace is deprecated, there are no enhancement to it.
There is also support for AlwaysOn, the new HA/DR features in SQL 2012.
The big news on the tool side is SQL Server Data Tools, an add-in to Visual Studio with a powerful T-SQL Editor. It will require you to work in a certain way, but it can help you find many errors that you else would not have found until run-time because
of deferred named resolution.
Erland Sommarskog, SQL Server MVP, firstname.lastname@example.org
Is it possible to use Team Foundation Server to check in and out files (SSIS, SSAS, SSRS) in SSMS 2012?
giovedì 1 marzo 2012 18:49
Microsoft sta conducendo un sondaggio in linea per comprendere l'opinione degli utenti in merito al sito Web di Msdn. Se si sceglie di partecipare, quando si lascia il sito Web di Msdn verrà visualizzato il sondaggio in linea.