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
Jun6

Challenges and Opportunities for DBAs in the Next 5-10 Years: How to Prepare

Pinal Dave
SQL Tips and Tricks
Idera
No Comments

DBA challenges and opportunities call for skills we can practice now. I focus on recovery, performance and judgment as tools change.

Continue Reading
Jun5

sp_delete_database_backuphistory: Prune msdb Backup History

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

The sp_delete_database_backuphistory procedure removes the backup and restore history of one database from msdb, and sp_delete_backuphistory does it by age. The demo counts the rows of a database before and after the delete and previews the delete by age. The last sections explain how to keep the history small.

Continue Reading
Jun2

SQL SERVER 2022 – Last Valid Restore Time – Improved Backup Metadata

Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Server 2022
No Comments

One significant addition to the backup metadata is the inclusion of the last valid restore time. In SQL Server 2022, a new improved backup metadata feature.

Continue Reading
Jun1

Finding Permissions Granted Directly to Users Instead of Roles

Pinal Dave
SQL Tips and Tricks
DBA, SQL Scripts, SQL Server Security
No Comments

Find permissions granted directly to users, generate role-based review statements, and preserve DENY, column, and grant-option distinctions.

Continue Reading
May31

Configuring Parallel Index Operations in SQL Server

Pinal Dave
SQL Performance
MAXDOP, SQL CPU, SQL Index
No Comments

MAXDOP limits supported parallel index operations without changing unrelated instance settings. I choose the ceiling from the maintenance workload.

Continue Reading
May30

Query Store Wait Stats: Why a Query Was Slow, Not Just That It Was

Pinal Dave
SQL Performance
Query Store, SQL Performance, SQL Server, SQL Wait Stats
No Comments

Read Query Store wait stats by query, plan, interval, and category, then compare matched windows with execution counts and capture coverage.

Continue Reading
May29

Large Memory Servers: How SQL Server Scans the Buffer Pool

Pinal Dave
SQL Performance
SQL Backup and Restore, SQL Extended Events, SQL Memory, SQL Server 2022
No Comments

SQL Server scans the buffer pool during startup, backup, restore and DBCC, and large memory servers feel it most. An extended event records the scans, shows which commands start one and how many tasks each uses. The last sections explain what SQL Server 2022 changed.

Continue Reading
Previous 1 … 40 41 42 43 44 45 46 … 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