Monthly Archives: May 2010

Five Things SQL Server Should Drop

Joining in the current meme started by Paul Randal (blog | twitter), here is my list of five features or settings that SQL Server should not have. The current SQL Server setup program. Several people have commented on this, but … Continue reading

Posted in SQL Server 2008 R2 | 1 Comment

Finding Enterprise Only Features in Your SQL Server 2008 Database

Microsoft added a new DMV, sys.dm_db_persisted_sku_features to SQL Server 2008 that you can use to determine whether you have any Enterprise Edition only features in a particular database. — Detect Enterprise Edition Features — Glenn Berry — May 2010 — … Continue reading

Posted in SQL Server 2008 | 1 Comment

Colorado Springs SQL Server User’s Group Meeting on Wednesday, May 19, 2010

The Colorado Springs SQL Server User’s Group is having their May meeting on May 19. It will be held at the Ruth Holley Public Library in Colorado Springs. I will be presenting my Dr. DMV presentation and demo. The abstract … Continue reading

Posted in Teaching | Leave a comment

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