Match RPO and RTO to backups, log shipping, failover clusters, or availability groups, then test the full service recovery path.
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.
Currency Rates by Effective Date: Designing the Lookup Table
Why did last quarter’s invoices change overnight? Probably because the rate table had no dates. Here is a lookup that remembers.
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.
SQL SERVER – AlwaysOn AG (Availability Group) and TDE Error – Please Create a Master Key
A TDE enabled database would not synchronize in an AlwaysOn availability group, and ERRORLOG said please create a master key. Here is what I found.
Error 2628: Finding the Value That Would Be Truncated
A nightly import fails and nobody knows which column is too small. Error 2628 tells you. Here is how to read it and catch every oversized value up front.