T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig
Colin Chapman was a true Formula 1 pioneer whose innovations included the aerodynamic wing spoiler. Enzo Ferrari once said, "Aerodynamics are for people who can't build engines." The Stig, well, he never says anything out loud, but his actions speak volumes.
In this session, Brent will use quotes and lessons from racing icons like Chapman, Enzo Ferrari, and The Stig to illustrate SQL Server performance tuning concepts. Find out how to "add lightness" to your database by using DMVs to eliminate unneeded indexes, how to get out of the pits faster with Database Mirroring, and why skipping performance monitoring is like overdriving your headlights.
Speaker focus
Brent Ozar is a SQL Server Domain Expert with Quest Software. He has a decade of broad IT experience, performing systems administration and project management before moving into database administration. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent 2 years at Southern Wine & Spirits, a Miami-based wine & spirits distributor.
Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com. He coauthored SQL Server Internals and Troubleshooting for Wiley/Wrox along with Christian Bolton, Justin Langford, James Rowland-Jones, and Jonathan Kehayias. He's Editor-in-Chief at SQLServerPedia.com, where he also records video podcasts.