Loan Classification using SQL Server 2016 R Services

R Services (In-database) provides a platform for developing and deploying intelligent applications that uncover new insights. You can use the rich and powerful R language and the many packages from the community to create models and generate predictions using your SQL Server data. Because R Services (In-database) integrates the R language with SQL Server, you…


Predicting NYC Taxi Tips using MicrosoftML

MicrosoftML is a new package for Microsoft R Server that adds state-of-the-art algorithms and data transforms to Microsoft R Server functionality. MicrosoftML includes these algorithms: Fast linear learner, with support for L1 and L2 regularization. Fast boosted decision tree. Fast random forest. Logistic regression, with support for L1 and L2 regularization. GPU-accelerated Deep Neural Networks…


Leveraging Microsoft R and in database analytics of SQL Server with R Services through Alteryx Designer

This post is authored by Bharath Sankaranarayan, Principal Program Manager at Microsoft. Being part of the Microsoft R Product team I get to use Microsoft R regularly, but not often with a drag-and-drop editor that simplifies the effort needed to build a solution using machine learning. In this blog, I will take you through a…


SQL R Services optimization for concurrent execution of sp_execute_external_script

Tips and Trick for SQL R Services With SQL Server 2016, we have introduced in-database analytics by bringing R closer to the database. This allows the compute to happen closer to the data,  and also leverage the power of SQL Server including resource governance. For production scenario, our guideline includes embedding ‘R’ scripts inside sp_execute_external_script…


Integrating PolyBase with Cloudera using Active Directory Authentication

This article outlines the steps to use PolyBase in SQL 2016(including R-Services) with a Cloudera Cluster and setup authentication using Active Directory in both SQL 2016 and Cloudera. Prerequisites Cloudera Cluster Active Directory with Domain Controller SQL Server 2016 with PolyBase and R-Services installed NOTE: We have tested the configuration using the Cloudera Cluster 5.5 running on…


Exporting large data using Microsoft R (IDE: RTVS)

Introduction Very often in our projects we encounter a need to export huge amount of data (in GBs) and the conventional solution, write.csv, can test anyone’s patience with the time it demands. In this blog, we will learn by doing. We make use of a package that is not very popular, but serves the purpose…


How to use Tableau with SQL Server Machine Learning Services with R and Python

This post is co-authored by Bora Beran, Principal Product Manager at Tableau Software, Bharath Sankaranarayan, Principal Program Manager and Gil Isaacs, Senior Software Engineer from Microsoft Corporation In this post, I’ll be sharing how Tableau and SQL Server Machine Learning Services work seamlessly leveraging the power of R and Python. We like to think of…


REST Calls using PostMan for R server O16N

The Microsoft R Server operationalization REST APIs are exposed by R Server’s operationalization server, a standards-based server technology capable of scaling to meet the needs of enterprise-grade deployments. With the operationalization feature configured, the full statistics, analytics and visualization capabilities of R can now be directly leveraged inside Web, desktop and mobile applications. Core Operationalization…


Role Based Access Control With MRS 9.1.0

In the latest release of Microsoft R Server 9.1 we can configure role based access control (RBAC) for users who can publish, modify and delete the web services. There are three roles in MRS 9.1 and each role has defined set of permissions for what they can do and what they cannot do. Owner: users…


Running Pleasingly Parallel workloads using rxExecBy on Spark, SQL, Local and Localpar compute contexts

RevoScaleR function rxExec(), allows you to run arbitrary R functions in a distributed fashion, using available nodes (computers) or available cores (the maximum of which is the sum over all available nodes of the processing cores on each node). The rxExec approach exemplifies the traditional high-performance computing approach: when using rxExec, you largely control how…