Your test passed as a user, yet the sales team still gets an error. Here is where each kind of impersonation stops, and how to get back out.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Msg 1833 – File Cannot be Reused Until After the Next BACKUP LOG Operation
Adding a file during a demo failed with Msg 1833: file cannot be reused until after the next BACKUP LOG operation. Here is the root cause.
SQL SERVER – FIX: Msg 35250 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed
A reader still got Msg 35250 after my first post, with no mirroring login error in the ERRORLOG. Here are the endpoint and service account checks I asked for.
Finding User Objects in master Created by Accident
Find user objects in master, inspect their purpose and dependencies, and prepare a safe move without removing deliberate server helpers.
How to Count Week Days Between Two Dates? – Interview Question of the Week #132
How do you count Week Days between two dates in SQL Server? Here is a short script I built from scratch using spt_values and DATEPART.
Finding Which Network Protocol Each Session Uses
Before you switch off a protocol, find out who still uses it. Two short queries show how each session connected, and why the address is not a person.
SQL SERVER – Invalid Object Name ‘master.dbo.spt_values’ in Management Studio
A client ran U_tables.sql from the Install folder by hand and then hit Invalid Object Name ‘master.dbo.spt_values’ in Management Studio. Here is why.
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.