Benchmarking: 1-TB table population (part 5: network optimization again)

Blog posts in this series: For the hardware setup I'm using, see this post. For an explanation of log growth and its effect on perf, see this post. For the baseline performance measurements for this benchmark, see this post. For the increasing performance through log file IO optimization, see this post. For the increasing performance through separation […]

Working with SQL Server Magazine

Great news! Kimberly and I have started doing a bunch of work with SQL Server Magazine (of course we're already pretty heavily involved with their parent company Penton Media, as they run the SQL Connections bi-annual conference that Kimberly and I Co-Chair). I've become a Contributing Editor of the magazine, and Kimberly has been for ages […]

TGIF Time Warp

Once in a blue moon I come across something cool and it happens to be Friday, and I blog about it. Last time was drinking Guinness in Dublin and the time before was an insane driving skills video (see here). My (scary) friend and fellow SQL MVP Grant Fritchey (Twitter|blog) posted the first two lines […]

Inside sys.dm_db_index_physical_stats

Way back in the mists of time, at the end of the last century, I wrote DBCC SHOWCONTIG for SQL Server 2000, to complement my new invention DBCC INDEXDEFRAG. I also used to wear shorts all the time, with luminous orange, yellow, or green socks. Many things change – I now have (some) dress sense, […]

In the news: our maintenance audits get rave reviews

Back in January I offered a promotion as a way of introducing our maintenance/operations auditing services. Now I've completed a bunch of them, with some excellent results for customers. One international customer, Plex Systems, was so pleased with the outcome of my audit of their manufacturing ERP software hosting databases that they issued a press release today […]

Benchmarking: 1-TB table population (part 4: network optimization)

Blog posts in this series: For the hardware setup I'm using, see this post. For an explanation of log growth and its effect on perf, see this post. For the baseline performance measurements for this benchmark, see this post. For the increasing performance through log file IO optimization, see this post. For the increasing performance through separation […]

TechNet Magazine: March 2010 SQL Q&A column

The March edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's topics are: Distributed transactions and database mirroring – why they don't work together Background processes that can cause I/Os even with no connections to the server How to restore backups […]

New hardware to play with: Fusion-io SSDs

Christmas comes but once a year… really? Then mine just came early on this afternoon's UPS truck. The very nice folks at Fusion-io just sent me two of their fully-loaded top-of-the-line ioDrive Duos with 640GB of solid-state flash memory in each. This is really extra-nice of them because on Dell's Small Business website they're currently […]

Still some spots available on the 5-day class in Boston in 3 weeks

Our first public class of the year is just over 3 weeks away! This is the *only* public class we'll be teaching in the US in 2010. There are a few spots left so book now to avoid disappointment. We've teamed up with our good friend Adam Machanic to bring a week-long custom class to the […]