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 about Road Map to use Microsoft ML tools[…]
“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 about R Chart into SSRS (ggplot2 package in SQL Server 2017)-Part 2[…]
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 about Microsoft SQl Server ML Services: RevoScaleR Package[…]
Ever wanted to create a diagram of your MS SQL Database tables in Power BI? Here is what I did to make that happen. The approach is to build a query that can be run against the catalog system views inside each MS SQL database. The approach is to build a list of “From” and Read more about Diagram your Database Tables using Power BI[…]
It is my pleasure to speak in PASS 24 Hours session for Evolution of Data Platform on the topic above. I look forward to meet you all in this webinar. registration is free, but limited. So reserve your seat now. Here are some information about my session and 24HOP. 24HOP 24 Hours of PASS is Read more about Temporal Tables and Their Roles in ETL and Data Warehouse[…]
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 about Split Function in SQL Server 2016[…]
SQL Server 2016 CTP 3.0 is available, and some of you already played with it. There are great set of new features for BI in 2016 in all areas; SSIS, MDS, SSRS, and SSAS. However there are some features which are part of Database Engine but still relates to BI and Data Warehousing. Temporal Tables Read more about Temporal Tables: A New Method for Slowly Changing Dimension[…]
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[…]
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;
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. There was no changes in MDS of SQL Server 2014. But fortunately MDS wheels are spinning now, there are some changes in 2016. Changes are not major though they are evidence of Microsoft investing on this services nowadays.