Free e-book: Data Science with SQL Server 2016


Data science book cover
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 process

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.)