SQL Server Performance Tuning Expert - SQL Authority with Pinal Dave

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.

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.

An Index Reduces Performance of SELECT Queries (Video)
3 Common Mistakes to Kill SQL Server Performance (Video)
Click here for More Free Videos

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“.

Apr20

SQL SERVER – Docker Volume and Persistent Storage

Pinal Dave

SQL Tips and Tricks

Docker, Powershell, SQL Data Storage, SQL Scripts, SQL Server

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.

Apr19

SQL SERVER – Audit Script to Get CPU and Memory Information with MAXDOP Guidelines

Pinal Dave

SQL Tips and Tricks

MAXDOP, Parallel, SQL CPU, SQL DMV, SQL Memory, SQL Scripts, SQL Server

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.

Apr18

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

Pinal Dave

SQLAuthority News

SQL Training, Webinar, Workshop

No Comments

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.

Apr17

SQL Puzzle – Correct the Incorrect Query – Win Price Worth USD 1000 – Aggregate and Subquery

Pinal Dave

SQL Puzzle

Contest, SQL Scripts, SQL Server

527

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.

Apr16

How to Get FREE Consulting Hours to Tune Your SQL Server Performance?

Pinal Dave

SQL Performance

SQL Training, Webinar

No Comments

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.

Apr15

SQL SERVER – Difference Between Azure Data Studio and SQL Server Management Studio

Pinal Dave

SQL Tips and Tricks

Azure Data Studio, SQL Server Management Studio, SSMS

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.

Apr14

Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220

Pinal Dave

SQL Interview Questions and Answers

SQL Performance, SQL Server, SQL Server Management Studio, SSMS

No Comments

Question: Does ARITHABORT Setting Negatively Impact SQL Server Performance?

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 100 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.