SQL Saturday Pre-Conference: Kevin Boles - Tune SQL Server Like a Guru

SQL Saturday Baltimore

Abstract:
In this Pre-Con event we will cover a wide array of topics that form the backbone of my SQL Server performance analysis and tuning work. As a long-time relational engine consultant I have repeatedly found that the majority of clients I work with get amazing improvements by simply putting to use a fairly small collection of knowledge and tools. We will cover many topics, including: - Server, virtualization and database configuration - Optimization processes - Statistics - Indexing - Understanding query plans - Improving design - Improving code - Profiler use and analysis - Temp object usage - Waits and IO stall analysis - ORM Badness We will look at all of these things and more from a variety of angles, while also covering many of the tips, tricks, tools, etc. I have collected in my almost 45,000 man hours of working with SQL Server. I promise you will come away with lots of immediately-applicable information which you can take back to work and Tune Like A Guru!
Bio:
Kevin is a SQL Server expert, working exclusively with the product since v6.5. With over 20 years of database experience and almost 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. He has been a very successful independent consultant for 20 years. Kevin is also a very frequent speaker, having presented at many User Groups and over 100 SQL Saturday conferences! His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.