SSIS 2016; What’s New in CTP 2.3

Posted by on Sep 6, 2015 in SQL Server 2016, SSIS | 4 Comments

SQL Server 2016 is under a heavy improvement plan, The latest CTP version (Community Test Preview) of it is 2.3 which released as preview three days ago. CTP 2.3 has some new features across all components of SQL Server, such as SSRS, SSAS, SSIS, MDS and etc. Previously I wrote about some new changes 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

Speaking at TechEd New Zealand 2014

Posted by on Sep 3, 2014 in ETL, Presentations, SSIS | No Comments

It is my pleasure to speak in TechEd New Zealand 2014.  TechEd is happening between 9th to 12th of September, and it will be held in SkyCity, Auckland, New Zealand. the topic that I will talk about is:   ETL Architecture for Solving Data Warehouse Challenges Description: Data Warehouses are heavily in use nowadays in ...

Read More

SQL Satuarday 316: Christchurch: ETL Architecture for Solving Data Warehouse Challenges

Posted by on May 24, 2014 in ETL, MDS, Presentations, SSIS | No Comments

I am honored that I will speak in SQL Saturday 316 Christchurch on 14th of June 2014. Presentation topic is : ETL Architecture for Solving Data Warehouse Challenges presentation Description: Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher performance, faster and more insightful data analysis ...

Read More