Context switching costs more than the seconds it takes to change windows. This post compares attention with SQL Server commits: pay the fixed fee once per batch, not once per ping. It gives concrete ways to batch messages, tickets and reviews, and ends with a short checklist.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Why datetime Turns .999 Milliseconds Into the Next Day
See why 999 milliseconds rounds into tomorrow with datetime, compare datetime2 precision, and use an exclusive next-day report boundary.
max_length in sys.columns: Bytes, Not Characters
Your generated column came out twice as wide as the original. Here is why max_length counts bytes and how to turn it back into a real declaration.
MySQL – Get Latest Identity Value by Inserts
In MySQL, use the LAST_INSERT_ID() function to get the latest identity value after an insert, like @@IDENTITY or SCOPE_IDENTITY() in SQL Server.
Interview Question of the Week #045 – How to Do Case Sensitive Search?
How do you do a case sensitive search in SQL Server? Use COLLATE Latin1_General_CS_AS in the query, or change the column collation to make it permanent.
SQL SERVER – Installation Failed With Error – Wait on the Database Engine Recovery Handle Failed
I ran SQL Server setup on a domain controller by mistake, and the Installation Failed at ‘Wait on the Database Engine recovery handle’. Here is what fixed it.
SQL SERVER – Backup to Azure Blob error – The remote server returned an error: (409) Conflict
My backup to Azure Blob started failing with The remote server returned an error: (409) Conflict. Here is what the ERRORLOG showed and what it means.
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.