Description

Session ID: 826

Abstract:

SQL Tuning is a Science. SQL Tuning is an Art. You may have heard both claims. SQL Tuning can indeed be a complex task requiring the use of some attributes of both brain hemispheres: Analytical Thinking and Creativity. If we want to enhance our SQL Tuning skills we may need then to take them both into consideration.

This 4-hour training session includes two aspects of SQL Tuning. It provides  practical knowledge by diving into the "4 T's" of SQL Tuning: Techniques, Tips, Tricks and Tools; and it arouses our troubleshooting skills by using some case studies, guiding participants towards possible solutions. Analytical and Creative Thinking are both taken into consideration and practiced within a friendly environment where there is no such thing as a dumb question.

The targeted audience for this "Practical SQL Tuning" session is both Developers and DBAs, with a desire to increase their SQL Tuning skills within a dynamic and participative environment. Open questions are welcomed, and sharing knowledge and experience is encouraged and expected. In fact, those participants who register early have the opportunity to propose their own SQL Tuning case, and have it either discussed and diagnosed before or during this training session. After all, this is a Practical SQL Tuning session!

Topics of interest are selected by participants at the beginning of the workshop; then immediately voted on. Content sequence of this workshop is driven by weight of topics voted on.

 

Objective 1: Practical knowledge by diving into the "4 T's" of SQL Tuning: Techniques, Tips, Tricks and Tools

Objective 2: Developing troubleshooting skills by using some case studies, guiding participants towards possible solutions

Audience: Mid-Level

Interests