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
Dec24

Investigating a Past Slowdown With the system_health Session

Pinal Dave
SQL Tips and Tricks
SQL Extended Events, SQL Monitoring, SQL Performance
No Comments

Nobody was tracing when it got slow. The system_health session was. Here is how to read what it kept before the files roll over.

Continue Reading
Dec23

SQL SERVER – Learning More About SQL Wait Stats

Pinal Dave
SQL Tips and Tricks
SQL Wait Stats
2 Comments

Are SQL Wait Stats still relevant for performance tuning? Absolutely. Here is what I told a customer in Delhi and where to start learning about them.

Continue Reading
Dec22

Permissions I Have in SQL Server: Check Database, Server and Object Access

Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security
3 Comments

The permissions I have in SQL Server depend on my database and security context. These read-only queries, tested with a loginless user, a role and a column DENY, separate database, server and object checks and show which grant supplied each permission.

Continue Reading
Dec21

Recovering a Deleted Agent Job From an msdb Backup

Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Server Agent, System Database
No Comments

Someone deleted the wrong Agent job. Here is how to get it back from an msdb backup without touching the live msdb.

Continue Reading
Dec20

SQL SERVER – Redundant Indexes Good or Bad – Final Wrap – Part 7

Pinal Dave
SQL Tips and Tricks
SQL Index
No Comments

Are redundant indexes good or bad? This final wrap of my seven part series recaps every part and its demo, so start here if you missed any.

Continue Reading
Dec19

SQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007

Pinal Dave
SQL Tips and Tricks
Notes from the Field
4 Comments

Want to know about a problem before your users do? Mike Walsh explains SQL Server alerts, why they matter for server health and how to use them.

Continue Reading
Dec18

Free Tools Worth Having on a SQL Server

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server
7 Comments

Choose free SQL Server tools by the problem they solve, from SSMS and sqlcmd to Extended Events, and understand the limits before relying on them.

Continue Reading
Previous 1 … 454 455 456 457 458 459 460 … 847 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