THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSMS   (RSS)
Showing page 1 of 8 (78 total posts)
  • SSMS 17.3 is available for download

      The latest version of SSMS (SQL Server Management Studio 17.3) is now available to download. There are a bunch of new features in addition to the usual bug fixes but some of the more popular ones are a new wizard to import flat files, increased SMO & PowerShell support along with additions to the Query Store UI.  The full list is ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on October 10, 2017
  • SSMS 17.2 is now available

      The newest version of SQL Server Management Studio is now available for download. Lots of new features and fixes. The details and download links can be found here. Happy managing, Andy Kelly
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on August 7, 2017
  • Seldom Used Keyboard Tricks

      I was giving an internal talk on SSMS productivity trips and there were a few that I believe are seldom used but can be a real time or keystroke saver that I would like to mention. To the best of my knowledge these will work in any version of SSMS from at least 14.0 onward and likely earlier but I can’t verify older versions at this time. ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 22, 2017
  • SSMS Presenter Mode

    Recent builds of SQL Server Management Studio (SSMS) have a feature called PresentOn that can be accessed from Quick Launch. Figure 1. Quick Launch location in SSMS. Enter Present in to Quick Launch and select it. Figure 2. Select PresentOn. Using PresentOn is helpful when you give a presentation. It doesn’t increase the size of the ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 21, 2017
  • Explaining Activity Monitor

    This post is not about how to use the Activity Monitor (AM) tool in SQL Server Management Studio (SSMS) – there are loads of such posts written already. Also, it is not about dissing AM, you will find such posts as well. What I want to do is to explain the information in AM, for instance what time span the information covers. I see lots of ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 16, 2017
  • Latest SSMS Download (16.5.3)

      There was a slight issue with the SSMS version that was released a few days back (16.5.2) which has been fixed and replaced with release 16.5.3. If you want the latest SQL Server SSMS 2016 release or if you already loaded the 5.2 version you should get this one. SSMS 2016 Version 16.5.3 Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 27, 2017
  • A new (to me, and possibly you) SSMS feature - Query Plan Comparing

    Wow, Microsoft has really changed in culture recently. This new rapid release cycle for SSMS is seemingly paying dividends in a major way. In a recent build of SSMS (okay, perhaps not "recent", more like this October of 2015, according to this blog by the MSSQL Tiger Team:), they added the ability to compare query plans. I tried it on a ...
    Posted to Louis Davidson (Weblog) by drsql on January 26, 2017
  • Source Control for SSMS

      It would be awesome if we could use source control such as TFS directly in SSMS like we can in Visual Studio but at the moment we can’t for the reasons explained by Ken Van Hyning in this blog post.  However he also explains how we can manually add some components that will give us the ability to use TFS with SSMS in the mean ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on November 25, 2016
  • SSMS release 16.4 is now available

      The newest release of SQL Server Management Studio (SSMS) is now available. The details and download link can be found here. If you haven’t already downloaded or tried the new SSMS I highly recommend getting it and giving it a whirl. With the new release cycles we will see new features and bug fixes on a regular basis. Enjoy. Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 20, 2016
  • July SSMS 2016 changes transaction semantics

    This can be a very nasty one if you're not observant. The July update of SSMS now has the option to change XACT_ABORT setting for a query window usingToolsOptionsQuery ExecutionSQL ServerAdvancedSET XACT_ABORTNow, exposing one more SET option can't be bad, right? But Erland Sommarskog found out that this is checked by default. Now, using ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 5, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement