Deploying a hybrid AlwaysOn availability group across on-premises and Azure, adding a replica failed with error 19456. Here is what fixed it.
How to Add Date to Database Backup Filename? – Interview Question of the Week #109
A reader using Backup to URL asked how to add the date to a Database Backup Filename. Here is a script that builds the name for you.
SQL SERVER – Migrating AlwaysOn Availability Group to New AD Domain
The steps I gave a client for migrating AlwaysOn Availability Group replicas from an old AD domain to a new one after an acquisition, node by node.
SQL SERVER – UpdateHADRResource – Failed to version-copy file – Exception data is: System.IO.IOException
A SQL Server patch on a cluster failed at UpdateHADRResource with System.IO.IOException, failed to version-copy hadrres.dll. Here is the cause and the fix.
SQL SERVER Management Studio – Exception of type ‘System.OutOfMemoryException’ was thrown. (mscorlib)
Copying a huge result set from the SSMS grid threw ‘Exception of type System.OutOfMemoryException was thrown’. Why it happens and a better way to export.
SQL SERVER – Puzzle – Why does sp_spaceused Show No Values?
Why does sp_spaceused show no values for a table that clearly has rows? It stumped me for 10 minutes. Here is the puzzle, try it before reading on.
SQL SERVER – The header for file Path is not a valid database file header. The PageAudit property is incorrect
SQL Server would not start: model.mdf did not have a valid database file header and the PageAudit Property was incorrect. How I got it running again.