Book Overview & Buying
Table Of Contents

SQL Server 2017 Machine Learning Services with R

By : Toma≈æ Ka≈°trun Kaštrun, Koesmarno

4.3 (8)

Buy this Book

SQL Server 2017 Machine Learning Services with R

4.3 (8)

By: Toma≈æ Ka≈°trun Kaštrun, Koesmarno

Buy this Book

Overview of this book

R Services was one of the most anticipated features in SQL Server 2016, improved significantly and rebranded as SQL Server 2017 Machine Learning Services. Prior to SQL Server 2016, many developers and data scientists were already using R to connect to SQL Server in siloed environments that left a lot to be desired, in order to do additional data analysis, superseding SSAS Data Mining or additional CLR programming functions. With R integrated within SQL Server 2017, these developers and data scientists can now benefit from its integrated, effective, efficient, and more streamlined analytics environment. This book gives you foundational knowledge and insights to help you understand SQL Server 2017 Machine Learning Services with R. First and foremost, the book provides practical examples on how to implement, use, and understand SQL Server and R integration in corporate environments, and also provides explanations and underlying motivations. It covers installing Machine Learning Services;maintaining, deploying, and managing code;and monitoring your services. Delving more deeply into predictive modeling and the RevoScaleR package, this book also provides insights into operationalizing code and exploring and visualizing data. To complete the journey, this book covers the new features in SQL Server 2017 and how they are compatible with R, amplifying their combined power.

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

Introduction to R and SQL Server

Using R prior to SQL Server 2016

Microsoft's commitment to the open source R language

Boosting analytics with SQL Server R integration

Summary

Overview of Microsoft Machine Learning Server and SQL Server

Analytical barriers

The Microsoft Machine learning R Server platform

The Microsoft Machine Learning R Services architecture

Summary

Managing Machine Learning Services for SQL Server 2017 and R

Minimum requirements

Choosing the edition

Configuring the environment and installing R Tools for Visual Studio (RTVS)

Security

Package information

Summary

Data Exploration and Data Visualization

Understanding SQL and R data types

Data exploration and data munging

Data visualization in R

Integrating R code in reports and visualizations

Summary

RevoScaleR Package

Overcomming R language limitations

Scalable and distributive computational environments

Functions for data preparation

Variable creation and data transformation

Variable creation and recoding

Dataset subsetting

Dataset merging

Functions for descriptive statistics

Functions for statistical tests and sampling

Summary

Predictive Modeling

Data modeling

Advanced predictive algorithms and analytics

Deploying and using predictive solutions

Performing predictions with R Services in the SQL Server database

Summary

Operationalizing R Code

Integrating an existing R model

Fast batch prediction

Integrating the R model for fast batch prediction

Managing roles and permissions for workloads

Tools

Integrating R workloads and prediction operations beyond SQL Server

Summary

Deploying, Managing, and Monitoring Database Solutions containing R Code

Integrating R into the SQL Server Database lifecycle workflow

Prerequisites for this chapter

Using version control

Setting up continuous integration

Setting up continuous delivery

Monitoring the accuracy of the productionized model

Summary

Machine Learning Services with R for DBAs

Gathering relevant data

Exploring and analyzing data

Creating a baseline and workloads, and replaying

Creating predictions with R - disk usage

Summary

R and SQL Server 2016/2017 Features Extended

Built-in JSON capabilities

Accessing external data sources using PolyBase

High performance using ColumnStore and in memory OLTP

Summary

Other Books You May Enjoy

Leave a review - let other readers know what you think

Other Books You May Enjoy

If you enjoyed this book, you may be interested in these other books by Packt:

SQL Server 2017 Administrator's Guide
Marek Chmel, Vladimír Mužný

ISBN: 978-1-78646-254-1

Learn about the new features of SQL Server 2017 and how to implement them
Build a stable and fast SQL Server environment
Fix performance issues by optimizing queries and making use of indexes
Perform a health check of an existing troublesome database environment
Design and use an optimal database management strategy
Implement efficient backup and recovery techniques in-line with security policies
Combine SQL Server 2017 and Azure and manage your solution by various
automation techniques Perform data migration, cluster upgradation and server consolidation

SQL Server 2017 Integration Services Cookbook

Christian Cote, Matija Lah, Dejan Sarka

ISBN: 978-1-78646-182...

Tech Concepts

Programming languages

Tech Tools