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 10 (96 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
  • Quick Regions in SQL Server Management Studio (SSMS)

    There are a few tools and add-ins that support the creation of “regions” in T-SQL code. SQL Server Management Studio (SSMS) supports one way to separate sections of long-ish T-SQL scripts natively, by using begin/end: To demonstrate, start with a snippet of T-SQL that includes begin/end: If you click on the “-“ highlighted above, the code will ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 14, 2017
  • Creating SSIS Packages with the SQL Server Import and Export Wizard

    This material was originally posted on the Linchpin People blog. In this post, I demonstrate how to use the SQL Server 2012 Import and Export Wizard to create a SQL Server 2012 Integration Services (SSIS 2012) package. The demo is created on a virtual machine running Windows Server 2012. You can use the SQL Server Import and Export Wizard to ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 20, 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
  • SQL Server Management Studio (SSMS) v16.5.1 Now Available

    An updated version of SQL Server Management Studio (SSMS) for SQL Server 2016 (v16.5.1) is now available. :{>
    Posted to Andy Leonard (Weblog) by andyleonard on December 7, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement