A client’s availability group failover across subnets got stuck in Resolving and generated dumps with Error 17066. Here is what we found and how we fixed it.
SQL SERVER – FIX: SQL Service Does Not Start After Promoting the Machine as Domain Controller
A SQL Server machine was promoted to a domain controller and the service stopped starting. Why it broke, the workaround we used, and the real fix.
SQL SERVER – FIX: Msg 15150 – Cannot Alter The User ‘dbo’.
Deploying SharePoint, a client tried to change the dbo mapping and got Msg 15150: Cannot alter the user ‘dbo’. Here is why it happens and how to fix it.
SQL SERVER – Msg 3225: Use of WITH CREDENTIAL Syntax is Not Valid for Credentials Containing a Shared Access Signature
Backup to URL worked, but a maintenance plan failed with Msg 3225: WITH CREDENTIAL is not valid for credentials with a Shared Access Signature. Here is the fix.
How to Identify Session Used by SQL Server Management Studio? – Interview Question of the Week #151
An interview candidate asked us: how do you identify session IDs that SQL Server Management Studio is using? Here is a simple answer with sp_who2.
SQL SERVER – Always On Availability Group Error 35250: The Connection to the Primary Replica is Not Active
Joining a database to an availability group can fail with Availability Group Error 35250. Here is why it shows up in the wizard and how I fix it.
SQL SERVER – Puzzle – Brain Teaser – Changing Data Type is Changing the Default Value
Changing the Default Value is the question behind this data-type puzzle. I keep the expression, data type and nullability separate.