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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
Frame Your Week: Why a Weekly Review Beats a Daily To-Do List
A weekly review beats a daily to-do list because it shows seven days of work at once. This post borrows the rolling window from SQL to show how to look back, look ahead and choose up to four outcomes. It ends with a checklist you can try this week.
SQL SERVER – What is SQL Server Operating System?
What is the SQL Server Operating System, or SQLOS? An attendee spotted SOS waits after reading my wait stats book, and here is my simple explanation.
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.