It has been a while since we have seen a puzzle so let us do a small puzzle today. Actually, this is a very simple puzzle if you have worked with SQL Server for a while. I got an email from one of the readers from the blog post and he wanted me to correct the following query which he had written. Well, I have been working with SQL Server for over 19 years and I often do not remember the syntax and have to look up online. Here is a very simple puzzle for you which involves Aggregate and Subquery.
How to Get FREE Consulting Hours to Tune Your SQL Server Performance?
As you know now there are only six days to my most looked forward SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019. I have already opened a lot of seats for the class but the demand for the class is constantly increasing. There are two major perks for the signing up the class 1) Free UNLIMITED replay for the class for 30 days and 2) FREE Consulting Hour.
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?
SQL SERVER – Getting Started with Azure Data Studio
Do you still use SQL Server Management Studio or do you use Azure Data Studio? I was recently asked during my recent Comprehensive Database Performance Health Check, Well, the answer is I am still using SQL Server Management Studio (SSMS) as I find it very comfortable and it still has many features which are not available in Azure Data Studio (ADS). I do not think that ADS is a replacement of SSMS. They are built for a totally different purpose for a different audience.
Logistic Step 1: Connecting Via SQL Slack for Server Performance Tuning Practical Workshop for EVERYONE
It is just 12 days before we have a SQL Server Performance Tuning Practical Workshop for EVERYONE. If you have ever attended any of my previous SQL Sessions, you know that the session will be extremely interactive. Many of you have asked me how will we do Interactive Part of this popular Workshop. Well, it is very simple we will be using the Slack for it.
SQL SERVER – FIX: Install Error: A Network-Related or Instance-Specific Error Occurred While Establishing a Connection to SQL Server
One of the most common connectivity errors which I have heard about it is “A network-related or instance-specific error occurred while establishing a connection to SQL Server.” In this blog, we would learn about how to fix this error if it comes during the installation of SQL Server.