T-SQL/database unit test

I found this article about T-SQL/database unit testing.

Katmai June CTP released now

I just saw that Microsoft released the first CTP of Katmai (June CTP). You can register here. David Hayden has a post about some new features in SQL Server 2008. Read the post here. I found a webcast from Tech-Ed 2007 in Orlando when David Campbell has the first presentation of SQL Server 2008.

The virtual earth integration and the location data type are really cool. I don't know if I ever will need them but... it's still cool.

Natural vs artificial primary keys

A never ending discussion is about natural vs artificial primary keys in the database. There are so many fundamentalists in this area. I found a really good article in this area called "What should I choose for my primary key?".

I really agree in what they say in the summary "In the end, nobody can really tell you whether you should use an IDENTITY or a GUID(), or whether you should use a natural or artificial key; they can guide you, certainly, but nobody knows your data and intent better than you.".

There are no way to do this that always is the best. Use whats best in the current situation. Never be a fundamentalist.