This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
May26

SQL Server 2022 – Thread Management for Performance Improvement

Pinal Dave
SQL Performance
SQL CPU, SQL Memory, SQL Performance
No Comments

I had a great discussion about Thread Management for Performance Improvement with my client, who recently hired me for Comprehensive Database Performance Health Check.

Continue Reading
May25

Common Mistakes to Avoid for DBAs Working with MySQL Databases

Pinal Dave
SQL Tips and Tricks
Idera
No Comments

“What are some common mistakes you see DBAs make when working with MySQL databases, and how can they be avoided?”

Continue Reading
May24

SQL Server 2022 Performance – Buffer Pool Scan

Pinal Dave
SQL Performance
SQL Memory, SQL Server 2022
No Comments

One aspect that can significantly impact performance is scanning the buffer pool in Microsoft SQL Server. This blog explores buffer pool scan.

Continue Reading
May23

Implicit Transactions in SQL Server: The Setting That Leaves Work Open

Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL DMV, SQL Lock, SQL Transactions
No Comments

Implicit transactions make SQL Server open a transaction on the first data statement and keep it open until a COMMIT or ROLLBACK. This post shows what starts one, how @@TRANCOUNT counts it, why a second session waits, and how to find and clear the sessions that left work open.

Continue Reading
May22

How to Choose the Right Database Monitoring Tool

Pinal Dave
SQLAuthority News
Quest
1 Comment

Choose the right database monitoring tool by comparing alerts, workload context, overhead, pricing and support using a practical checklist.

Continue Reading
May17

Adapting to the Evolving Role of the DBA with SQL DM

Pinal Dave
SQL Tips and Tricks
Idera
No Comments

The evolving role of the DBA includes proactive monitoring. See how SQL DM can highlight risk, help prioritize issues and support the team.

Continue Reading
May16

Parameter Sensitive Plan optimization in SQL Server 2022 – SQL in Sixty Seconds #200

Pinal Dave
SQL Video
Execution Plan, Parameter Sniffing, SQL in Sixty Seconds, SQL Performance
1 Comment

SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries.

Continue Reading
Previous 1 … 41 42 43 44 45 46 47 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

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 19 books and 125 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 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.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com