Good article, great for those new to T-SQL and also a great reminder for those of us that are slightly more seasoned.  I deal with PostgreSQL alot and forget about how MS handles datetimes whenever I switch back to my MS SQL databases. 

I'll definately be adding this one to my breifcase.