SQL Server setup failed with 0x851A001A: Wait on the Database Engine recovery handle failed. The ERRORLOG showed error 17120. Here is what caused it.
SQL SERVER – Using dm_db_stats_properties With InMemory OLTP Tables
Does sys.dm_db_stats_properties show modified rows for InMemory OLTP tables? I tested it, and memory-optimized tables are now covered. Here is what I found.
SQL Server Performance Mistakes: Three Checks to Run Today
SQL Server performance mistakes hide in the settings, the files and the code. This post checks four server settings, shows poor file growth and its fix, and measures two code mistakes, a function on an indexed column and a data type mismatch, in logical reads.
SQL SERVER – Script level upgrade for database ‘master’ failed – There is already an object named ‘DatabaseMailUserRole’ in the database
After patching, script level Upgrade for master failed: there is already an object named ‘DatabaseMailUserRole’. Here is what caused it and how to fix it.
When was Database Last Backed Up in SQL Server? – Interview Question of the Week #107
When was each database last backed up? Here is the script I share in training that lists full, differential and log backup history for your server.
Spotting Definition Drift With HASHBYTES on Module Code
Did someone change a production procedure and forget to tell you? Hash the module text, compare it with a baseline, and let SQL Server point at the culprit.
SQL SERVER – Understanding JSON Use is Case-Sensitive
My daughter explores every new toy, and that is how I play with JSON in SQL Server 2016. One surprise: JSON paths are case-sensitive, as this example shows.