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 » management studio   (RSS)
Showing page 2 of 5 (43 total posts)
  • How to find missing indexes quickly in SQL Sentry Plan Explorer

    This question came up on twitter, and I thought a quick blog post would be better than a series of 140-character snippets. Management Studio does not do the best job at highlighting missing indexes. If you have a simple query plan that represents a single statement, no problem; however, if you have a plan that represents a multi-batch statement, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 17, 2011
  • Connect Digest : 2011-08-08

    This week I reported a few bugs - one with sp_helptext, one with Activity Monitor in Management Studio, and one in the new sys.dm_server_services DMV.#683234 : sp_helptext treats non-system objects as system objects For this one there is at least one weird case where running sp_helptext against on object prefixed with dbo ignores the dbo and tries ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 8, 2011
  • SQL Sentry Plan Explorer : New release and an SSMS add-in

    Today we released a new build of SQL Sentry Plan Explorer. The build # is 6.2.34 and you can download it from the usual location. Plan Explorer Changes The updates in this release include the following: A new ''Check for Updates'' feature accessible via the Help menu: Other new additions to the Help menu: Enable/disable the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 3, 2011
  • SQL Server v.Next (Denali) : Getting Ctrl+R to work again

    Ctrl+R is a good friend of mine - we go way back. It is very handy to use this command not only to hide the results pane away and focus on the query at hand, but to also be able to bring the results back just as quickly - without having to run the query again, or mess with click + drag nonsense. In Denali, we get a new version of SSMS, tightly ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 14, 2011
  • Connect Digest : 2011-04-11

    This week I decided to focus on some of the long-outstanding issues with IntelliSense in Management Studio. While I know many of you are using 3rd party tools like RedGate's SQL Prompt, not everybody has that luxury - in my case, I can't justify a license for every single server I touch, since I can't connect to every environment using SSMS ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 11, 2011
  • Connect Digest : 2011-03-26

    This week I have collected five important bugs involving Management Studio, and I hope you'll visit them, provide input and vote on the ones you think are worthwhile. #651176 : SSMS tries to access disconnected network drives when in the Save File As wizardPaul Randal (blog | twitter) filed this issue when he experienced significant delays trying ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 26, 2011
  • SSMS Tools Pack now supports Denali CTP1

    Earlier today, Mladen Prajdić (blog | twitter) released an updated version of his SSMS Tools Pack (v.1.9.4), a free add-in for Management Studio that provides a ton of helpful functionality that isn't available with the native tools.  I'm really glad this happened, because I've installed Denali on all of my VMs and have been using it for most ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 28, 2010
  • SQL Sentry Plan Explorer : Version 1.1!

    Last week, Microsoft offered up an early Christmas present: SQL Server 2005 SP4.  This week, it's SQL Sentry's turn to play Santa Claus: several new features and fixes have been packaged up into SQL Sentry Plan Explorer 1.1 (build 6.0.67.0). So, what's new?  Several wish list items have been fulfilled (hey, it is Christmas, after ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 22, 2010
  • SQL Server v.Next (Denali) : More on contained databases and "contained users"

    One of the reasons for contained databases (see my previous post) is to allow for a more seamless transition when moving a database from one server to another.  One of the biggest complications in doing so is making sure that all of the logins are in place on the new server.  Contained databases help solve this issue by creating a new ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 10, 2010
  • SQL Server v.Next (Denali) : Another SSMS bug that should be fixed

    Sorry to call this out in a separate post (I talked about a bunch of SSMS Connect items the other day), but Aaron Nelson (blog | twitter) jogged my memory today about an issue that has gone unfixed for years: the custom coloring for Registered Servers is neither consistent nor global. For one of my servers, I've chosen a red color to show in the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 1, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement