SQL Server Features & Components

SQH07 Machine Learning with R in Azure SQL Database

11/21/2019

1:00pm - 2:15pm

Level: Introductory to Intermediate

Bradley Ball

Sr. Azure Engineer, Azure FastTrack CXP

Microsoft

Using the power of R language to deliver advanced analytics and machine learning has been added to Azure SQL Database. While this has been in SQL Server on premise since SQL 2016, this is a new feature in a fully managed PaaS offering. In this session we will cover some basic items, how do we utilize R via T-SQL scripts? How do we list and install R packages? If we install it how do we uninstall it? Once we know the basics, we will run through some R scripts. We will then review how to operationalize these scripts. No need to have a separate service to invoke these models, we can operationalize these scripts within stored procedures so they can be called by any web service!

You will learn:

  • Understand the syntax and how to invoke R scripts in Azure SQL Database using Machine Learning services
  • Understand how to validate the version of R supported, install and uninstall R packages, and how to store models
  • Understand how to invoke models in stored procedures, against existing data sets, and single set transactions