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[…]
SQLBits is happening again in May 2016 this year in Liverpool, the biggest SQL Server conference in UK. This is a conference that I hadn’t yet chance to attend (I have been selected to present twice so far, but for some other reasons couldn’t attend unfortunately). So here we go; many awesome session abstract has Read more about Vote For your Favorite Sessions at SQLBits 2016[…]
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 overseas with family and old friends till yesterday and hadn’t chance to say Happy New Year here. It’s another year beginning, and I wish you enjoy this year besides your friends and family, I wish this be a wonderful year for all of you. It is a fortunate to be in MVP award Read more about MVP awarded for 6th Year[…]
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[…]
One of the interesting features of Master Data Services 2016 is Change Set and Require Approval. In prior versions of MDS when you apply a change and publish that change automatically take place in the entity and records. However in the new MDS in SQL Server 2016 you can create a Change Set of your Read more about Change Set and Approval Workflow in MDS 2016[…]
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[…]
In previous steps you’ve learned how to extract and mash up the data from CSV and automate the process of looping through all CSV files in the source folder. In this step we are going to build visualizations based on the data set we’ve built so far. In this post you will see how easy Read more about Be Fitbit BI Developer in Few Steps: Step 3 Visualization[…]
In the first step you’ve learned how to manipulate and mash up the data with few changes in Power Query M script. In spite of Power BI Desktop not being able to recognize your CSV file correctly because of the header row, you managed to write script and fetch data as you required. However this Read more about Be Fitbit BI Developer in Few Steps: Step 2 Loop Through All CSV Files[…]