Skip to content
Get started with Predictive Modeling using R and SQL Server Machine Learning Services
Branch: master
Clone or download
Latest commit 78a6f6c May 2, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
PredictiveModelingUsingMLS.sql Add files via upload Apr 28, 2019
PredictiveModelingUsingR.r Add files via upload Apr 28, 2019
PredictiveModelingUsingSQLServerMachineLearningServices.pptx PPT minor changes May 2, 2019
README.md Update README.md Apr 28, 2019
heart-disease.data
heart-disease.names Add files via upload Apr 28, 2019

README.md

PredictiveModelingUsingRandSQLServerMLS


Get started with Predictive Modeling using R and SQL Server Machine Learning Services

In 2017, Microsoft introduced SQL Server Machine Learning Services letting us run R or Python scripts in SQL Server, and providing easy access to Machine Learning on premises.

This sample was created to demo SQL Server MLS in the QLD SQL Server User Group meet on 1st May, 2019 https://www.meetup.com/QLD-SQL-Server-User-Group/events/260102809/

The session was focused on getting familiar with SQL Server Machine Learning Services. After going over its components and features, the host demoed building a Predictive Model using R and SQL Server Machine Learning Services.

#About the Presenter

Arjun Sivadasan - http://www.sqlroadie.com

After starting his career as a .NET programmer in 2007, Arjun soon got addicted to working with data after inadvertently solving a performance problem in a team meeting. Having worn multiple hats over his career as a Database Developer, DBA and Data Team Lead, he currently leads the Data team at Minor Hotels ANZ. Arjun is excited about innovations happening in the data space, and is focused on solving business problems through performant data solutions and fostering a culture of data-driven decision making.

#Demo

#Files

heart-disease.data - UCI dataset attached for reference heart-disease.names - Data description. Go through this file to understand what the variables mean

PredictiveModelingUsingR.r - R script (with comments wherever applicable) that builds the predictive Model using RevoScaleR package. Go through this to understand how the models are created and used for prediction.

PredictiveModelingUsingMLS.sql - SQL script that uses R code covered in the previous file to build a Machine Learning predictive model that is executed in the SQL on premises instance

PS: You may use this code sample as you wish. Remember that a little knowledge is often a dangerous thing:)

You can’t perform that action at this time.