There's a new e-book available to download free from Microsoft Academy: Data Science with Microsoft SQL Server 2016.
This 90-page e-book is aimed at data scientists who already have some experience in R, but want to learn how to use R wirth SQL Server. The book was written by some of my most experienced colleagues from Microsoft's data science team at Microsoft: Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, and Wee-Hyong Tok, and begins with an introduction by Joseph Sirosh. It includes everything you need to know to use R and SQL Server:
- How to install and configure your data science tool-set: SQL Server 2016, Microsoft R Client, RStudio/RTVS, etc.
- How to download data from SQL Server into a local R client
- How to create and update tables in SQL Server from R
- Use a remote SQL Server instance as an R compute engine, driven from your local R client
- Write SQL Server stored procedures that run R code on the server, and how to share them with others.
(If you're new to R or data science, there are also links to learning resources in Chapter 1.) The book also includes several fully-worked examples following the data science process, with links to data and code so you can try them out yourself:
- Creating a model to predict whether a tip is given for a taxi ride in New York City
- Building a customer churn model to find customers likely to switch to a competing service provider
- Analyzing "Internet of Things" data as part of a predictive maintenenance program
Data Science with Microsoft SQL Server 2016 is available now as a download from Microsoft Academy. (Desktop and mobile PDF formats available. Free registration required.)