A year ago I published my second book, SQL Wait Stats. On this first anniversary of SQL Wait Stats book, here are some memories from that journey: the blog series behind it, the work with my co-author, and why September 1st is a special day for me.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Error: Fix – Msg 208 – Invalid object name ‘dbo.backupset’ – Invalid object name ‘dbo.backupfile’
Msg 208, Invalid object name ‘dbo.backupset’, but only in SSMS? A reader’s backup history query failed there while it worked in the app. Here is what was going on.
SQL Server Architecture Terminology: A Beginner’s Guide by Anil Kumar
SQL Server architecture terminology is easier to follow when each term can be seen in a running instance. This guest introduction by Anil Kumar covers instances, storage, memory, the transaction log and SQLOS, with tested queries on SQL Server 2025.
Insert Multiple Rows in SQL Server: SQL in Sixty Seconds #024
To insert multiple rows in SQL Server, use separate INSERT statements, UNION ALL or one VALUES list. The tests here compare all three on SQL Server 2025, including failures, the 1,000 row limit and the time for 1,000 rows.
SQL SERVER – A Brief Note on SET TEXTSIZE
Is there any difference between the LEFT function and SET TEXTSIZE? A quick script shows how each one trims a long VARCHAR(MAX) value in the results.
SQL SERVER – Answer – Value of Identity Column after TRUNCATE command
Seed 11, reseed to 1, then TRUNCATE: what comes next? Here is the answer on the identity column after TRUNCATE, with the script and reader comments.
What to Collect When SQL Server Is Slow
Collect SQL Server diagnostic data in a useful order: waits, active requests, blockers, execution plans, and file IO during the slow period.
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.