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:

- Optimization processes

- Statistics usage and maintenance

- Index creation, usage and maintenance

- Understanding query plans

- Server and database configuration

- Improving design

- Improving code

- Profiler and trace analysis

- Temporary object usage

- Waits and IO stall analysis

We will look at all of these things and more from a variety of angles, while also covering many of the tips, tricks, tools and tribal knowledge 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!!

Speaker: Kevin Boles

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 over 15 years. Kevin is also a very frequent speaker, having presented at countless User Groups and pushing 100 SQL Saturday conferences! His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.