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

Nov1

SQL Authority News – 11 Years of Daily Blogging – 4200+ Blog Posts

Pinal Dave

Personal

Blogging, SQL Milestone

Today, I complete 11 years of daily blogging on SQL Authority. I have so far blogged 4200 blog posts on this blog. 11 years have about 4015 days and it seems that I have written over 1 blog posts every single day.

Oct31

SQL SERVER – SQL Express Installation Error – Wait on the Database Engine Recovery Handle Failed

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Express

Sometimes I get emails from software vendors who use SQL Server as a part of their product. One of such vendor contacted me for an issue where their software install was failing because SQL Express was not getting installed. It was failing with an error. The error message which they shared was “Wait on the Database Engine recovery handle failed”.

Oct30

SQL SERVER – Adding New Database to AlwaysOn Replica is Slow

Pinal Dave

SQL

AlwaysOn, SQL High Availability, SQL Scripts, SQL Server

First, let me clarify, the words in the subject of this blog are the exact words used by my client and whatever you do and say but “customer is always right!”. Here is the complete story where we faced issue related to AlwaysOn Replica.

Oct29

SQL SERVER – How to Auto Start SQL Followed by a Crash?

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, Starting SQL

Sometimes I do get some quick questions from my existing clients. I try to help them as much as possible. Most of the time, I provide them link to my blog or someone else’s blog. If there is no relevant information based on my search, then I provide them relevant information and write a blog for future reference. This blog is an outcome of one such email communication. Here is the short question about auto start SQL.

Oct28

SQL SERVER – How to Remove TempDB File?

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL TempDB

In the last 11 years of blogging, I have never received a question which I have received yesterday. The question which I often receive is about how to add TempDB files in SQL Server but I have never received a question about how to remove a TempDB file.

Oct27

SQL SERVER – Move Database Files for a Mirrored Database Without Breaking Mirroring

Pinal Dave

SQL Tips and Tricks

SQL Mirroring, SQL Scripts, SQL Server

Database mirroring is a very popular solution for high availability. Later on I am finding quite a many people DBAs opting for mirrored databases.

Oct26

Data Starvation – Balance Your SQL Server – Part 2

In Part 1 I covered how much data your SQL Server should be processing and the effects if it isn’t. Here we check to make sure that you’re achieving that speed. Let us continue learning about data starvation in this blog post.

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.