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