One of my favorite scripts which I discuss with my client during Comprehensive Database Performance Health Check is how to get a list of Expensive Queries.
Case-Sensitive Search – SQL in Sixty Seconds #158
Earlier I wrote a blog post about SQL SERVER – Case-Sensitive Search. Lots of people said I should make a video on this topic.
SQL SERVER – Case-Sensitive Search
How to do a Case-sensitive Search? I was asked this by one of my clients of Comprehensive Database Performance Health Check.
SQL SERVER – Data and Index Compression – Real-World Conversation
Today we are going to see a real-world conversation about Data and Index Compression in SQL Server. I recently discussed this with my client.
Understanding Non-relational Data with Azure – Pluralsight Course
I am an expert at NoSQL as well as Non-relational databases. I have published a new course about Understanding Non-relational Data with Azure.
SQL SERVER – Top 3 Wait Stats from Real-World
It took me more than 9 hours to respond back every single email, I had received on this topic. Here are the Top 3 Wait Stats from Real-World.
Wait Stats for Performance – SQL in Sixty Seconds #157
I finally decided to create a video on that topic on my SQL in Sixty Seconds Channel. I will create more videos on the topic Wait Stats for Performance.
SQL SERVER – Wait Stats Collection Scripts : Updated March 2021
I have updated my SQL Wait Stats Collection Script for my clients. In today’s blog post we will be looking at the newly updated SQL Wait Statistics Script.
Forward – SQL Server Interview Questions and Answers: Updated 2021
Yesterday I blogged about my new updated book Interview Questions and Answers: Updated 2021. Let us read the forward of the book today.
SQL Server Interview Questions and Answers: Updated 2021
I have just released an updated version of my most famous SQL Server Interview Questions and Answers: Updated 2021 after 10 years.