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 4 of 8 (78 total posts)
  • 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
  • SQL Server v.Next (Denali) : Some Management Studio bugs you should vote for

    It's been a while since I hosted a true Connect pity party digest, trying to pimp your votes for the issues I think are worthwhile.  And okay, some of these bugs haven't been filed in the Denali time frame - but those are still in Denali's version of SSMS.  And since we are not expecting a release for a year, and the next CTP won't be ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 29, 2010
  • Debugging T-SQL in SQL Server v.Next (Denali) : You can make a difference!

    This afternoon, Adam Machanic (blog | twitter) reminded me how the current T-SQL debugger in Management Studio is ineffective.  Sure, there are some enhancements coming in Denali (I mentioned them briefly yesterday), but there are some real key elements missing.  One of the most glaring omissions is the ability to see the contents of ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 24, 2010
  • SQL Sentry's Plan Explorer : a closer look

    Today I was digging more into SQL Sentry's Plan Explorer, and I continue to discover little things I think you will find valuable in your performance tuning and troubleshooting efforts. Let's say I am analyzing a plan for a relatively simple batch: SELECT * FROM sys.objects;CREATE TABLE #foo([object_id] INT, def NVARCHAR(MAX));INSERT ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 27, 2010
  • Useful, free resources for SQL Server

    Recently Dave Ballantyne posted a list of free resources for SQL Server, entitled ''The best things in life are free.''  Now, I'm not trying to upstage Dave, but I know of several resources that aren't on his list.  It would be good to have a true community page for this kind of thing, but for now a blog post will have to do.  [I ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 26, 2010
  • A first glimpse of SQL Sentry's Plan Explorer

    Yesterday, Greg Gonzalez (blog | twitter) announced a beta project for SQL Sentry's latest offering: Plan Explorer.  I have been playing with the early versions of the beta, and I can tell you that DBAs should be very excited about having this tool in their arsenal.  This is a free companion to SQL Server Management Studio that greatly ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 21, 2010
  • SSMS : Which parts do you love? Which parts do you hate?

    I find myself categorizing a subset of SSMS features ranging from ''must have'' features to ''cringe when they are mentioned.''  I'll try to summarize the standouts for you here, then ask you these questions: Which parts of SSMS do you rely on? Which do you wish were not there at all? The ''I almost always use it to get the task done.'' ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 22, 2010
  • Kill your temp tables using keyboard shortcuts : SSMS

    Here’s a nifty little SSMS trick that my colleague Tom Hunter educated me on the other day and I thought it was worth sharing. If you’re a keyboard shortcut junkie then you’ll love it. How often when working with code in SSMS that contains temp tables do you see the following message: Msg 2714, Level 16, State 6, Line 78 There is ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 18, 2010
  • Updated slide decks from SSMS presentation at SNESSUG

    Tonight I spoke at the SNESSUG user group meeting in Warwick, RI.  You can download the slide deck here (this is a 3.5 MB PDF with presenter notes):http://sqlblog.com/files/folders/23423/download.aspxIf you attended the talk, please feel free to provide feedback at speakerrate.com: ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 15, 2010
« First ... < Previous 2 3 4 5 6 Next > ... Last »
Privacy Statement