In this precon 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
Finding bad code to tune
Understanding query plans
Improving code (LOTS of this!!)
Profiler use and analysis (I use this ALL the time :-)
Temp object usage
Waits and IO stall analysis
Performance enhancements in recent versions of SQL Server
We will look at these things from a variety of angles, while also covering many of the tips, tricks, tools, etc. I have collected in my almost 50,000 hours of working with and studying the SQL Server engine and database applications that run on it. I promise you will come away with lots of immediately-applicable information which you can take back to work and Tune Like A Guru!
Prerequisites: Preferably an intermediate-level knowledge/experience in SQL Server and TSQL and some familiarity with reading execution plans.
FAQsWhat is the refund policy?Once purchased, tickets are refundable up to the day prior of the event. Tickets are transferrable.
What does the ticket include?The ticket for the event includes the following:
Access to Session Material for the Pre-Conference Workshop
Continental Breakfast, Lunch and Snacks are included. If you have any dietary restrictions please let us know at c3Fsc2F0dXJkYXk5MDkgfCBzcWxzYXR1cmRheSAhIGNvbQ==
Where on campus is the event located?Detailed instructions on the exact location of the classroom for your event will be sent closer to the day of the event in addition to information on parking.
Does this register me for the SQL Saturday event the next day?No. If you are planning on attending the main SQL Saturday event the next day, please be sure to register on the main SQL Saturday site: https://www.sqlsaturday.com/909/register.aspx
What if I have Questions?Please email us at c3Fsc2F0dXJkYXk5MDkgfCBzcWxzYXR1cmRheSAhIGNvbQ==
|Ticket Information ||Ticket Price |
| General Admission || USD 149|