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.
14 Days to #SQL Server Performance Tuning Practical Workshop for EVERYONE
SQL Server Performance Tuning is extremely easy subject and that is why I build my career of SQL Server Performance Tuning expert. I welcome everyone to join me in my quest to learn my business secret to become a SQL Server Performance Tuning Consultant. It is just only 14 days left to my the most anticipated and extremely popular course SQL Server Performance Tuning Practical Workshop for EVERYONE. Due to the high demand of the class and registration, I have just opened up 5 more seats to this class. You can sign up for the course by clicking directly going over here:
Get-AzureStorageBlob: The Remote Server Returned an Error: (403) Forbidden. HTTP Status Code: 403 – HTTP Error Message: This Request is Not Authorized to Perform This Operation
I was working with one of my clients and they wanted to clean up old backup blobs from Azure. I have already blogged and shared my script. In this blog we would learn how to fix error: (403) Forbidden – This request is not authorized to perform this operation. SQL SERVER – PowerShell Script – Remove Old SQL Database Backup Files From Azure Storage
SQL SERVER – Identify the column(s) responsible for “String or binary data would be truncated.”
I am happy to write this blog post as I am really happy that finally, SQL Server Engineering team has decided to fix the error which we all have been struggling for many years. I will say Since the year 2000, I have been working with SQL Server and it has always bothered me that every time when I try to insert data into my table which is larger than the data type of the column, I got an annoying error String or binary data would be truncated. I recently demonstrated this to my Comprehensive Database Performance Health Check.