What is the Common Data Model and Why Should I Care? Part 3 of Dataflow Series in Power BI

In the last two articles, you have learned what is Dataflow and sample use case scenarios of that in Power BI, and also you learn how to create a dataflow. Before going any further in the dataflow discussion, we have to make a quick pause and talk about the Common Data Model (CDM). Dataflow integration ...

Read More

ETL Incremental Load with SSIS; Q&A and Recording

Posted by on Jan 27, 2016 in ETL, SSIS | No Comments

Thanks to all attendees to my webinar today, with more than 400 registration I’m thrilled to say this very first RADACAD webinar was a successful step towards regular free webinars. If you are interested in future webinars please stay tuned, we will announce them all in our events page. Today’s webinar was about ETL Incremental ...

Read More

SSIS Incremental Load with Datetime Columns

Posted by on Jan 12, 2016 in ETL, SSIS | 14 Comments

Previously I’ve mentioned how to implement Incremental Load within SSIS using CDC (Change Data Capture) feature. Unfortunately CDC is not always supported by the source database, so you have to implement an incremental load solution without CDC. In this post I’ll explain how to implement incremental load if there is a modified datetime column in ...

Read More

SSIS Demos in Action: Tutorial Videos

Posted by on Jun 17, 2015 in SSIS | No Comments

SQL Server Integration Services is not a new technology, this technology is a mature data transfer and data consolidation tool which has been in the market since 2005. Prior than that SSIS had another name; DTS. However SSIS nowadays is capable of doing far more than what DTS had to offer. You can transfer data ...

Read More

Incremental Load: Change Data Capture in SSIS

Posted by on May 26, 2015 in SSIS | 12 Comments

Incremental Load is always a big challenge in Data Warehouse and ETL implementation. In enterprise world you face millions, billions and even more of records in fact tables. It won’t be a practical practice to load those records every night, as it would have many downsides such as; ETL process will slow down significantly, and ...

Read More

Speaking at SQL Saturday 352 Sydney: ETL Architecture for Solving Data Warehouse Challenges

Posted by on Nov 2, 2014 in ETL, Presentations, SSIS | No Comments

Hi, Thanks for all attendees to my session at SQL Satuday 352 Sydney, It was great to meet Grant, and Iman and also some Persian folks in this event. I was talking about my favorite subject: ETL Architecture for Solving Data Warehouse Challenges Session Description: Data Warehouses are heavily in use nowadays in most of ...

Read More