Building The First Azure Data Factory

Posted by on Jul 7, 2015 in Azure Data Factory | 3 Comments

Previously in another post I explained what is Azure Data Factory alongside tools and requirements for this service. In this post I want to go through a simple demo of Data Factory, so you get an idea of how Data Factory project builds, develops and schedules to run. You may see some components of Azure ...

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

What’s New in MDS of SQL Server 2016

Posted by on May 28, 2015 in MDS, SQL Server 2016 | 6 Comments

SQL Server 2016 CTP 2 released almost a day ago, and I’ve had a chance to install it and play with Master Data Services to see what changes has been made in this product. Master Data Services is a service of SQL Server first released in SQL Server 2008R2, and enhanced in SQL Server 2012. ...

Read More

DMX with .Net-Part 1

Posted by on May 26, 2015 in Data Mining | No Comments

Predictions always matter; it is always nice to find a pattern in existing data. It will help to have a more accurate decision-making. These days, I am busy with designing and implementing a prototype for tourist recommendation system. I need to use variety of data mining algorithm such as “clustering” “Decision Tree”, “Regression”, “Neural Network”. ...

Read More

Incremental Load: Change Data Capture in SSIS

Posted by on May 26, 2015 in SSIS | 8 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

DMX practice for Tourist Recommendation System

Posted by on May 18, 2015 in Business Intelligence | No Comments

  there is a first experience with DMX I employed  DMX in my .NET code last year to create a travel mining model for predictions travel budget, length of travel, destination. I need to predict via different algorithms. so I have  added a reference to Microsoft.AnalysisServices.AdomdClient to my C# project using Microsoft.AnalysisServices.AdomdClient; public AdomdConnection connection = ...

Read More