Fix it when the compatibility level drop down is empty in database properties, with SQL Server 2012 and 2014 on one machine. Cause and fix.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Windows File/Folder and Share Permissions – Notes from the Field #029
DBAs often skip Windows security because they are not Windows experts. Brian Kelley explains file, folder and share permissions and why teamwork matters.
Keeping msdb Small With sp_delete_backuphistory
Use sp_delete_backuphistory to control msdb growth, choose a retention window, and schedule weekly SQL Server Agent cleanup.
SQL SERVER – Reset SA Password – SQL in Sixty Seconds #066
Forgot the SA password or your DBA just left? This SQL in Sixty Seconds video shows how to reset SA password by logging in with Windows Authentication.
Syncing a Lookup Table Without MERGE: Insert, Update, Delete
Three plain statements can do the job of MERGE, and each one gives you its own row count. Here is how to build it, test it and trust it.
SQL SERVER – CTE can be Updated
Users often confuse a CTE with a temp table, but a CTE works like a view, and a CTE can be updated just like one. Matthew Spieth’s tip, with my notes.
UNISTR and Unicode Escapes in SQL Server 2025
Build Unicode strings with UNISTR in SQL Server 2025, compare NCHAR, and preserve accented letters, Hindi text, and emoji in storage.
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.