Welcome to SQLSaturday #410
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 27 2015 at the EMCS Building at UT Chattanooga, 784 Vine Street, Chattanooga, TN 37403. Admittance to this event is free, but we do charge a lunch fee of 12.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleagues know about the event.
Photo courtesy of Chattanooga Convention & Visitors Bureau
You can follow us on Twitter @SPoChatt or visit our website, spoc.sqlpass.org.
PRE-CONFERENCE - TUNE LIKE A GURU - Kevin Boles
Friday, June 26, 8:30-4:30 EMCS Building
Box lunch provided
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!!
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 20 years of database experience and over 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. Kevin has been a very successful independent consultant for over 15 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.