Use realistic data and workload tests to evaluate a database, checking correctness, latency, recovery, compatibility, and the full operating cost.
Anniversary of SQL Wait Stats Book: Memories From the First Year
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 – 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.