Free e-book: Data Science with SQL Server 2016

October 28, 2016

(This article was first published on Revolutions, and kindly contributed to R-bloggers)

There's 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.)

To leave a comment for the author, please follow the link and comment on their blog: Revolutions. offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...

If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.

Search R-bloggers


Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)