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

Jan30

SQL SERVER – Understanding JSON NULL Value Using STRICT Keyword

Pinal Dave

SQL

JSON, SQL Error Messages, SQL Scripts, SQL Server

Playing around with the new capability of SQL Server 2016 has been a fun journey. Even after a year, the discovery keeps happening every single day that I work with it. When I wrote the post around NULL values getting returned, lesser did I know there have been folks who work on this feature. Let us learn in this blog post about JSON NULL Value Using STRICT Keyword. Do make sure to read the other blog too:

Jan29

Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107

Pinal Dave

SQL Interview Questions and Answers

SQL DMV, SQL Performance, SQL Scripts, SQL Server

Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.

Jan28

SQL SERVER – Script level upgrade for database master failed – Error: 4860, Severity: 16, State: 1 – Cannot bulk load. SqlTraceCollect.dtsx does not exist

Pinal Dave

SQL

SQL Error Messages, SQL Server, System Database

No Comments

Of late, I have been contacted by few clients who have been facing issues with SQL startup failure after applying patch to SQL Server instance. This blog is an outcome of one such assistance provided. Here is a blog post where I discuss script level upgrade for database master fails.

Jan27

SQL SERVER – SQL Installation fails with error code 0x851A001A – Wait on the Database Engine recovery handle failed

Pinal Dave

SQL

SQL Error Messages, SQL Server, Starting SQL

One of my client was trying to deploy his product on their test servers. They found that the SQL Server installation was failing with below error. Let us learn about error Wait on the Database Engine recovery handle failed.

Jan26

SQL SERVER – Using dm_db_stats_properties With InMemory OLTP Tables

Pinal Dave

SQL

In-Memory OLTP, SQL DMV, SQL Memory, SQL Server

No Comments

The whole concept of InMemory OLTP has been around for a while and still there are areas that I try to go back to learn every single time. If you are new to InMemory OLTP, I would highly recommend searching this blog for more content. For a starter, the blow blog is a great start.

Jan25

GroupBy Conference – 3 Common Mistakes to Kill SQL Server Performance

Pinal Dave

SQL Video

SQL Performance, SQL Server

Earlier this year, I was fortunate to take part in the first edition of the Group By Conference organized by Brent Ozar. I was extremely fortunate that I was able to present an hour long presentation on the subject 3 Common Mistakes to Kill SQL Server Performance.

Jan24

SQL Server – When to Use a Sledgehammer and When to use a Screwdriver

Pinal Dave

SQL

Nitrosphere

While it is almost always a good idea to place the data near the application, choosing Always On may be using a sledgehammer to do a screwdriver’s job.

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.