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
Feb15

SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster, Starting SQL
1 Comment

Patching a clustered SQL instance, setup warned: Cluster Resource DLL Update Restart Check. A hard lesson on why you should not ignore this warning.

Continue Reading
Feb14

SQL SERVER – Unable to Connect to SQL Server in Azure Virtual Machine from SSMS on On-Premise Machine

Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Azure, SQL Connection, SQL Error Messages, SQL Server, SQL Server Management Studio
1 Comment

Can’t connect from SSMS on your own machine to SQL Server in an Azure Virtual Machine? Here is the network-related error users see and what to check to fix it.

Continue Reading
Feb13

SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Server, SQL Server Agent, SQL Upgrade, Starting SQL, System Database
3 Comments

One more cause of the script level upgrade failure for ‘sqlagent100_msdb_upgrade.sql’: Error 5041, MODIFY FILE failed. Here is how I fixed it.

Continue Reading
Feb12

SQL SERVER – Full-Text Search Not Working For PDF Documents

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

A client stored PDF files in a VARBINARY(MAX) column, and Full-Text search could not find text in them. Here are all the steps I used in my lab to make it work.

Continue Reading
Feb11

How to Schedule a Job in SQL Server? – Interview Question of the Week #160

Pinal Dave
SQL Interview Questions and Answers
SQL Server, SQL Server Agent, SQL Utility
No Comments

How do you Schedule a Job in SQL Server? First make sure SQL Server Agent is running, then follow these simple screens to add the job, its steps and a schedule.

Continue Reading
Feb10

HRESULT 0x8007138E: The Cluster Resource Is Not Available

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

HRESULT 0x8007138E, the cluster resource is not available, stopped a SQL Server patch on a clustered instance. The Summary.txt and Detail.txt files led to one failed cluster disk. Removing it from the cluster fixed the install.

Continue Reading
Feb9

SQL SERVER – What is Change Pending State of in SQL Server Configuration Manager?

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Services
41 Comments

During a rushed release, a client stopped SQL Server and the service got stuck. Here is what Change Pending State in Configuration Manager means and what to do.

Continue Reading
Previous 1 … 231 232 233 234 235 236 237 … 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