Find user objects in master, inspect their purpose and dependencies, and prepare a safe move without removing deliberate server helpers.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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 – Can I Delete Always On Availability Groups Initial Sync Folder?
Can you delete the shared folder used for the initial sync of Always On availability groups? A client asked, and yes, you can remove it without any impact.
SQL SERVER – Interesting Observation – Count of Temporary Table Re-generations
A workshop attendee asked how to know the count of temporary table re-generations for a single temp table. Here is how I find it.
SQL SERVER – How to See Scripts Executing in sp_executesql?
How can you see the scripts executing in sp_executesql without an extra SELECT result set? A reader asked me, and here is the simple answer.
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.