Creating a login on an AlwaysOn availability group secondary replica failed with Error 3906, database is read-only. Here is why it happens and what to do.
SQL SERVER – Error: 26014 – Unable to Load User-Specified Certificate
A clustered instance would not start: Error 26014, unable to load user-specified certificate. What the ERRORLOG showed and how we got SQL Server running again.
SQL SERVER Management Studio – Taking DB Offline Made Easier
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 – 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.