Pre-Con: Tune Like A Guru!

Tune Like A Guru!

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 DB configuration
- Improving design
- Improving code
- Profiler use and analysis
- Temp 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, 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!

* Lunch will be provided

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.

http://www.linkedin.com/in/thesqlguru
@TheSQLGuru

FAQs

Where can I contact the organiser with any questions?
Please contact [email protected] with any enquiries.

What is the language of session?
English

Is my registration/ticket transferrable?
You may substitute a delegate at any time prior to the event starting, by amending the registration details online. Any special requirements, including changes in dietary requirements notified less than 7 days before the event will be accommodated at the venue's discretion.

Do I have to bring my printed ticket to the event?
It will help the Registration process if you would print out your ticket and bring it with you. Thank you for your help in this matter.

Substitutions
You may substitute a delegate at any time prior to the event starting, by amending the registration details online. Any special requirements, including changes in dietary requirements notified less than 7 days before the event will be accommodated at the venue's discretion.