Monthly Archives: May 2010

Denver SQL Server User’s Group Meeting on Thursday, May 20, 2010

The Denver SQL Server User’s Group will be having their May meeting next Thursday, May 20. As always, the meeting will be held at AmeriTeach, which is located at: AmeriTeach7800 East Dorado Place, Suite 150Greenwood Village, CO 80111720-346-1710 Meeting Agenda:5:30 … Continue reading

Posted in Teaching | Leave a comment

Some SQL Server Date and Time Examples

I had a question from a developer yesterday about how to calculate the difference between local time (on the database server), and UTC Time. This needed to work in SQL Server 2005. It turns out that this is pretty easy … Continue reading

Posted in SQL Server 2008 | 1 Comment

Using CPU-Z to Discover Hardware Information

I think it is very important to be able to discover exactly what type of hardware is in an existing database server, along with how it is configured. I am always disappointed when I ask someone what kind of hardware … Continue reading

Posted in Computer Hardware | Leave a comment

Spring 2010 Hardware Recommendations

Since I am very interested in various PC-based hardware, and I make an effort to stay current on new developments, I thought I would make some generic hardware recommendations in case you are in the market for new hardware. I … Continue reading

Posted in Computer Hardware | Leave a comment

Register For 24 Hours of PASS Event

The free 24 Hours of PASS event will be held on May 19-20, and includes 24 different one hour presentations and demonstrations by a group of well known SQL Server experts on many different aspects of SQL Server, with a … Continue reading

Posted in SQL Server 2008 R2 | Leave a comment

Recap of April 2010 DMV a Day Series

Well, I managed to finish up my series that featured a DMV query every day during the month of April. I appreciate all of the comments and feedback I received. One suggestion I got from several readers was to recap … Continue reading

Posted in SQL Server 2008 | 9 Comments