Dropping a linked server with sp_dropserver failed with Msg 15190: There are still remote logins or linked logins for the server. Here is how to clear them.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Rebuild Log for Msg 1813: Could Not Open New Database
Rebuild log is the way back from Msg 1813, Could not open new database, when the log file is corrupted. SQL Server expert Jeremy Roe sent me an updated script for newer versions. This post walks through his nine steps in order.
Set-ClusterParameter Error: ProbePort Does Not Exist on the Cluster Object
The Set-ClusterParameter error said Parameter ‘ProbePort’ does not exist on the cluster object. I hit it while setting up a probe port for an Always On listener in Azure. Two wrong values in my script were the cause, and fixing both let the script run.
Diagnosing Blocking Chains With sys.dm_exec_requests
Trace blocking chains from active requests to a candidate head session, inspect sleeping transactions, and verify the owner before action.
SQL SERVER – xp_create_subdir() Returned Error 183, ‘Cannot Create a File When that File Already Exists
A client’s maintenance plan kept failing with: xp_create_subdir() returned error 183, Cannot create a file when that file already exists. Here is the fix.
SQL SERVER – Relating Unrelated Tables – A Question from Reader
A reader asked how to relate two unrelated tables, Table_A and Table_B, and show them in one output. Here is my answer to this unusual question.
How to Shrink All the Log Files for SQL Server? – Interview Question of the Week #203
Question: How to Shrink All the Log Files for SQL Server? Here is the script, plus why you should shrink only log files and never data files.
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.