Can you drop offline database in SQL Server? Yes, you can. Many DBAs I interviewed thought otherwise, so here is the full answer.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Empty Startup Parameters in SQL Server Configuration Manager
Configuration Manager showed Empty Startup Parameters when I tried to change the ERRORLOG location in my lab. Here is where they are stored and how to fix it.
SQL SERVER – Msg 1038 – An Object or Column Name is Missing or Empty. For SELECT INTO Statements, Verify Each Column Has a Name
Creating a login in SSMS failed with Msg 1038: an object or column name is missing or empty. Profiler showed the real cause. Here is what went wrong.
SQL SERVER – RETAINDAYS Does Not Delete Backup After x Days
RETAINDAYS sets backup expiration for overwrite checks, without deleting the file. I keep SQL expiration separate from Windows file cleanup.
SQL SERVER – 5 Don’ts When Database Corruption is Detected
Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption.
The money Data Type: Where Division and Rounding Go Wrong
Dividing money by money loses digits before any cast can save them. Here is the one-third demo, and how to find the leftover penny.
SQL SERVER – Unable to Start SQL Server – TDSSNIClient Initialization Failed with Error 0x2, Status Code 0x38
SQL Server would not start: TDSSNIClient initialization failed with error 0x2, status code 0x38. Process Monitor and the SuperSocketNetLib key helped.
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.