SQL SERVER – Maximizing Query Execution Plans On Screen – A Quick Tip

My most of the Comprehensive Database Performance Health Check consulting engagement I do are online and I enjoy working on them when I am at home office and I have multiple monitors. However, I often travel to the customer’s location when my client wants me to mix SQL Server Performance Tuning Practical Workshop with Health Check. This is when I doing a presentation on my laptop and I need every single real estate on my small laptop screen. Let see a neat trick, I use to Maximizing Query Execution Plans On Screen.

Read More

SQL SERVER – Script to Get Compiled Plan with Parameters From Cache

Lots of people often ask me as I share pretty everything on the blog – Do I have any Business Secrets. Actually, the answer is no, I never keep any secrets. I always share everything I know and I want my customers and readers learn along with me. Today I will share another script which I have written which I frequently use with my consulting engagement Comprehensive Database Performance Health Check.

Read More

SQL SERVER – Difference Between Azure Data Studio and SQL Server Management Studio

Earlier I blogged about SQL SERVER – Getting Started with Azure Data Studio. After reading the blog post, I receive an email from a reader asking about the primary difference between Azure Data Studio (ADS) and SQL Server Management Studio (SSMS). Well, before we start the conversation let us see the following image.

Read More