Browse by Tags

• backups
• cdc
• community
• connect
• database list
• date formats
• Events
• express edition
• filegroups
• index maintenance
• indexes
• intellisense
• Katmai
• MRU
• next version
• Open Table
• paths
• presentations
• Registered Servers
• Screencast
• security
• server list
• shared hosting
• SQL Saturday
• SQL Server 2008
• SQL Server 2008 R2
• SQL Server 2011
• SSMS
• SSMSE
• statistics
• tips
• tricks

• SQL Saturday #33 : slide deck, recap and shout-outs

  [Sorry I have been a little absent over the past couple of weeks. Returning from the Olympics just a little over a week ago meant some busy catch-up and a heavy lead-in to today's event.] Today I spoke at SQL Saturday #33 in Charlotte, NC. My presentation...( Read More... Posted Sunday, March 07, 2010 12:14 PM from Aaron Bertrand | (Comments Off) Filed under: community, SSMS, Management Studio, presentations, SQL Saturday

• Management Studio Tips & Tricks, version 1.0

  Today I presented "Management Studio Tips & Tricks" at SQL Saturday #34 in Waltham, MA. I had an audience of close to 100 (my biggest talk yet!), and unless they were stroking my ego, I achieved my primary goal for the session: to make sure that every...( Read More... Posted Sunday, January 31, 2010 8:00 AM from Aaron Bertrand | (Comments Off) Filed under: community, SSMS, Management Studio, presentations

• Speaking at SQLSaturday #34 in Boston, 2010-01-30

  Just a quick reminder that I will be presenting a Management Studio Tips & Tricks talk at SQLSaturday #34, this Saturday, January 30th at the Microsoft offices in Waltham, Massachusetts. I go on at 9:30 AM. There are plenty of other great speakers,...( Read More... Posted Monday, January 25, 2010 7:56 AM from Aaron Bertrand | (Comments Off) Filed under: Events, Management Studio, SQL Saturday

• Quick poll : what is your favorite Management Studio tip or trick?

  I am putting together a presentation on SSMS Tips & Tricks, which I will debut at SQL Saturday #34 . I already have a pretty full slide deck, but I am not the be-all and end-all of SSMS, so in the interest of distributing this information as widely...( Read More... Posted Tuesday, January 05, 2010 10:01 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, tips, Management Studio, tricks

• November CTP of SQL Server 2008 R2 : Download now

  For those of you that have been wanting to try out SQL Server 2008 R2, you can download the November CTP of Express here (posted yesterday) and the full version of the November CTP here . This is version 10.50.1352.12. The full version is an evaluation...( Read More... Posted Thursday, November 12, 2009 8:44 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, Management Studio, express edition, SQL Server 2008 R2, SSMSE

• Connect Digest : 2009-10-02

  Welcome to October! This week I have five SQL Server items to point out to you, and two Connect-specific issues. /*------------------------------------------------------*/ SQL Server /*------------------------------------------------------*/ #331220 :...( Read More... Posted Saturday, October 03, 2009 1:56 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, indexes, backups, connect, Management Studio, filegroups

• For shared SQL Server providers : hiding your list of databases from customers

  In a shared SQL Server hosting environment, there are several problems that can arise when you let your customers use Management Studio to connect and administer their databases. In the typical case, you give them a single SQL Authentication username...( Read More... Posted Monday, July 20, 2009 1:26 AM from Aaron Bertrand | (Comments Off) Filed under: security, SSMS, Management Studio, shared hosting, database list

• Connect Digest : 2009-07-18

  I missed last week because I was having fun up in Canada... mostly without any kind of computer access at all. It was a nice break, but now I'm back in the thick of things again. So this week, I am going to try to beef it up a bit to compensate for last...( Read More... Posted Sunday, July 19, 2009 12:54 AM from Aaron Bertrand | (Comments Off) Filed under: security, Open Table, SSMS, statistics, connect, cdc, Management Studio, index maintenance, paths, date formats

• Why is IntelliSense not working?

  I see people complain that IntelliSense (new in SQL Server 2008's Management Studio) is not working. Most of the time, it is for one of two reasons: The object is not in the local IntelliSense cache, since it was created recently. You can fix this easily...( Read More... Posted Thursday, July 02, 2009 4:05 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, Management Studio, intellisense

• What to do when Management Studio hangs?

  I have had a few occasions where I have been using Management Studio, and am suddenly and bluntly informed by Windows that I am demanding too much of the application. Windows is probably right; and it is only partially due to the fact that SSMS can be...( Read More... Posted Friday, June 26, 2009 5:52 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, Management Studio

• Managing the MRU list for the "Connect to Server" dialog in SSMS

  I have seen many people ask for ways to delete entries from SSMS' "Connect to Server" server name list. The short and official answer is, you can't. There is an unofficial answer, though. Right now you have an all-or-nothing approach. In SQL Server 2005, Read More... Posted Thursday, March 19, 2009 12:55 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, Management Studio, server list, MRU

• Pushing for more tools-related fixes for SQL Server 2011

  A few days ago I posted a list of Management Studio issues I hope they will add or fix for the next version of SQL Server (or sooner). Comments there and elsewhere, as well as some afterthoughts, have led me to publish an addendum. Again I will present Read More... Posted Monday, August 25, 2008 1:59 PM from Aaron Bertrand | (Comments Off) Filed under: SSMS, SQL Server 2008, Management Studio, SQL Server 2011, next version

• My Management Studio wishlist for SQL Server 2011

  Inspired both directly and indirectly by fellow MVP Erland Sommarskog, whose programming wishlist I talked about the other day , I have decided to compile a list of my own wish list items, in the same spirit of, "it's never too early." This list is restricted Read More... Posted Wednesday, August 20, 2008 1:56 PM from Aaron Bertrand | (Comments Off) Filed under: SSMS, connect, SQL Server 2008, Management Studio, SQL Server 2011, next version

• Screencast: Katmai SSMS Manage Multiple Servers

  Katmai Management Studio has the Way Cool ability to send T-SQL to multiple servers with a single F5 Execute. Watch the Screencast (4:00). Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Friday, January 04, 2008 4:51 PM from Paul Nielsen | (Comments Off) Filed under: Katmai, SSMS, Screencast, Management Studio, Registered Servers