Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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 – Identity Jumping 1000 – IDENTITY_CACHE

Pinal Dave
SQL Performance
SQL Identity, SQL Scripts, SQL Server, SQL Server 2017
21 Comments

SQL Server 2017 has a wonderful feature which fixes a very old issue which DBA and developers have been struggling for a while. It would be impossible to find DBA or Developer who has not faced an issue when their identity column value has jumped or incremented by 1000. It is a very common issue and today we will see the solution of this issue with the help of IDENTITY_CACHE introduced in the latest version of SQL Server. 

Read More

SQL SERVER – How to Kill All the Processes for Any Database?

Pinal Dave
SQL Tips and Tricks
SQL Cursor, SQL Scripts, SQL Server
No Comments

Recently during Comprehensive Database Performance Health Check, to test our unique fix, we had to run a stress test on my customer’s development environment. Once we were done testing our script, we did not need our stress test queries to run on our server. Even though we stopped to run the batch file with stress test queries, there were few long-running queries kept on running on the server. This brought us to a very interesting point where we had to kill all the processes for one particular database.

Read More

SQL Authority News – Join me at SQLBits 2018 – 36 Scripts: Performance Tricks Jedi Master Wants You to Know

Pinal Dave
SQLAuthority News
SQL Performance, SQL Server, SQLAuthority Author Visit, SQLBits
No Comments

Many of you have previously attended my SQL Server Performance Tuning Practical Workshop. If you have attended this session, you probably know that my workshops are very quick paced and with simple tips which one can easily put in the practice. These workshops are an online and very effective way to learn while you are in the comfort of your office or home. Based on this workshop, I have to build another in-person workshop which is called “36 Scripts: Performance Tricks Jedi Master Wants You to Know”.

Read More

SQL SERVER – DMV to Get Host Information – sys.dm_os_host_info

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, Windows
No Comments

There was a time when SQL Server used to run on only Microsoft Windows. However, the time has changed and SQL Server now runs on Linux as well. This is indeed a great move as I believe database such as SQL Server should be running on multiple platforms. This is indeed a very interesting but it ads one more additional check before I jump into Comprehensive Database Performance Health Check. In this blog post, we will learn about how to get host information from OS. 

Read More

SQL SERVER – How to Make SQL Server GDPR Compliance?

Pinal Dave
SQL Tips and Tricks
GDPR Compliance, SQL Server, SQL Training
No Comments

I am really not sure how many times I have been asked about GDPR Compliance in the recent months. You must bookmark this page and share with your organizations if you are doing business with European Union or firm based out of European Union.

It is quite often to see the email in mailbox with the following title –

How to Make SQL Server GDPR Compliance?

Read More

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.