Monthly Archives: February 2010

Rocky Mountain Tech Trifecta Impressions

Posted on February 28, 2010 by Glenn Berry

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

Posted on February 28, 2010 by Glenn Berry

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

Posted on February 26, 2010 by Glenn Berry

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

Posted on February 24, 2010 by Glenn Berry

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

Posted on February 22, 2010 by Glenn Berry

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

Posted on February 21, 2010 by Glenn Berry

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

Posted on February 21, 2010 by Glenn Berry

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

Testing New Features in SQL Azure Service Update 1

Posted on February 18, 2010 by Glenn Berry

It seems to be SQL Azure night for me tonight…  I thought I would try out some of the new features in SQL Azure Service Update 1. First I tried ALTER DATABASE to switch between the Web Edition and Business … Continue reading →

Posted in SQL Azure | Leave a comment

Playing With SQL Azure Data Synch

Posted on February 18, 2010 by Glenn Berry

Microsoft has provided a free tool that allows you to easily create a SQL Azure database, and then synchronize the data periodically (on a table by table basis) with an on-premises SQL Server database. You could use this to do … Continue reading →

Posted in SQL Server 2008 | 12 Comments

SQL Azure Database Service Update 1 Released on February 17

Posted on February 18, 2010 by Glenn Berry

Microsoft’s David Robinson has announced on the SQL Azure Team Blog that they have released Service Update 1 for SQL Azure. This update has four main changes: First, they have enabled  six Dynamic Management Views (DMVs), which will allow you … Continue reading →

Posted in SQL Azure | Leave a comment