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 2 of 10 (97 total posts)
  • New Versions of SSMS and SSDT Available

    It’s Release Day! :) New versions of SQL Server Data Tools (SSDT) are available here. SSDT 16.5 and 17.0 (RC1) are available. Also available are Data-Tier Application Framework (DacFx) versions 16.5 and 17.0 (RC1). New versions of SQL Server Management Studio (SSMS) are available here. SSMS 16.5 and 17.0 (RC1) versions are available for ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 16, 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
  • Books Online for SQL Server 2016

    This one is for those of you who prefer to use a local SQL Server Documentation, a.k.a. Books Online (BOL), instead of using the web-based BOL. A local BOL is essential for me. Navigating the contents, switching between pages and searching is lightyears ahead and quicker in the local BOL. (Update: Added bits about the missing ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on June 30, 2016
  • Restoreability and SSMS

    I have written about this before, how SSMS generates restore commands that will fail. This post is about showing what it might look like using screenshots. If you always use T-SQL directly to do restore, then you won't be affected by this. But if you expect to be able to perform restore using the restore dialog, then read on. The problemThe issue ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 16, 2016
  • Ctrl-R Not Working in SSMS After a Patch?

    I whined about this recently on Facebook. After that, I did something practical: I searched for a solution. I found a workaround at Connect: Open SSMS Select "Tools", "Customize..." - Click "Keyboard..." - In the list window, scroll down and select "Window.ShowResultsPane" - Under "Use ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 7, 2013
  • Connect Digest : 2012-07-06

    I've filed a few Connect items recently that I think are important. In #752210, I complain that the documentation for DDL triggers suggests that they can prevent certain DDL from being run, which is not the case at all.      ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 6, 2012
  • Comparing multiple plans in SQL Sentry Plan Explorer

    I’ve seen the question a few times now: “How do I compare two plans side-by-side in Plan Explorer?” Management Studio allows you to view multiple graphical plans that are visible simultaneously, either by generating plans for every statement in a batch, or by generating plans in separate query windows and then splitting the panes. However, at ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 6, 2012
  • T-SQL Tuesday #25 : T-SQL Tips 'n' Tricks

    This month's T-SQL Tuesday is being hosted by Allen White (@SQLRunr) and is about sharing your T-SQL tips and tricks. Since I know many people will share their T-SQL magic and wizardry, I thought I would share a couple of productivity tips - so still T-SQL related, but more how to take advantage of some features in SSMS. Drag column list onto ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 13, 2011
  • Connect Digest : 2011-12-01

    Where is my graphical ShowPlan? Many of you on SQL Server 2008 R2 are experiencing a major annoyance with SSMS since installing service pack 1 - when clicking a plan from grid results, you get raw XML instead of the graphical plan. I wrote about this symptom and a workaround in a previous post. In the original Connect item, they state that it ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 1, 2011
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement