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 [...]
SQL Saturday #67 is now in the books. We learned from the first event and made some changes and I think the result was better. Here are some things that we changed: Core Team Last year: Last year the event was organized by Ted (blog | twitter), Wendy (blog | twitter) and myself. This was [...]
Continuing the CDC debugging posts: Intro First Problem Now that I have the StartLSN and EndLSN I was ready to go. Hit my breakpoint and the variables were set appropriately. Woo-hoo! Then…wait a minute…what? vSQLQuery.Value = “SELECT ” + ” c.__$operation ” + ” , c.Column1 ” + ” , c.Column2 ” + ” , [...]