Calculating commute distance using SSIS and the GoogleMaps API

Last week, I had an interesting question from one of my clients about estimates of planned commute distances. For example: What is the distance I travel when I, living at Kalverstraat 7 (Amsterdam) commute five days a week to my customer in Paris (1, rue Victor Cousin)? By the way: it should be calculated for all employees, for
Continue reading...

Choosing the right tool

I once heard someone say: if you use SSIS to do ETL, you are just not a good enough programmer in SQL. Needless to say I had some thoughts about that! We had a discussion about ETL and what tool is the most suited for that task. In the end it came down to the fact that
Continue reading...