Database Diagram was one of the most popular features of SQL Server Management Studio (SSMS). This feature was available in SSMS till version 17.9.
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.
How to Execute Query Without Using F5 or Query Toolbar in SSMS? – Interview Question of the Week #224
Question: How to Execute Query Without Using F5 or Query Toolbar in SSMS?
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.
Download SQL Server Management Studio 18.0 (General Availability)
I am really happy that Microsoft has finally announced the general availability of SQL Server Management Studio 18.0. It is the latest version of SSMS available and it works flawlessly with SQL Server 2019 and earlier versions of SQL Server.
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.
Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220
Question: Does ARITHABORT Setting Negatively Impact SQL Server Performance?