SQL Server Performance Tuning is not as difficult as most of the people think. Actually, SQL Server performance tuning is very easy and simple, if you exactly know what to do and when to do. Well, that is what is the theme of the free webinar which I have done for 24 Hours of PASS.
I recently completed delivering Practical Real World Performance Tuning for Brent Ozar Unlimited and it was great 3 days of delivery. Here are my thoughts about my entire experience and how everything worked out. Let us go on the journey to Behind the Scenes for Teaching Online Class.
Question: How to Find Cardinality or Uniqueness for any Column?
During recent, Comprehensive Database Performance Health Check, I had a very interesting scenario. I was hired by a customer to identify their system’s unexpected performance bottlenecks. I do these for a living so I am usually pretty comfortable. However, this customer was so unique that after their permission I am sharing you their story of transaction isolation level.
I am very excited to announce that we are sold out for the two of our class focusing on the USA time zone for Practical Real World Performance Tuning. This is indeed very exciting. If you have signed up for the training, we will be meeting later this week and next week. If you have not signed up for the training, indeed we will miss you during our training.
To be super honest, the request for this training was in demand for a quite a while and at the price point of USD 495, it was a quite a deal. Honestly, I had never thought that this training will be sold out so quickly. When I am looking back at this, I feel pretty comfortable that both the classes are filled up 100% and the audience is going to have lots of fun.
Today, I am going to talk about my the most anticipated pre-conference 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs scheduled at PASS Summit 2018. This session is going to be amazing fun and very unique. It is full day demo-oriented learning session.
Question: How to Force a Parallel Execution Plan for a Query?