SQL Server Performance Tuning Expert frontimage1

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

SQL Server Performance Tuning Expert frontimage2

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

SQL Server Monitoring Week – SQL Diagnostic Manager

Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help the customer with their various SQL Server performance issues, I often see my customers struggle with the monitoring their SQL Server’s health. One of the primary discussion at the end of consultation which we do is what tool is the best for their environment and how it can prevent them to walk into another trouble. Today we will talk about SQL Diagnostic Manager (SQLDM) in brief.

Read More

SQL Server Monitoring Week – Database Performance Analyzer

Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help the customer with their various SQL Server performance issues, I often see my customers struggle with the monitoring their SQL Server’s health. One of the primary discussion at the end of consultation which we do is what tool is the best for their environment and how it can prevent them to walk into another trouble. Today we will talk about Database Performance Analyzer (DPA) in brief.

Read More

SQL SERVER – Docker Volume and Persistent Storage

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.

Read More

Logistics: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019

There has been lots of buzz about the very first online class SQL Server Performance Tuning Practical Workshop for EVERYONE which is scheduled on April 23, 2019. Unless you are leaving under a rock, you would know that the class is now 100% sold out and I can’t accommodate any more person. If you are really interested, write an email to me and I will make an exception.

Read More

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.

Read More