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

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?

Apr13

SQL SERVER – Getting Started with Azure Data Studio

Pinal Dave

SQL Tips and Tricks

Azure Data Studio, SQL Download, SQL Server Management Studio, SSMS

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.

Apr12

Logistic Step 1: Connecting Via SQL Slack for Server Performance Tuning Practical Workshop for EVERYONE

Pinal Dave

SQL Performance

Slack, SQL Server, SQL Training, Workshop

No Comments

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.

Apr11

SQL SERVER – FIX: Install Error: A Network-Related or Instance-Specific Error Occurred While Establishing a Connection to SQL Server

Pinal Dave

SQL

Computer Network, SQL Error Messages, 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.

Apr10

14 Days to #SQL Server Performance Tuning Practical Workshop for EVERYONE

Pinal Dave

SQL Performance

SQL Server, SQL Training, Workshop

No Comments

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:

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