It is with great pleasure to announce that I will be speaking in SqlBits 2016 Liverpool which happens from 4th to 7th May 2016. I will be speaking one of my favorite topics which is comparing SSIS as on-premises ETL tool with Azure Data Factory as cloud data ingestion service. My session scheduled for 4pm Read more about I Will Speak at SqlBits; Azure Data Factory vs SSIS[…]
Thanks to all attendees to my session today at SQL Saturday Sydney. It was a pleasure to have you all in front of me, and having those great questions and feedback from you. This was my second time in Sydney, and I’m looking forward to the next gathering hopefully next year. Special Thanks to Grant Read more about Presentation Materials for My Session at SQL Saturday Sydney 2016[…]
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 about ETL Incremental Load with SSIS; Q&A and Recording[…]
It is pleasure to let you know that we will be in Australia: Sydney, and Melbourne February 2016 to deliver SSIS and Machine Learning Courses. Courses are adjusted to a one-day program with heaps of demos and handouts for audience. Our courses designed in a pragmatic approach in the way that enables you to start Read more about Our Courses: February 2016 Australia[…]
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 about SSIS Incremental Load with Datetime Columns[…]
I’ve been honored to talk with Carlos L Chacon about Azure Data Factory after my session at PASS Summit, and he published the webcast in hist website; SQLDataPartners. Thanks to Carlos and SQLDataPartners for the great opportunity to talk on one of my favorite topics as Data movement with the new technology; Azure Data Factory. Read more about Podcast: Azure Data Factory[…]
SQL Server 2016 brings some new features for Integration Services such as AlwaysOn, and Custom Advanced Logging. You’ve probably read about these features in other blog posts, If you haven’t I encourage you to read some of them, like this. These changes also comes with some changes in SSIS Catalog, in this post I’m going Read more about SSIS Catalog Changes in 2016[…]
SSIS has been used for a while now in the business, and many people worked with SSIS. However their level of working and experience and knowledge of SSIS is not the same. There are people who only touched this tool, as well as people who know SSIS inside-out. As a BI or ETL manager and Read more about Prepare for SSIS Interview[…]
It was my honor to present for the third year in a row in PASS Summit 2015. I’ve seen many familiar faces of #SQLFamily, many MVPs, MCMs, Speakers and PASS HQ. I’ve presented my favorite topic here this year which was: Azure Data Factory vs SSIS. Slides shared in PASS website, but I also uploaded Read more about Slides of my Session at PASS Summit 2015: Azure Data Factory vs SSIS[…]
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 about SSIS 2016; What’s New in CTP 2.3[…]