PASS has publicly announced their Pre-conference Sessions for the PASS Summit 2018 in Seattle, WA. There are seven sessions on Monday, November 5, 2018, and nine sessions on Tuesday, November 6, 2018. There are good sessions on both days, from many well-known speakers.
In my honest opinion, the most valuable session for most database professionals who care about query performance is Kimberly Tripp’s Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality on Tuesday. Kimberly is the world-class master on this subject, as evidenced by her many blog posts, presentations, and Pluralsight courses.
Kimberly is a very talented and passionate presenter and teacher. Long before I worked for SQLskills (way back in 2006 when I was working at NewsGator), I had the chance to take the week-long predecessor class to the current IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1. That class was a life-changer for me, and it had a huge effect on my career.
Since then, I have seen how Kimberly presents and teaches many times over the years. I have learned so much from both her content and from her presentation and teaching style by watching her. Unlike some well-known presenters, she doesn’t use cute pictures or silly marketing gimmicks in her presentation content. She is not there to just “put on a show” for entertainment purposes.
She prepares very detailed, content-dense slides that are a very useful resource to keep and review long after the session is over. She also has the depth of knowledge and experience to actually improvise and modify her demonstrations in response to questions during a session. As any experienced presenter knows, that is a pretty big deal.
She actually understands what she is teaching at a very deep level, and she has the many years of teaching experience to explain it clearly to people with any level of experience. Despite the lack of cute pictures or costumes, she does her presentations in a very engaging manner because of her real passion for the subject.
Here are her relevant Pluralsight courses that I would recommend watching to prepare for this pre-conference session:
SQL Server: Optimizing Stored Procedure Performance
SQL Server: Optimizing Stored Procedure Performance – Part 2
SQL Server: Optimizing Ad Hoc Statement Performance
SQL Server: Indexing for Performance
SQL Server: Why Physical Database Design Matters
BTW, Kimberly did not put me up to writing this post. In fact, she might be a little embarrassed by all of this praise. She might even mock fire me on Twitter once she sees it. I just felt I needed to spread the word about this pre-conference session.