SSMS 2012 enhancements? RRS feed

  • Question

  • 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.



    Friday, January 13, 2012 4:01 AM

All replies

  • 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
    Friday, January 13, 2012 10:43 PM
  • Please go through this blog it lists all the enhancements in SSMS 2012


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


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



    s dhwani

    Sunday, February 12, 2012 2:37 AM
  • Is it possible to use Team Foundation Server to check in and out files (SSIS, SSAS, SSRS) in SSMS 2012?
    Thursday, March 1, 2012 6:49 PM