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

Sep20

Gherkin Scenarios: 3 Examples to Follow and 6 to Avoid

Pinal Dave

SQLAuthority News

BDD, Developer, Gherkin, Testing

No Comments

The quality of your Gherkin scenarios can make or break your BDD efforts. I’d like to share some insights many software developers overlook.

Sep19

SQL SERVER – Understanding Incremental Statistics

Pinal Dave

SQL Performance

SQL Index, SQL Statistics

No Comments

Statistics are updated automatically or manually rebuilt using full scans, can resource-intensive for large tables. Incremental Statistics.

Sep18

Learn MySQL : Path to Data Management Excellence

Let us explore Learn MySQL : Path to Data Management Excellence. MySQL is a very important tool for managing and organizing data.

Sep15

Gherkin Fundamentals – A Comprehensive Course on Pluralsight

Pinal Dave

SQLAuthority News

BDD, Gherkin, Pluralsight

No Comments

Let us discuss about my 54th course on Pluralsight – Gherkin Fundamentals. As a Behavior-Driven Development (BDD) tool.

Sep14

SQL SERVER – Query Store Feature for Secondary Replicas

Pinal Dave

SQL Tips and Tricks

AlwaysOn, Query Store, SQL Server 2022

No Comments

the Query Store for secondary replicas. This feature extends the Query Store functionality from primary replicas to secondary replica workloads.

Sep13

SQL SERVER – Avoid Functions in the WHERE Clause for Performance

Pinal Dave

SQL Performance

Query Rewrite, SQL Function

Using SQL Server functions in the WHERE clause of your queries can significantly impact performance. Let us explore that in this blog post.

Sep12

SQL SERVER – Performance: OR vs IN – A Summary and Further Reading

Pinal Dave

SQL Performance

Clustered Index, Computed Column, SQL Index, SQL Server

No Comments

The varied responses led me to write a detailed blog post to clarify the correct answer. If you missed it, you can read it here. Let us see A Summary and Further Reading.

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

Pinal has authored 13 SQL Server database books and 53 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,600 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).