My Top Ten Lessons From SQL Saturday #31 Chicago

19 April, 2010 (11:50) | SQL, SQLSaturday | By: Mark V

I attended SQL Saturday Chicago this weekend. I had an awesome time and attended great sessions. While I got something good out of every one of the sessions, I decided to distill the entire experience into a top ten list with some of the highlights.

SneakersOnWire

10. According to Google Maps, the distance from Grand station on the CTA Blue Line to Navy Pier is 2.1 miles. I learned this after #8 below.

9. According to Google Maps, the distance from Navy Pier to Grand station on the CTA Blue Line is 2.1 miles. I learned this after #8 below.

8. Just like with shrinking databases, the fact that you CAN walk the distance in #10 above and then walk the distance in #9 above (all in under 2 hours, to ensure you will make it back to the airport in time to catch the last shuttle back to the hotel) does not make it a good idea to do so. AND, just like shrinking a database can affect its future performance, the walk mentioned above created soreness that is definitely affecting my current walking performance. But hey, while I was walking I did what anyone else would do: I asked myself, "What would Forrest Gump do?" Keep on goin’ is what. 

7. A good tip from Jeremiah Peschka ( Twitter | Blog ) is to create variables for commonly used strings (like creating new lines, or escaping single quotes) when building dynamic SQL to keep your code as readable as possible.

6. Kevin Kline ( Twitter | Blog ) pointed out that mixing DDL and DML within a stored procedure will cause recompiles, which can add significantly to resource consumption and execution time.

5. If it is a chilly Friday night in April around 8pm and you buy a churro from the little churro hut on Navy Pier, they may just offer you a second one for free as they are closing up anyway. Sweet. A little fuel for #9 above.

4. Before Andrew Karcher’s ( Twitter | Blog ) presentation on MDX, I knew jack about MDX (I could usually spell it properly, but that’s about it). Now, thanks to him, I don’t know jack anymore. Wait. I mean I now understand the basics that were a mystery to me before. Yeah. The second one.

DevilsTower3. Arie Jones ( Twitter | Blog ) pointed out something I had not read concerning SQL Server 2008 R2 Reporting Services. When exporting to multiple worksheets in Excel, R2 allows you to name those worksheets without sacrificing black cats or running off to Devil’s Tower with Richard Dreyfuss. Hazzah to the product team for adding this. Hazzah, I say!

2. When doing Karaoke in a room full of geeks, requesting Barry Manilow’s Copacabana and substituting Weird Al Yankovic’s Star Wars Cantina lyrics can go over well.

1. Wendy Pastrick ( Twitter ), Ted Krueger ( Twitter ), Jes Borland ( Twitter ), and many others worked hard to put on a great SQL Server event. They succeeded quite well, indeed. Thanks so much to all organizers, volunteers, and presenters.

Comments

Pingback from Tweets that mention BLOG] My Top Ten Lessons From SQL Saturday #31 Chicago: #sqlsaturday #sqlsat31 — Topsy.com
Time April 19, 2010 at 11:57 am

[…] This post was mentioned on Twitter by Mark Vaillancourt. Mark Vaillancourt said: [BLOG] My Top Ten Lessons From SQL Saturday #31 Chicago: http://bit.ly/cbjIrO #sqlsaturday #sqlsat31 […]

Comment from Dan English
Time April 19, 2010 at 12:10 pm

Google Maps? What is that? I only Bing. Get with the program man…j/k

Comment from Janice Lee
Time April 19, 2010 at 1:21 pm

“What would Forrest Gump do?” I thought you’d say “run”. :) Probably not a good idea after all that walking, huh?

Good post. :)

Comment from Mark V
Time April 19, 2010 at 1:38 pm

It was on my Iphone, too. Even better…hehe

Comment from Mark V
Time April 19, 2010 at 1:38 pm

Yeah, Janice, running not really an option right now…holy cow…

Thanks much.

Trackback from uberVU – social comments
Time April 19, 2010 at 1:40 pm

Social comments and analytics for this post…

This post was mentioned on Twitter by markvsql: [BLOG] My Top Ten Lessons From SQL Saturday #31 Chicago: http://bit.ly/cbjIrO #sqlsaturday #sqlsat31…

Pingback from Upcoming Presentation: SQL Saturday 67, Chicago! | Mark V SQL
Time March 9, 2011 at 11:43 am

[…] I will be presenting! Woohoo! I attended this event last year, which you can read about in my post My Top Ten Lessons From SQL Saturday #31 Chacago. It was such a great event and I am really proud to be a presenter this time […]

Write a comment