Please, Call Me Richard

Professional Development, T-SQL
I presented a session at the SQL Saturday event in Oklahoma City last weekend. The event itself was pretty good. The organizers put everything together pretty well and the venue was quite nice. Plus, since I grew up in Oklahoma (Tulsa), it was a chance to go home. The event was good, but my presentation went a little downhill. The name of the session is "Top Tips for Better Stored Procedure Performance." I should rename it to just say "T-SQL Query Performance" because it's not focused on stored procedures, but on queries. The presentation is 1/3 talking about how you write your queries, naming syntax, formatting, etc. The second 2/3 is all about common mistakes made in writing T-SQL such as using NO_LOCK everywhere, nesting views, joining and nesting multi-statement…
Read More

Tech on Tap v1.1 Wrap-up

SQL Server
The first ever Tech on Tap event was held on Saturday, January 27th, 2012 at the Stone Cellar Brewpub in Appleton, WI. If you weren’t there, well, you missed it. Notice that keyword in that earlier sentence, Brewpub. Yes, the Tech on Tap events (and there will be more) are specifically designed to mix Technology and Beer in a learning and networking event with a single focus. This first event was all about virtualization. The space where the event was held was the back bar of the Brewpub in a private room. The layout of the tables wasn’t perfect for presenting, but they were very conducive to networking. Other than that, the space was just excellent. The first presenter was Brian Lewis (blog) from Microsoft. He spoke about virtualization in…
Read More

Friday SQL Nugget #1

Professional Development
Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like you. We have a tagging theme started by Ted Krueger (blog|twitter) who I also used to like. The theme is: Deciding that I need to delete and start all over Lordy I hate this one. See, I find it easy to decide that I need to delete and start all over. My challenging task is persevering. But… here’s the rub. Because my challenge is persevering, I have a tendency to try to persevere when I really should be throwing in the towel. I don’t have a technical example of this ready at hand (I did mention it was the afternoon on a Friday, right?), but I do have a presentation…
Read More

PASS Summit 2012 Evaluation Results

PASS, Professional Development
I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not indifferent), feedback is a wonderful gift. Any time you appreciate a speaker, give them feedback. Any time you think a speaker could improve, give them feedback. Any time you hate a speaker, give them feedback. It’s really the best thing you can do. With that in mind, I have a huge stack of gifts in front of me here, the evaluations from the PASS Summit.Thank you very much to each and every one of the 160 different evaluations I received. I presented three times at the summit, once on a pre-con with Gail Shaw called “All About Execution Plans,” one time in a spotlight session called “DMOs as a Shortcut…
Read More

St. Louis SQL Server Users Group Feedback

Misc
You know I share what feedback I get from conferences. I don’t usually get feedback from users groups (well, I do, but it’s seldom written down and the bruises heal eventually). The St. Louis SQL Server Users Group did collect information. Since I share the other stuff, I may as well share this too. They didn’t have a metric. It was just written down comments. Here are a few, my comments, as usual, will be in parenthesis: Enjoyed the demos; Everything worked (ditto, the enjoying demos working part) Good speaker; just dislike presentations w/ remote speakers.(Me too. I prefer interaction. I like seeing heads nodding or shaking or eyes rolling up so I know if I’m covering things well enough. Remote presentations are hard & can be very boring to…
Read More

Presentations in Action

Misc
The first book I read for my 12 goal oriented books was Jerry Weissman’s Presentations in Action: 80 Memorable Presentation Lessons from the Masters. Up front, let me say, this book met my expectations. I expected to see a lot of things I already knew. I expected to learn a few new things. What I didn’t expect was more books for my reading list. The book is broken down into 80 little stories and these are grouped into five sections talking about Content, Graphics, Delivery Skills, Q&A (dealing with it, not your questions), and Integration. The sections made a lot of sense even if a couple of the stories felt like they had been sort of shoe-horned into the section. Most of the stories made a lot of sense, and…
Read More

SQL Saturday #67 Wrap-up

PASS
Just… Wow. What an event. What a great group of people. I’m just so lucky to be involved with fantastic individuals like these. Thanks for having me out to play everyone, I really appreciated it. SQL Saturday #67 started for me with my second FreeCon (follow the link for details on the first one). Brent Ozar (blog|twitter) put together another great session where we spent a lot of time talking about blogs and blogging as well as swoops through other topics. We, by the way, is like a who’s who of great SQL Server people. I’m not going to post the list just in case everyone doesn’t want to be outed. However, I found the event extremely useful. I have a ton of notes and action items for myself and…
Read More

Upcoming Speaking Engagements

PASS
I've got a couple of more sessions before the big two at the PASS Summit. Tomorrow night, October 20th, I'll be speaking at the Southern New England Network Users Group on SQL Server Best Practices. It's the first time I've talked on this topic, so it might be fun to watch. After that I'm previewing one of my two Summit presentations for Brian Knight (blog|twitter) and Pragmatic Works in a webinar on Identifying and Fixing Performance Problems Using Execution Plans. Go here to register. After that, it's off the PASS Summit.
Read More

Sarasota SQL Server Users Group

Uncategorized
Tonight I'm presenting for the Sarasota SQL Server Users Group. If you're interested in attending, you can join in using this link. The topic will be "Query Performance Tuning 101." And in case you can't make that, Thursday, June 17th, I'll be on Quest's Pain of the Week. It should be fun too.
Read More

SQL Connections

Uncategorized
I'm flying off to the SQL Server Magazine Connections part of DevConnections in Las Vegas later this afternoon. I'm presenting three sessions while I'm there, Wednesday & Thursday. I'm hanging around on Friday. Please track me down if you want to chat. Wednesday I'll be putting on "Scouting Out Execution Plans" in the morning, 9:30-10:45AM. Thursday I've got two sessions, "MUQT: More Unnecessary Query Tuning" from 8:00-9:15AM (which should be a lot of fun at a developers conference), and "DMV's for Performance Tuning" from 11:45-1:00PM. I've brought bribery material (signed books) to encourage interaction, so please stop by, ask questions, make comments, just don't throw things (except for money). I'll blog a recap of each day from my point of view. I won't be live-blogging the key notes because I'm not registered…
Read More