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.
SQL SERVER – Find Untrusted Foreign Key
Today we are going to see the script in which we can find all the untrusted foreign keys in your database. My client asked this question.
SQL SERVER – RESOURCE SEMAPHORE and THREADPOOL
RESOURCE SEMAPHORE and THREADPOOL. They are indeed very troublemaking wait statistics and they indeed talk about Memory and CPU issues.