A train ride with my family got me looking at familiar things with fresh eyes, like how SSMS now makes taking a database Offline easier. Here is how.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – FIX – Error: 26023 – TCP Port is Already in Use
After patching, database mirroring stopped and the ERRORLOG showed Error 26023: TCP Port is already in use on 5022. Here is how we found the cause and fixed it.
Database Scoped Configurations Changed From Their Defaults
One column in sys.database_scoped_configurations finds every setting that differs from its default. I show how to use it, and where it goes blind.
SQL SERVER – Errors When Disk Space is the Reason
When disk space runs out, SQL Server logs errors like 1101 and 1105, often during recovery. A roundup of the common messages and what each one tells you.
DMV to Replace DBCC INPUTBUFFER Command – Interview Question of the Week #100
Is there a DMV to replace the DBCC INPUTBUFFER command? An interview question that caught me off guard, answered with sys.dm_exec_input_buffer.
SQL SERVER – FIX Error – Cluster Network Name showing NETBIOS status as “The system cannot find the file specified”
A Cluster Network Name would not come online and showed NETBIOS status ‘The system cannot find the file specified’. Which log to check and how we fixed it.
SQL SERVER – Fix Connection Error – [Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect())
A connection error on a named instance that works by port but not by name. What SQL Browser answers on UDP 1434, and why local tests prove nothing.
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.