I have received some rave reviews of my article on SQL SERVER – How to Get Started with Docker Containers with Latest SQL Server?. It was amazing to hear that people really get started after reading my article on docker. One of the most popular questions I keep on receiving was what happens when we have to patch or upgrade SQL Server. Well, that is a fantastic question. In today’s blog, I will explain to you how we can get Docker Volume and Persistent Storage.
SQL SERVER – Audit Script to Get CPU and Memory Information with MAXDOP Guidelines
If you are reading this blog regularly the name of Dominic Wirth may not be new for you. He has in the past sent some very interesting scripts for audit for our blog and I am including his new script in this blog which is about how to Get CPU and Memory Information with MAXDOP Guidelines.
SQL Puzzle – Correct the Incorrect Query – Win Price Worth USD 1000 – Aggregate and Subquery
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.
Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220
Question: Does ARITHABORT Setting Negatively Impact SQL Server Performance?
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: