Msg 13601 showed up while I was working with JSON output: a property cannot be generated due to a conflict with another column name. Here is the fix.
Tail-Log Backup: Saving the Last Transactions Before a Restore
Take a tail-log backup before an approved restore, understand NORECOVERY and damaged-database options, and rehearse the full recovery chain.
SQL SERVER – FCB::Open failed: Could not open file Path for file number 2. OS error: 5(Access is denied.)
SQL Server would not start after a client moved database files from C to D drive: FCB::Open failed with OS error 5, Access is denied. Here is the fix.
Moving TempDB to New Drive – Interview Question of the Week #077
A 1 AM call: TempDB was full on the C drive. Here is the popular interview question on moving TempDB to new drive, with the steps I use.
SQL SERVER – Fix Error – 948 A downgrade path is not supported. The database cannot be opened because it is version.
Attaching a database gave me Error 948: a downgrade path is not supported. Here is why a database from a newer SQL Server version won’t open on an older one.
SQL SERVER – Identifying InMemory OLTP Hash Collisions
A follow-up to my post on hash collisions: DMV queries that help with identifying InMemory OLTP Hash Collisions caused by a poorly chosen bucket count.
Pester the Tester: PowerShell Bugs, Beware! – Notes from the Field #129
Pester the Tester: Robert Cain shows how Pester, an open source testing framework for PowerShell, helps you catch bugs before they catch you.