I have been delivering SQL Server Performance Tuning Practical Workshops for various organizations and it has been an extremely popular class so far. I receive lots of requests for me to deliver it for individuals. The only reason that I have never scheduled it for individuals was the content of the class was customized carefully for a specific organization. However, I believe it is now time for me to announce that this class is available to everyone.
|Important Update: The Workshop is now over and it was one of the landmark workshops, where I shared business secrets of successful Performance Tuning Expert. You can watch the recording of the workshop for a limited period of time.
Date and Time
April 23, 2019, Tuesday 8:00 AM Pacific Time | 11 AM Eastern Time
Duration of the class is 4 Hours and 30 minutes
Remember to send me an email at firstname.lastname@example.org with the subject line ‘SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019’ and in response I will send you meeting link to make the payment and calendar invite. That’s it!
Online Class with Replay 30
The class is delivered online via gotomeeting so you can attend the class from anywhere. Additionally, the class will be available to watch online for 30 days after the date of delivery if you miss any part of the class or if you want to repeat any concept of the class. If you want, you can re-watch the entire class for 30 days unlimited times.
The class is going to extremely interactive and will contain many pop quizzes and polls. If you have ever watched any of my previous classes, you will be familiar with how we interact with each other. We will be using Slack for interaction. You will not only connect with me but also build a strong network with your fellow attendees.
Bonus – Free 1 Hour Consultation – 10 Seats
Every attendee will get 1 hour of free consultation from 30 days of the training class. Yes, you read it right. You get free USD 500 worth free consultation within the first 30 days of the training, where you can ask as many questions as you want for your learning or for your organization absolutely FREE. This is an incredible deal and will be only for the first 10 registrations.
Cost of the Training
The cost of the training is USD 1,000 per person but if you sign up in February/March 2019, the cost of the training will be USD 800 for you. There is absolutely no further discount as the deal is already deeply discounted.
- 1 Seat – SQL Server Performance Tuning Practical Workshop for EVERYONE
- 30 Days FREE Unlimited Replays
- All T-SQL Demonstration Scripts
- 1 Hour FREE Consultation Within 30 days
- Access to Exclusive Chat Group on Slack
How to Register?
Just send me an email at email@example.com with the subject line ‘SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019’ and in response I will send you a meeting link to make the payment and calendar invite. That’s it!
Agenda of Training Day
This class is built on my most popular content which I have been delivering for many years.
The training is divided into four major parts.
Module 1: Indexing, Worst Practices, and Solutions (70 minutes)
Indexes are often considered a silver bullet to solve performance problems, but the reality is far from the age-old myth. The right index can help improve performance, but the wrong indexes often play party spoiler and reduce your server’s performance. Identifying which indexes to create and which indexes to delete can be cumbersome (or near impossible) if we do not know how to do workload analysis.
In this module of the workshop, we will see some neat tricks related to how to create useful indexes which last longer. We will also build a preventive auto-healing system which can help you focus on more complicated performance issues.
Comfort break – 15 minutes
Module 2: WhichIndex – An Interactive Game with WHERE clause and Multi-Column Indexes (70 minutes)
WhichIndex is an interactive game that provides a new experience to teach you how to understand how multi-column indexes work with queries with multiple conditions.
This game follows the format of open book exams where every user starts with answers to the questions. Once we understand our solutions, we start our journey to this interactive game. At a different interval of this game, users have to answer the question WhichIndex to the quiz master.
In this self-scored game, the winner is the person who gets the most answers wrong. If you have not understood the basics of indexes and performance-tuning concept, you will solidify that concept while we play this game.
On a side note – cheating is not only allowed but is heavily encouraged as well!
At the end of this game, users will have an understanding of three essential rules related to Indexes, which you will never forget.
Comfort break – 15 minutes
Module 3: Don’t Change Code – An Interactive Game with Functions, Views, and Indexes (50 minutes)
Any good singer needs the support of a decent sound system and cooperative band to be successful. Similarly, for any index to be successful it requires a supportive environment. It is incredibly critical to learn how index selection takes shape when functions are used in the query.
We start with a problem where there is a query and an index. The query is not using the index. The challenge which we have to solve in this game is to make the necessary modifications, so that our query uses our index. However, there is one condition – Don’t Change Code. We are not allowed to change the query.
While I struggle to solve this puzzle, your responsibility will be to help me out with various ideas and to help me honor the one condition of the game – Don’t Change Code.
The game is very fast paced but at every twist and turn we will take a few moments to understand the secrets of indexes.
Comfort break – 15 minutes
Module 4: Your Server, Your Questions
In the final part, we usually discuss the performance problems you are facing with your server personally. If you do not have additional questions, we usually spend the rest of the time looking at various real-world scenarios related to SQL Server Query Execution Plans and Performance. We often spend time discussing the following in this module:
- Server Configurations for Performance
- Instance Configuration for Performance
- SQL Server DBCC Best Practices
- Log Reviews (Windows Event Logs, SQL Server Error Logs and Agent Logs)
- Hardware Discussions
- Index Analysis and Optimization
- I/O Distribution Analysis
- Effective Query Writing
- SQL Server Resource Wait Stats Analysis
- SQL Server Best Practices
We will learn together, how to solve real-world performance problems systematically and scientifically.
Next Action – Register
Remember to send me an email at firstname.lastname@example.org with the subject line ‘SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019’ and in response I will send you a meeting link to make the payment and calendar invite. That’s it!
Reference: Pinal Dave (https://blog.sqlauthority.com)