Question: How to Find Cardinality or Uniqueness for any Column?
SQL SERVER – How to Know Transaction Isolation Level for Each Session?
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.
We Are Sold Out – Practical Real World Performance Tuning – SQL Authority News
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.
21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs – PASS Pre-Con 2018
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.
How to Force a Parallel Execution Plan for a Query? – Interview Question of the Week #170
Question: How to Force a Parallel Execution Plan for a Query?
SQLPASS Pre-Con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs
If you are traveling to SQL PASS, Seattle this year, you do not want to miss out on my pre-con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs. This session is going to be amazing fun and very unique. It is full day demo-oriented learning session.
SQL Authority News – Brent Ozar Unlimited Office Hours 2018/4/4 – Fun Experience
It was my pleasure and honor that I was invited to the Brent Ozar Unlimited Office Hours. During the office hours, we received quite a few interesting questions, some were very complicated and some were super fun. However, the best part of attending the office hours was the company. I was fortunate to have Brent, Richie, and Tara along with me in this office hours. Please note that the questions which we discussed during the session were asked live.