This week I’m attending SQLPass, and Monday was the first Pre-Con day. I had the pleasure of sitting in “A Day of SSIS in the Enterprise” presented by Andy Leonard (blog|twitter), Tim Mitchell (blog|twitter) and Matt Mason (blog|twitter). Having spent a significant time in SSIS already and even had thanked a few people, including Andy, [...]
Displaying the most recent of 85 posts written by
Vendoran
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 [...]