Read the SQL Server error log for startup details and incident context, filter it with T-SQL, and cycle files without losing needed history.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – UDF to Return a Calendar for Any Date for Any Year
Reader Dan Golden built on my weekly calendar function to create a UDF to return a calendar for any date for any year. I fixed a small first and last week bug.
Checking XACT_STATE Before COMMIT or ROLLBACK in a CATCH Block
XACT_STATE separates transaction validity from the decision to retain work. Two isolated examples show a doomed transaction and a committable one, both with deliberate errors. Clean up on the same connection and respect the caller’s transaction ownership.
Rolling Back a Cumulative Update Safely
Rolling Back a Cumulative Update needs backups, setup evidence, a tested uninstall path, and special care for databases changed after patching.
SQL SERVER – How to Escape Single Quotes – Fix: Error: 105 Unclosed quotation mark after the character string
Jr. Developer asked me other day how to escape single quote?
User can escape single quote using two single quotes (NOT double quote).
SQL SERVER – Msg: 2593 : There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.
DBCC shows Msg 2593: There are ROWCOUNT rows in PAGECOUNT pages for object. It is harmless and for information only. Here is what it means.
LOG With a Base: Make the Calculation Explicit
LOG with a base makes logarithm meaning explicit. Compare base two, base ten and the natural default using typed, positive inputs.
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.