A client could not run any job and got Error 14258: Cannot perform this operation while SQLServerAgent is starting. Here is what caused it and how we fixed it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Event 17058 – initerrlog: Could not Open Error Log File
SQL Server would not start and there was no ERRORLOG. Event 17058, initerrlog: Could not open error log file, came from missing permissions on the Log folder.
Detect Performance Problems in SQL Server With DMVs
To detect performance problems in SQL Server, start with four suspects and a few dynamic management views that show CPU waits, memory use and the system_health session. This guest post by Eduardo Castro explains where to look first.
Find and Replace With Regular Expressions in SSMS
A regex replace can turn forty column names into ISNULL expressions in seconds. Here is the pattern, the safety habits, and the trap of a zero default.
SQL SERVER – Setting Firewall Settings With Azure SQL Server VMs
Can’t reach SQL Server on an Azure VM from your app? The firewall was the culprit. Here are the steps I use to set firewall rules with Azure SQL Server VMs.
A Retry Loop in T-SQL for Deadlock Victims and Lock Timeouts
Build a bounded retry loop for deadlock and lock-timeout errors, roll back each failed transaction, and keep diagnostics beside retries.
Does Dropping Primary Key Drop Clustered Index on the Same Column? – Interview Question of the Week #082
When you drop a primary key, does it drop the clustered index on the same column too? Yes, it does. Here is a small script that shows it.
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.