Monthly Archives: September 2010

Stupid Tech Support Tales

Posted on September 30, 2010 by Glenn Berry

One of our desktop support technicians noticed the following error from a 3rd party vendor application in an error log: "9/22/2010 1:02 AM (GMT-06:00): The xxxxx Maintenance Service has reported an error. (200) CCmd: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist … Continue reading →

Posted in SQL Server 2008 R2 | Leave a comment

Geekbench 2.1.7 Released

Posted on September 30, 2010 by Glenn Berry

If you read my blog or follow me on Twitter, you know that I have a strong interest in database server hardware. Having properly selected and sized database server hardware gives you a strong foundation to architect and implement a … Continue reading →

Posted in Computer Hardware | Leave a comment

A Small Selection of SQL Azure System Queries

Posted on September 29, 2010 by Glenn Berry

I had a question come up during my “Getting Started with SQL Azure” presentation at SQLSaturday #52 in Denver last Saturday that I did not know the answer to. It had to do with how you could see what your … Continue reading →

Posted in SQL Azure | Leave a comment

Windows Power Plans and CPU Performance

Posted on September 28, 2010 by Glenn Berry

Back in February, 2010, I did some preliminary testing on the effects of various BIOS settings and Windows Power Plans on processor performance in Windows Server 2008 R2 using the cross-platform Geekbench benchmark. That round of testing used an 2.8GHz … Continue reading →

Posted in Windows Server 2008 R2 | 17 Comments

SQLSaturday #52 Report

Posted on September 27, 2010 by Glenn Berry

I was lucky enough to present two sessions at SQLSaturday #52 in Denver on September 25, 2010. By my estimate, there were probably between 200-250 attendees for the event. The event was well organized, with easy parking, plenty of food, … Continue reading →

Posted in Teaching | Leave a comment

SQL Server Quiz 2010

Posted on September 27, 2010 by Glenn Berry

SQL Sever MVP Jacob Sebastian (blog/twitter) has been working hard to organize the SQL Server Quiz 2010 event which will be starting on October 1, 2010. This will be a series of 30 Quiz questions, presented each day by a … Continue reading →

Posted in Teaching | Leave a comment

Project Phoenix For Unemployed and Underemployed Developers

Posted on September 27, 2010 by Glenn Berry

SQL Server MVP Arnie Rowland (blog/twitter) has put a lot of effort into conceiving, organizing, and publicizing Project Phoenix over the past several months. Just in case you have never heard of this effort, the gist of it is to … Continue reading →

Posted in Microsoft Training | Leave a comment

Microsoft Releases SQL Server 2008 SP1 Cumulative Update 10

Posted on September 22, 2010 by Glenn Berry

On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29 fixes in this cumulative update. This fixes apply to lots of different areas of the product, including SSAS, SSIS, SSRS, … Continue reading →

Posted in SQL Server 2008 | Leave a comment

What Do You Think Just Happened To This Database Server?

Posted on September 20, 2010 by Glenn Berry

This is a screenshot of Task Manager for a database instance that is part of a synchronous database mirroring partnership in SQL Server 2008 R2. We are using synchronous database mirroring, with a Witness instance, so we have automatic failover. … Continue reading →

Posted in SQL Server 2008 R2 | Leave a comment

Home Theater Upgrades

Posted on September 19, 2010 by Glenn Berry

Back in late 2003, I had my basement finished,and as part of that effort, I put in a dedicated home theater with a 105” 16×9 screen, an Infocus ScreenPlay 7200 720p DLP projector and 8.1 sound. This setup has worked … Continue reading →

Posted in Entertainment | 1 Comment