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.
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.
SQL SERVER – Fix – Error 15240, Severity: 16, State: 2 – Cannot write into file
Error 15240 stopped SQL Server starting after a patch. Tested on SQL Server 2025: three causes behind one message, and what my old fix missed.
How to Query Multiple SQL Server with a Single Query? – Interview Question of the Week #106
A senior DBA needed to check SQL Server 2016 SP1 on every server. Here is the neat way he used to query multiple SQL Server instances with a single query.