Monthly Archives: February 2010

Rocky Mountain Tech Trifecta Impressions

I attended and presented at the Rocky Mountain Tech Trifecta yesterday, where I had a very nice time. Julie Yack did a great job of organizing the free event, which had nearly 700 registrations. There were a lot of sponsors, … Continue reading

Posted in Teaching | 2 Comments

Weekly Electrical Usage from Google PowerMeter

Since I like to measure and monitor things (maybe that is why I am a DBA), and I care about the environment, I installed a TED 5000 and connected it to Google PowerMeter about six weeks ago. Every week, Google … Continue reading

Posted in Computer Hardware | 5 Comments

Dr. DMV Script for Rocky Mountain Tech Trifecta

Here is the script that has the diagnostic queries that I will be using during my presentation at the Rocky Mountain Tech Trifecta on February 27. — SQL Server 2008 and R2 Diagnostic Information Queries — Glenn Berry — February … Continue reading

Posted in SQL Server 2008 | 9 Comments

Upcoming Speaking Event Schedule

I have a fairly busy schedule of upcoming speaking events (especially for someone with a full-time day job). I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume … Continue reading

Posted in Teaching | 2 Comments

Power Plans and Windows Server 2008 R2

After seeing an interesting blog post on AnandTech IT last week that showed slower query response time in x64 SQL Server 2008 running on x64 Windows Server 2008 when using the default “Balanced” power plan compared to the “High performance” … Continue reading

Posted in Windows Server 2008 R2 | 1 Comment

Experiments with Data Compression in SQL Server 2008

Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use either Page or Row compression on the clustered index or any non-clustered indexes on a table. Data compression lets SQL … Continue reading

Posted in SQL Server 2008 | 1 Comment

New iSCSI Performance Benchmark from Microsoft and Intel

The Windows Server Division blog has a post up trumpeting a very impressive iSCSI benchmarking result achieved with Intel hardware and Microsoft Windows Server 2008 R2 software in January of 2010. Running on server hardware equipped with an Intel Xeon … Continue reading

Posted in Windows Server 2008 R2 | 8 Comments