locked
SSMS 2012 enhancements?

    Domanda

  • What SSMS enhancements can we look forward to in SQL 2012?  Interested to know which current RedGate products Microsoft is going to obsolete by embedding similar functionality in SSMS 2012.

     

    thanks

    venerdì 13 gennaio 2012 04:01

Tutte le risposte

  • 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, esquel@sommarskog.se
    venerdì 13 gennaio 2012 22:43
  • Please go through this blog it lists all the enhancements in SSMS 2012

    http://www.codeproject.com/Articles/162614/An-Introduction-to-Sql-11-Code-Name-Denali-Part-I

    We have debugging enhancement in SSMS 2012 mostly all the features available for .NET developers.go through this for debugging

    http://www.mssqltips.com/sqlservertip/2410/sql-server-denali-tsql-debugging-enhancements/

    we have intellisense enhancements in 2012.please through this blog  for intellisense

    http://blogs.msdn.com/b/managingsql/archive/2011/01/04/t-sql-intellisense-enhancements-in-ssms-denali.aspx

    PLEASE MARK AS ANSWERED OR VOTE AS HELPFUL IF IT RESOLVES.


    s dhwani

    domenica 12 febbraio 2012 02:37
  • 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