Why does sp_spaceused show no values for a table that clearly has rows? It stumped me for 10 minutes. Here is the puzzle, try it before reading on.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – The header for file Path is not a valid database file header. The PageAudit property is incorrect
SQL Server would not start: model.mdf did not have a valid database file header and the PageAudit Property was incorrect. How I got it running again.
SQL SERVER – SQL Server: Getting OS information using DMV
Need the Windows version SQL Server runs on? Get OS information with the sys.dm_os_windows_info DMV, or read it from the ERRORLOG at startup.
How to Enable Auto Update Statistics and Auto Create Statistics with T-SQL – Interview Question of the Week #108
Question: How to Enable Auto Update Statistics and Auto Create Statistics? Let us learn how we can fix that in today’s blog post.
Database Mirroring Connection Error 4: An Error Occurred While Receiving Data 10054
A database mirroring connection error needs evidence from both ends of the connection. In a 2017 Azure case, the clue was a missing CONNECT permission on the endpoint. I tested the endpoint queries on SQL Server 2025 with a scratch endpoint, a grant, a deny and a stopped endpoint.
SQL SERVER – Error: 566, Severity: 21 – An Error Occurred While Writing an Audit Trace. SQL Server is Shutting Down
SQL Server shut itself down with error 566: an error occurred while writing an audit trace. Here is what the ERRORLOG showed and how to fix it.
SQL SERVER – Script to Find and Monitoring TempDB Space Usage
Monitor tempdb space usage with separate data-file and log checks. Find task allocations and open transactions before choosing a remedy.
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.