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...

Lambda Architecture for the DWH

Recently I saw this post from Davide Mauri (basically he announced his session "Reference Big Data Lambda Architecture in Azure" at SQL Nexus). Although I would've loved to attend SQL Nexus, I'm not able to do so this year 🙁 . The next best thing I could do was order and read Marz & Warren's "Big Data" (Manning) -
Continue reading...