Road Map to use Microsoft ML tools

I normally work with most of the Microsoft tools for the aim of doing machine learning. I came up with a roadmap that shows what option for machine learning we have with Microsoft tools in Data Platform. this roadmap is not completed yet, I need to update it one later with some tools such azure ...

Read More

R Chart into SSRS (ggplot2 package in SQL Server 2017)-Part 2

“In the last post, you have seen how we can create a chart by importing data from SQL Server 2017. By doing this, we have a reliable code for drawing chart. Now, we sure our codes work fine, we can put the codes in SQL Server 2017. In this post, I am going to show ...

Read More

Microsoft SQl Server ML Services: RevoScaleR Package

  RevoScaleR Package RevoScaleR is packages created by Revolution Analytics (own by Microsoft) with the aim of importing, transforming, and analyzing data at scale. There are different categories of functions for the data store, imports and save as, data transformation, draw some charts such as histogram, line and so forth, descriptive analysis, predictive analysis, package ...

Read More

Split Function in SQL Server 2016

Posted by on Mar 4, 2016 in SQL Server 2016 | One Comment

It was about 4 years ago that I’ve wrote a custom function to split a delimited string in T-SQL. I’ve wrote that because there was no split function for SQL Server at that time. Fortunately SQL Server 2016 comes with new excitements, and built-in split function is one of them. The new String_Split function is ...

Read More

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

MDS 2016: What’s New in CTP 2.2

Posted by on Aug 4, 2015 in MDS, SQL Server 2016 | One Comment

On Late May when CTP 2.0 of SQL Server 2016 published, I’ve wrote a blog post about What’s New in MDS 2016. Recently CTP 2.2 has been published, and I’ve seen some new features again added to MDS. In this post I’ll explain new features of MDS 2016 CTP 2.2 which are; Entity Sync SCD ...

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