Reading Your Execution Plans

SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014
I'm putting the finishing touches on the all day seminar on execution plans that I'll be putting on at DevConnections this year. I have tons of examples to show you how to interpret execution plans as part of query performance tuning. We'll be able to fill our time. However, I've got a pretty high degree of flexibility on which examples I use. With that in mind, I'd love it if you could bring in your own execution plans that you'd like some help reading. I won't guarantee a solution for your query problems, but I promise to read through it and make some suggestions. If you have an execution plan that you don't mind sharing with the group and you'd like a little consulting time on tuning the query, bring it…
Read More

Coming to Your Town

PASS, Professional Development
I can't sing and I can't play and I left the young generation behind a while ago, but I'm still coming to your town, or maybe one near you. Between August and December I'm hitting a substantial portion of the country, so if you want to have a little fun, discuss SQL Server, network, or just chat, here are your chances. Please, ask me questions. Please, walk right up and say hello because we can learn from each other and I love my SQL Family. Here's where I'm going to be: SQL Saturday #125 in Oklahoma City, August 25: Only one presentation here, Top Tips for T-SQL Performance, but it's a fun presentation. Register now because time is running out. SQL Saturday #156 in Providence, RI, September 15: This is…
Read More


SQL Rockstar tells me that unless there are photo's, it didn't happen. Brad McGehee published some pictures from DevConnections. See, I really do try to get people to buy my book... uh, I mean present technical sessions at conferences. Note the laptop with the styling stickers from: SQL PASS SQL Batman (defunct) SQL Serverpedia SQL Server Central Thrive SQL Server Bible SQL AgentMan SQL Rockstar One of these things is not like the others...
Read More

Dev Connections Recap

Misc, SQLServerPedia Syndication
Last week I attended the Dev Connections conference for the first time. It was held in the Mandalay Bay resort in Las Vegas. The conference is different because it doesn't concentrate on any one technology, but combines a bunch of them; ASP, Sharepoint, SQL Server, Visual Studio & Architects. That makes it a bit more like Tech-Ed than the PASS Summit. I showed up on Tuesday night and was there through Friday. I attended a few sessions and presented three of my own on the SQL Server Central track of SQL Server Connection. Overall it was a very good experience. I enjoyed meeting a lot of different people that don't go to the PASS Summit. My sessions went well (except for an odd interruption half way through my morning session…
Read More