Bug: DBCC CHECKDB data purity checks are skipped for master and model

After going back and forth with someone with a corrupt master database, I’ve just discovered a bug. And unfortunately it goes back to SQL Server 2005 so the responsibility is mine for not realizing the problem at the time (but at least it’s not a bug in how my DBCC CHECKDB code works, it’s a […]

A few seats still available in September classes in WA

There are only a few weeks to go until our September set of classes start in Bellevue, WA and there are still some open seats available. IE1 Immersion Event on Internals and Performance, 9/16-20, is sold out at 36 IEHW Immersion Event on SQL Server Hardware, 9/18-19, has several seats left, plus a two-for-one deal – […]

Survey: tempdb and transaction log IO latencies

Time for another survey! This survey’s very simple: run the following code on as many of your production instances as you can, and post a comment with the results or send me plain text/spreadsheet output in an email. Please do not add any more info to the results (like server name, commas, lines) as it’s not relevant […]

More than half of all SQL Server instances are out-of-date and unsupported!

Back in May I started a survey to collect build numbers to see how up-to-date people keep their SQL Server instances and I’ve been putting off writing this post as I wanted to do justice to the data. I received results for 3085 SQL Server instances from several hundred respondents – thank you! I broke […]