Video – Bert & Pinal Troubleshoot a Slow Performing SQL Server

Earlier last week, I had the opportunity to attend my 10th SQL PASS. Yes, It has been 10 years since I have been visiting the PASS conference. This year, I had the opportunity to present 1 pre-con, 2 general sessions, 1 lightning talk. I really had a busy time at SQLPASS but along with the sessions, the highlight of the event was a video I recorded with Bert where we discussed troubleshoot a Slow Performing SQL Server.

Read More

Video – Database Performance Analyzer – Table Tuning Advisors

Earlier this week, I blogged about Database Performance Analyzer – Table Tuning Advisors and I received quite a lots of request to elaborate more on the topic of Table Tuning Advisors. In the response to the requests, I have decided to create a video which explains how Table Tuning Advisors of Database Performance Analyzer works. To make it more realistic, I have also included a real-world problem one of my customer whom I have recently helped to fix their SQL Server Performance during Comprehensive Database Performance Health Check. 

Read More