THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Aaron Bertrand

Aaron is a Product Evangelist for SentryOne, makers of Plan Explorer and a performance monitoring and event management platform for the Microsoft Data Platform and VMware. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features, and also blogs at blogs.sentryone.com and SQLPerformance.com; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at major conferences, user group meetings, and SQL Saturday events worldwide.

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 single person in the room learned at least one new thing about SSMS.

I learned some things today too:

  1. I am still horrible at repeating audience questions before answering them.  I know before and after delivering a presentation that it's exactly what you should do, and understand that there are several reasons to do so (not all of which benefit the audience).  But in the heat of the moment, I'm usually spending too much time making sure I answer the question right, when I should be ensuring that the others have heard it.
     
  2. No matter how much you prepare a presentation (and especially the first time you offer the topic), there will always be things you forgot to include.  Today I talked about templates as an easy way to help encourage specific coding conventions and naming standards, but Tim Ford (@sqlagentman) reminded me afterward of one of the more direct features that you can utilize via templates: CTRL+SHIFT+M.  If you haven't used it, this pulls up a dialog allowing you to substitute parameters in your script, without having to do it by hand.  The parameter placeholders in your script have to match a specific format (some info about this here).
     
  3. I am a part of a fantastic community.  At events like this there is always great interaction, both with other MVPs and with the audience in general.  Unfortunately I could not commit to the entire day, but aside from my session I attended both Tim Ford's talk on DMVs and Mike Walsh's session on tuning T-SQL.  While I was more of a heckler than a contributor, I kind of felt at home in every session, and am looking forward to the next one.

I'll be giving the talk at SNESSUG in March, so I'll have plenty of time to work on my slide deck, and will hopefully take what I learned today into that presentation.  In the meantime, you are welcome to download the current version of the deck (I exported to PDF).  Some of the bullet points only make sense in the context of the talk, but several of the slides have speaker notes that might help elaborate.  Please let me know if you have any comments, questions or suggestions!

UPDATE: I just signed up on SpeakerRate.  If you attended this presentation, please feel free to leave me comments, either negative or positive!  Thanks!

http://speakerrate.com/talks/2075-management-studio-tips-tricks

UPDATE 2: A screen shot demonstrating the multi-object action capabilities of Object Explorer Details.  Click to embiggen.

 

Published Saturday, January 30, 2010 6:00 PM by AaronBertrand

Attachment(s): SSMS.pdf.zip

Comments

 

Roman Rehak said:

Yesterday I presented my "SQL Server Development Tips and Tricks" session at SQL Saturday #34 in Boston.

January 31, 2010 11:17 AM
 

Brian Tkatch said:

Didn't know about that template thing. Thanx!

February 1, 2010 9:32 AM
 

Sandeep Kalidindi said:

Thanks Aaron. It was a very imformative session and I am already putting some of the tips to use. I had asked if there was a shortcut key to bring up 'activity monitor' in SSMS 2008 and I found out there is. CTRL+ALT+A

February 3, 2010 10:58 AM
 

AaronBertrand said:

Thanks for the update Sandeep, sorry I wasn't aware of that keyboard shortcut.  (I use a 3rd party monitoring tool, SQL Sentry Performance Advisor, so I don't have that much experience with Activity Monitor.)

February 3, 2010 11:23 AM
 

Michael said:

Hi Aaron,

I enjoyed your talk in Boston.

At one point, I swear I saw you select multiple tables so that you could "script table as --> create to" for multiple tables at once.

I tried the same thing on my SQL Server 2008, and have not been able to select more than one table.

Do I need a newer version of SQL Server?  Or was there some trick?

Thanks,

Mike

February 4, 2010 11:09 AM
 

AaronBertrand said:

Hi Michael, you can do this by enabling the "Object Explorer Details" view.  (You can turn this on in the View menu of SSMS.)  If you highlight the tables node on the left in Object Explorer, on the right you can use CTRL or SHIFT to select multiple items.  With multiple selected, you can right-click and the actions available will be applied to all.  I've attached a screen shot to the original post to demonstrate.  The wording on the context menu is weird, because it *seems* like it is only going to run for one table, but it really does work.  The quickest to demonstrate is Script As > CREATE To > New Query Editor Window.

February 4, 2010 11:28 AM
 

AaronBertrand said:

Note that you can also filter this list and that there is a details pane at the bottom that shows you the total # of items as well as the # of items selected.  When you have an individual item selected this details pane shows a lot more information about the highlighted item, most of which you can also add to the view so that you can see the properties as columns.  Just right-click the column header and you can see the different properties you can toggle on or off.

February 4, 2010 11:29 AM
 

Michael said:

Ah, that's the secret.  I was trying to do it from the Object Explorer tree.  Cool.  Thanks.

February 5, 2010 7:30 PM
 

Linchi Shea said:

Boston is not nearby for me to attend Aaron’s presentation on Management Studio Tips & Tricks . But

February 12, 2010 8:53 PM
New Comments to this post are disabled

About AaronBertrand

...about me...

This Blog

Syndication

Archives

Privacy Statement