Overcoming SQL 08’s globally insensitive time zones using .NET

When SQL 08 came along there seemed to be some new hope for making time zone aware apps a little easier through the introduction of a few new date and time related data types, particularly the datetimeoffset type. Unfortunately all that glitters is not gold in this case and the new data type can be a real “gotcha”. Here’s how to build in that geo-awareness from the ground up using the new datetime2 data type and without getting caught with your metaphorical pants down.