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:
- 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.
- 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).
- 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!
UPDATE 2: A screen shot demonstrating the multi-object action capabilities of Object Explorer Details. Click to embiggen.
File Attachment: SSMS.pdf.zip