Monthly Archives: September 2010

Stupid Tech Support Tales

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

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

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

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

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

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

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

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?

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

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