Microsoft Gives SQL Server R Analytics a Machine-Learning Push
New machine-learning templates help give SQL Server 2016 customers a get a head start with advanced analytics applications based on the R language.SQL Server 2016 features new services to enable advanced, in-database analytics. Dubbed SQL Server R Services, they integrate the popular open-source R statistical computing language used by data scientists for predictive modeling. To familiarize enterprises with the technology's potential and help them get started on developing their own analytics applications, Microsoft has released three machine-learning templates for SQL Server R Services: Online Fraud Detection, Customer Churn Prediction and Predictive Maintenance. They are available in the Cortana Analytics Gallery and include R code, sample data and SQL stored procedure code. Over a year ago, Microsoft made a splash when it announced it was acquiring Revolution Analytics, the Mountain View, Calif.-based leading commercial provider of R software and services. Upon the deal's completion, Microsoft revealed that it was baking R into SQL Server to enable in-database analytics services across the database software's on-premises, Azure and hybrid-cloud implementations. Today, customers can test-drive the tech in scenarios that affect many enterprises.
"These templates are sample advanced analytics solutions that demonstrate best practices and provide building blocks to help users implement a solution quickly," said Xinwei Xue, senior data scientist manager, in a March 23 announcement. "Each template is designed to solve a specific problem, and includes sample data, R code (which uses the highly scalable Microsoft R Server ScaleR APIs) and SQL stored procedure code that extends from data preparation and feature engineering to model training and scoring."