Day 2 of the SQLPass Summit I attended Advanced T-SQL for SQL Server 2008 and Denali presented by Itzik Ben-Gan (twitter | site), this was rated a 499 Session, so not for the faint of heart. For those of you that don’t know who Itzik is just take a look at this site and what [...]
This is the solution post for – The Case of the Time it takes to Convert Time Zones So did you figure it out? The case asked 2 questions: What was the problem? How did it happen? What was the problem? So lets walk through how it would convert a datetime from CT to UTC. [...]
Full Disclosure – I loved Encyclopedia Brown as a kid. A couple weeks ago I was tasked with a the problem of unifying datetime fields within disparate databases that were loaded into a single data warehouse. The challenge was that vendor product A recorded all time in UTC while vendor product B recorded all time [...]