Post reply

SSMS 2014 - anything new and noteworthy over SSMS 2012?

  • May 29, 2014 at 9:36 am

    #291746

    I just installed SSMS 2014, and it seems to be identical to SSMS 2012. Are there any new features or geewiz additions I might be missing? We don't use Azure which seems to be one of the big changes, so anything else?

    Thanks -- just curious 🙂

    Sam

  • May 31, 2014 at 12:01 pm

    #1718027

    The most noticeable thing so far is that it is ......:arrow:faster!

    😎

  • May 31, 2014 at 5:33 pm

    #1718046

    Hi Sam,

    There are few differences but will hardly be used in day to day life. I would not consider then new functionality or difference between SSMS 2012 and 2014, It's again old wine in new bottle 🙂 Below are few differences

    Under System Policies 2 new policies are added

    1) SmartAdminSystemHealthPolicy

    2) SmartAdminUserActionsHealthPolicy

    Under System Conditions 2 new conditions are added

    1) SmartAdminSystemHealthCondition

    2) SmartAdminUserActionsHealthCondition

    Under Facets 2 new states are added

    1) Smart Admin

    2) SmartAdmin State

    You can find what these new things will be used using below link:

    http://msdn.microsoft.com/en-us/library/dn449498.aspx

    Thanks..

    Sanjiv Vinaik

  • June 2, 2014 at 6:29 am

    #1718175

    the new OLTP memory engine which could make the application 20X faster. UPgraded 'Always on' with 8 sec instances and many more

  • June 5, 2014 at 6:40 am

    #1719182

    Ashif Shaikh (6/2/2014)

    the new OLTP memory engine which could make the application 20X faster. UPgraded 'Always on' with 8 sec instances and many more

    Those are features of the database engine and not SSMS.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • June 9, 2014 at 8:25 am

    #1720105

    It doesn't seem as much slower to start up as SSMS 2012 was compared to SSMS 2008 R2, particularly when starting multiple instances.

    It crashes/freezes/stalls a lot less than SSMS 2012 did (still worse with 2008 R2, but not as much worse).

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply