Error 9003 on the master database means SQL Server cannot recover master and will not start. The master files were corrupt. We rebuilt the system databases, started the instance in single user mode and restored master from a backup.
SQL SERVER – Why Cluster Network is Unavailable in Failover Cluster Manager?
A Windows admin told me how cluster networks showed as unavailable in Failover Cluster Manager, and why a reboot was the fix that time.
SQL SERVER – Query to Get the List of Logins Having System Admin (sysadmin) Permission
Many scripts online miss logins when listing sysadmin members. Why the common query is wrong, plus a correct one for logins with System Admin permission.
SQL SERVER – TDE Effects on TempDB’s Slow Performance
A client had slow performance out of nowhere. The cause was TDE effects on TempDB after someone tested encryption on production. Here is what I learned.
SQL SERVER – How to get historical deadlock Information from System Health Extended Events?
Let me start off by asking a simple question. How many of you have seen this error about historical deadlock information earlier?
How to Get Random Records from Table? – Interview Question of the Week #105
How do you get random records from a table? This interview question never gets old. Here is the ORDER BY method I use because its syntax is easy to remember.
SQL SERVER – Unable to Start SQL Service – Server TCP provider failed to listen on [‘any’ 1433]. Tcp port is already in use.
One of my SQL instances would not start: Server TCP provider failed to listen on port 1433, TCP port is already in use. How I found what held the port.