A restart ate your script, but maybe not all of it. Two places to look: SSMS recovery files and the text SQL Server remembers.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Inserting into Sparse Column Sets and Errors Associated With It
You can write to sparse column sets directly, not just read them. I show how to insert into column sets and the errors you hit without an explicit column list.
Interview Question of the Week #029 – Difference Between CHARINDEX vs PATINDEX
Compare CHARINDEX vs PATINDEX, test literal and wildcard searches, preserve positions, and use SQL Server 2025 REGEXP_INSTR when needed.
How to Find Queries Running in Parallel in SQL Server
To find queries running in parallel, read max_dop and the CPU to elapsed ratio from the query stats view, then confirm with the plan XML. This post tests both on a two million row table. It also explains why the same query stays serial until its cost passes the threshold.
SQL SERVER – FIX – Property IsLocked is Not Available for Login
Opening sa login properties in SSMS failed with Property IsLocked is not available for Login. I used Profiler to find the query returning NULL, and here is the fix.
Median Day Planning: Time Management That Survives a Normal Week
Median day planning means sizing your week around a typical day, not your best one. This post shows how to measure your own median in ten workdays, split work into a commit list and a stretch list, and keep a small buffer. Your plan then survives a normal week.
Test Data That Looks Like Production
Test data that looks like production matches distributions, relationships, and volume without copying sensitive values into development.
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.