My cousin tried InMemory tables on SQL Server 2016 and hit Msg 41337 while creating one. Here is what the error means and how to get past it.
SQL SERVER – T-SQL Window Function Framing and Performance – Notes from the Field #103
Kathi Kellenberger shows how window function framing and performance are linked, and why relying on the default frame can hurt. Notes from the Field #103.
Why datetime Turns .999 Milliseconds Into the Next Day
See why 999 milliseconds rounds into tomorrow with datetime, compare datetime2 precision, and use an exclusive next-day report boundary.
max_length in sys.columns: Bytes, Not Characters
Your generated column came out twice as wide as the original. Here is why max_length counts bytes and how to turn it back into a real declaration.
MySQL – Get Latest Identity Value by Inserts
In MySQL, use the LAST_INSERT_ID() function to get the latest identity value after an insert, like @@IDENTITY or SCOPE_IDENTITY() in SQL Server.
SQL SERVER – Installation Failed With Error – Wait on the Database Engine Recovery Handle Failed
I ran SQL Server setup on a domain controller by mistake, and the Installation Failed at ‘Wait on the Database Engine recovery handle’. Here is what fixed it.
SQL SERVER – Backup to Azure Blob error – The remote server returned an error: (409) Conflict
My backup to Azure Blob started failing with The remote server returned an error: (409) Conflict. Here is what the ERRORLOG showed and what it means.