Basics of R and Python Execution in SQL Server

In a previous post, we talked about how to set up Machine Learning Services in SQL Server. Now I will cover the basics of how to Execute R and Python in T-SQL statements. The video below will help you understand the basic syntax, parameter names, and data types used. I also summarized the key steps…

0

Getting Started with Machine Learning Services in SQL Server

I would like to introduce you to some simple videos that will help you get started with Machine Learning Services in SQL Server. The videos below cover how to install and enable Machine Learning Services. After completing the instructions found here, you will be ready to execute R and Python in SQL Server. I summarized…

0

On-Prem or On the Cloud

Learn more about SQL Server Machine Learning Services in the Azure AI Gallery If you store your data in SQL Server 2016 or above, you should know about SQL Server Machine Learning Services (ML Services). Instead of moving data out of SQL to perform analytics, ML Services allows you to move the analytics (in R…

0

Running MicrosoftML in SQL Server 2016

MicrosoftML is the new and exciting ML packages added to Microsoft R Server 9.0.1 which offers increased speed, performance and scalability, especially for scenarios like deep neural network with GPU acceleration and highly-dimensional categorical data. There has been some confusions on where to download MicrosoftML to get your hands on algorithms like rxFastLiner, rxFastTress and rxNeuralNet,…


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…


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…


Joseph Sirosh’s Keynote on 1 Million Predictions Per Second

We are thrilled to announce Joseph Sirosh, Corporate Vice President of Data Group at Microsoft will be presenting a demo at Microsoft Machine Learning & Data Science Summit on using online transaction processing (OLTP) database in SQL Server 2016 and latest algorithms in R service to predict a million events per second. As the number…


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…