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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.