A reader’s SQL Server service was stuck in Starting / Change Pending in Configuration Manager. Here is what the ERRORLOG showed in this variation and the fix.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – How to Execute the Query Without Using Management Studio?
A client’s security team removed SQL Server Management Studio from the server. Here are simple ways for beginners to run a query without it.
SQL SERVER – Empty Startup Parameter in SQL Cluster on One Node
Many problems lead to the same symptom. Here is another reason for an empty startup parameter in SQL Cluster, when it was not a registry permission issue.
SQL SERVER – Install Error: Standalone SQL Server on WFC Cluster Cannot Have Files on Shared Disk Locations
SQL Server 2014 setup failed with an Install Error: standalone SQL Server on a WSFC cluster cannot have files on shared disk. Here is why and what to do.
How to Reduce High Virtual Log File (VLF) Count? – Interview Question of the Week #162
Found a high Virtual Log File (VLF) count in your database? Here are the steps I follow to bring the count down, starting with the log file details.
SQL SERVER – Installation Wizard Hang Forever – Please Wait on Feature Selection Page
Adding Analysis Services to SQL Server 2014, the Installation Wizard hung on “Please Wait” at feature selection, even after my lunch. Here is what fixed it.
SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
SQL Server Agent would not start, and the log said Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed. Here are the logs I check and the fix I found.
SQL Server slow? Let's fix it together in about four hours.
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.

