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
Oct10

Comparing Old and New Values in a Trigger With inserted and deleted

Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Server, SQL Trigger
No Comments

Build a small audit trigger that joins inserted and deleted, handles NULL changes correctly and ignores saves that change nothing.

Continue Reading
Oct9

SQL SERVER – SQL Server Management Studio Crash While Using Backup to URL or Connecting to Storage

Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Error Messages, SQL Server Management Studio
2 Comments

During an urgent restore, SSMS crashed each time my client picked URL to restore from Azure Blob Storage. Here is how to fix the crash when connecting to storage.

Continue Reading
Oct8

SQL SERVER – Event ID: 2004 – Resource Exhaustion Diagnosis Events

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Memory, SQL Scripts, SQL Server
2 Comments

A client with SQL Server memory issues saw Event ID 2004, Resource Exhaustion Diagnosis Events, naming sqlservr.exe for low virtual memory. Here is what it means.

Continue Reading
Oct7

How to Change Language for SSMS? – Interview Question of the Week #194

Pinal Dave
SQL Interview Questions and Answers
SQL Server, SQL Server Management Studio, SQL Utility
2 Comments

How do you change language for SSMS? A workshop attendee asked me and I had to research it, but the steps are simple and start in the Tools menu.

Continue Reading
Oct6

SQL SERVER – Event ID: 10028 – SQL Server Distributed Replay Client – DCOM was Unable to Communicate with the Computer

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, Starting SQL
No Comments

Event ID 10028 from the SQL Server Distributed Replay Client flooded a client’s event log and buried the data we needed. Here is how to stop the noise.

Continue Reading
Oct5

SQL SERVER – SSIS – Package Error: “ODBC Source” Failed Validation and Returned Validation Status “VS_NEEDSNEWMETADATA”

Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Scripts, SQL Server, SQL Utility, SSIS
2 Comments

A client’s SSIS package failed: “ODBC Source” failed validation and returned validation status “VS_NEEDSNEWMETADATA”. I explain which metadata and the fix.

Continue Reading
Oct4

SQL SERVER – Error: 45207 – SQL Server Managed Backup to Microsoft Azure Cannot Configure the Database Because a Container URL was Either not Provided or Invalid

Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Error Messages, SQL Log, SQL Scripts, SQL Server, SQL Server Security
2 Comments

After a cleanup on my Azure SQL VM, I hit Msg 45207: SQL Server Managed Backup to Microsoft Azure cannot configure the database. Here is how I fixed it.

Continue Reading
Previous 1 … 197 198 199 200 201 202 203 … 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