Upcoming Speaking Engagements

October 19, 2010 at 1:09 pm (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.

Permalink 1 Comment

Viva Las Vegas!

August 11, 2010 at 11:00 am (SQL Server 2005, SQL Server 2008, TSQL) (, , )

I won’t be going to Las Vegas, but I will be presenting to the Las Vegas SQL Server Users Group, S3OLV. The sesssion will be “Introduction to Execution Plans.” Please swing by if you’re in the area.

I’m not sure if they’ll make the LiveMeeting available to the public or if they’ll record the session. But if they do, please attend that way too.

Permalink Leave a Comment

Sarasota SQL Server Users Group

June 15, 2010 at 1:48 pm (SQL Server 2008) (, , )

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.

Permalink Leave a Comment

PASS Summit Content Survey Results

April 22, 2010 at 2:41 pm (PASS, SQLServerPedia Syndication) (, , , )

The results of a survey conducted by the PASS organization have been posted (thanks to the Board for all their work, again). Since getting to speak at PASS is a competition, I really shouldn’t be pointing this out, because I’d like to speak again. However, if you’re trying to decide whether or not a detailed discussion of Windows Server 2008 Collation would be more interesting to the attendees than a session on Filtered Indexes (it wouldn’t) you can go check it out on the survey. It should help you make better choices for what the attendees want to see. Of course, if everyone runs off and submits sessions on the same four or five topics, that’s going to open up others. Regardless, this is a service to the attendees because we should get more interesting sessions because of this survey. The survey is also a service to potential speakers because we’re going to be able to decide where to focus our efforts.

But you know what, I really don’t know what I’m talking about, so why don’t you just ignore me and get back to working on your slide deck on Collation, lots of people want to see it, really.

Permalink Leave a Comment

Connections Sessions Evals

January 13, 2010 at 9:09 am (SQL Server 2005, SQL Server 2008, TSQL) (, , , )

I’ve kind of been embarassed to post these despite the fact that I received them a couple of weeks ago. Overall, I’d say they’re very good, and I’m quite proud of them, but one comment still has me upset. Anyway, here we go:

DMV’s For Performance Tuning (same session as PASS): 7 responses

Q1. Speaker’s knowledge of topic
Your average score for this session: 4.0
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.74
Lowest score (all SQL speakers for this question): 3.0

Q2. Speaker’s presentation skills
Your average score for this session: 3.86
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.47
Lowest score (all SQL speakers for this question): 2.0

Q3. Content of Speaker’s slides/visual aids
Your average score for this session: 3.86
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.48
Lowest score (all SQL speakers for this question): 2.5

Q4. Speaker’s ability to control discussions and keep session moving
Your average score for this session: 3.86
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.53
Lowest score (all SQL speakers for this question): 2.33

Q5. Accuracy of session description
Your average score for this session: 4.0
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.5
Lowest score (all SQL speakers for this question): 2.33

Q6. Overall evaluation of this session
Your average score for this session: 4.0
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.5
Lowest score (all SQL speakers for this question): 2.25

Comments:
• I loved the session. Excellent information presented in a “fun” format.

My comments? What’s not to like? I love how you see the highest speaker score, the average speaker score and the lowest speaker score. This really allows you to place yourself in context to the other speakers (PASS, please take note).  Based on this, the only area that I think I need work is on controlling discussions… except I really like to have more discussions, so I’ll just have to watch the balance on this one.

Scouting Out Execution Plans: 18 responses

Q1. Speaker’s knowledge of topic
Your average score for this session: 4.0
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.74
Lowest score (all SQL speakers for this question): 3.0

Q2. Speaker’s presentation skills
Your average score for this session: 3.83
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.47
Lowest score (all SQL speakers for this question): 2.0

Q3. Content of Speaker’s slides/visual aids
Your average score for this session: 3.82
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.48
Lowest score (all SQL speakers for this question): 2.5

Q4. Speaker’s ability to control discussions and keep session moving
Your average score for this session: 3.72
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.53
Lowest score (all SQL speakers for this question): 2.33

Q5. Accuracy of session description
Your average score for this session: 3.88
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.5
Lowest score (all SQL speakers for this question): 2.33

Q6. Overall evaluation of this session
Your average score for this session: 3.88
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.5
Lowest score (all SQL speakers for this question): 2.25

Comments:
• Good session and overview of Performance Point.
• Please have Grant back next year!
• Great examples. Hope these are part of the slides that we will have access to. One of the best sessions at the conference.

Again, I’m pleased as punch by the evals and the comments. Assuming it’s not the week after the PASS Summit again, yes, please have me back next year. I think at least one eval here was mislabeled. Performance Point? Again, comparing my ability to control sessions with the average & max, I can work on this a bit. Now for the embarassment.

More Unnecessary Query Tuning: 16 Evals

Q1. Speaker’s knowledge of topic
Your average score for this session: 3.94
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.74
Lowest score (all SQL speakers for this question): 3.0

Q2. Speaker’s presentation skills
Your average score for this session: 3.69
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.47
Lowest score (all SQL speakers for this question): 2.0

Q3. Content of Speaker’s slides/visual aids
Your average score for this session: 3.56
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.48
Lowest score (all SQL speakers for this question): 2.5

Q4. Speaker’s ability to control discussions and keep session moving
Your average score for this session: 3.69
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.53
Lowest score (all SQL speakers for this question): 2.33

Q5. Accuracy of session description
Your average score for this session: 3.5
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.5
Lowest score (all SQL speakers for this question): 2.33

Q6. Overall evaluation of this session
Your average score for this session: 3.63
Highest score (all SQL speakers for this question): 4.0
Mean average score (all SQL speakers for this question): 3.5
Lowest score (all SQL speakers for this question): 2.25

Comments
• Very rude to participants.
• Good focus on useful topics.
• Hope you feel better, Grant.
• Clear examples that illustrated the problems and solutions.
• Great examples of common pitfalls to watch out for before there is a problem.

Very rude. This could be three things, only two that are under my control. I did actually have to walk out of this session, right in the middle of it for about 2 minutes because I was physically unwell (and that’s all I’m going to say). If that was how I was rude, I’m sorry, but things happen. But, maybe it was because I joke with audience. I talk about cowboy developers and hyper-control freak DBA’s and stupid support calls, really ignorant management decisions, nHibernate & Oracle. I make fun of all of them. Lastly, it could have been this topic. I’m calling your baby ugly in this one. I’m telling you that using NOLOCK hints, DISTINCT operators, WHILE loops & CURSORS, and any number of other silly crutches are hurting your performance and making it necessary to tune queries when they should just be written correctly to begin with. It’s one of these three. If it’s one of the two I can control, I’d sure like to do better. I’m frankly bothered by this.

This was my lowest eval of the three and I’m just bummed because I put the most work into this session. Still, it appears it was helpful for the majority of the audience, so I’d say it was successful, but that “rude” comment stings a bit.

That was my Connections conference. I did enjoy presenting there and I hope I get invited another time. I mentioned it before, but I’ll say it again, having the high, low & average so that you can compare your performance to others really makes these much more useful.

Permalink 6 Comments

Hey, ho, where’d you go…

October 6, 2009 at 7:37 am (PASS, SQLServerPedia Syndication) (, , , , )

Ohio?

I’m presenting on Thursday to the Columbus SQL Server Users Group, home of the newly minted MVP, Jeremiah Peschka (congrats again). It’s to be a virtual presentation through live meeting. The topic is a Understanding Execution Plans. This time I hope that one of us remembers to hit the record button unlike last time when I did this presentation for the PASS AppDev Virtual Chapter. If you’re in the area, come on down and meet me, virtually. Show runs from 6:30-8:30, although all that time is not my presentation, so I suspect Jeremiah has some more fun planned.

Permalink Leave a Comment

Presentation Skills from Brent Ozar

September 23, 2009 at 8:08 am (Misc) (, , )

If you present at any level, read this. If you’re thinking about presenting, read this. If you’d like to start thinking about presenting, read this. That is all. Carry on.

Permalink 2 Comments