2011 PASS Summit Pre-Con Preview - Rob Farley

Today's post is from Rob Farley who will be presenting "Fixing Queries With Advanced T-SQL Constructs".  You can read more about his
session here: http://www.sqlpass.org/summit/2011/Speakers/CallForSpeakers/SessionDetail.aspx?sid=1204
 
Is there an audience that would benefit especially from this session?
A lot of people are quite good at T-SQL. They can write queries to solve most of their problems, and they probably understand indexing principles - able to pick the ideal covering index for their queries, and probably know to look in the Execution Plan to look for ‘bad things’ such as Index Scans and Lookups. However, I see a lot of things that people don’t really know about writing queries and the relationship to plans. I know they don’t, because I remember learning them myself. I remember making that shift from being able to write ‘good queries’ to being able to write the queries that matched the plans I wanted to see being produced.

But you don’t have to be particularly good at T-SQL already. The kind of person I think will get the most out of this seminar is the person who is merely comfortable writing queries, and interested in being stretched to think differently.


After having attended your seminar, what are two or three things that an attendee will be able to take back to the office and put to use right away?
My favourite piece of feedback from any of my Advanced T-SQL classes is when someone writes "You’ve made me want to pull up every query I’ve ever written." It’s not because they suddenly have tools to assess their queries better (although they will certainly have the opportunity to learn to assess queries), but because they’ve developed an interest in thinking about their queries more. I’ll show people the profoundness of what they already know, and they’ll probably think of times they’ve used those constructs without considering the impact of them. I’ve had people remote into their machines during my talks to see if they’re taking full advantage of the things I’m showing.

As well as that, people will get renewed hope that they can tune some of their nastier queries even more. We all have queries that we have given up on, and I hope that I can persuade people that there is almost always hope, even for the worst of them. The things I’ll be showing can affect a lot of queries, so I’m sure there will be something for even the most frustrating of queries.


What background should attendees ideally have to be fully prepared for your seminar?
I’m going to assume that attendees are not complete beginners with T-SQL. I figure if I show a simple GROUP BY statement, that someone’s going to understand what I’m showing. But I don’t expect that they should have a certain level of expertise before coming. The biggest prerequisite I see for this is to have an interest in getting the most out of T-SQL. If they’re coming to hear my jokes, they’ll be disappointed - my jokes aren’t really that good.


What experience are you, as a speaker, bringing to this session?
Well, I’ve taught Advanced T-SQL for a number of years, using my own courseware, and have delivered this seminar before with excellent feedback. I’ve done public speaking for a long time, and promise to make the day enjoyable as well as instructional. I’ve had some of the best in the industry say that I’m one of the best explainers out there, and I take pleasure in helping people really get the concepts that I’m showing. I try for a mix of the light-hearted and eye-opening, that generally works well. I don’t try for massively deep and obscure; I go for profound, and may make your head hurt as you start seeing the possibilities for the code you can write.

Oh, but if you’ve never seen an execution plan before, then consider going to Grant & Gail’s session. I’m sure that will be very good too.