Error 15240 stopped SQL Server starting after a patch. Tested on SQL Server 2025: three causes behind one message, and what my old fix missed.
SQL SERVER – SSMS Tip – Using Drag and Drop Capability
A lesser known SSMS trick: drag and drop from Object Explorer into the query window to get table and column names typed for you. Handy for documentation.
SQL SERVER – The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid
Let us learn in this blog how to fix The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid. Let us learn in this blog post.
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 – 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?
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.