Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from SQL Server 2017 Machine Learning Services with R Data exploration, modeling, and advanced analytics

Product type Paperback

Published in Feb 2018

Publisher Packt

ISBN-13 9781787283572

Length 338 pages

Edition 1st Edition

Languages

Tools

R Services

Concepts

Data Analysis

Authors (2):

Julie Koesmarno

Toma≈æ Ka≈°trun Kaštrun

View More author details

Table of Contents (12) Chapters

Preface

1. Introduction to R and SQL Server FREE CHAPTER

2. Overview of Microsoft Machine Learning Server and SQL Server

3. Managing Machine Learning Services for SQL Server 2017 and R

4. Data Exploration and Data Visualization

5. RevoScaleR Package

6. Predictive Modeling

7. Operationalizing R Code

8. Deploying, Managing, and Monitoring Database Solutions containing R Code

9. Machine Learning Services with R for DBAs

10. R and SQL Server 2016/2017 Features Extended

11. Other Books You May Enjoy

Leave a review - let other readers know what you think

Tools

There are three main options for operationalizing R code embedded in T-SQL. All of these tools are free:

SQL Server Management Studio (SSMS)
R Tools for Visual Studio (RTVS)
SQL Server Data Tools (SSDT)

This section provides an overview of how the tools can help you operationalize R code in SQL Server as part of workflows.

Using SSMS as part of operationalizing R script

SSMS is a powerful tool that allows you to operationalize your prediction analytics from the previous section. SSMS also provides the ability for you to manage various administrative tasks related to operationalizing R code in SQL Server and maintaining it, such as:

Managing permissions, as described earlier in this chapter.
Managing R packages (in...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (2)

Koesmarno

Julie Koesmarno is a senior program manager in the Database Systems Business Analytics team, at Microsoft. Currently, she leads big data analytics initiatives, driving business growth and customer success for SQL Server and Azure Data businesses. She has over 10 years of experience in data management, data warehousing, and analytics for multimillion-dollar businesses as a SQL Server developer, a system analyst, and a consultant prior to joining Microsoft. She is passionate about empowering data professionals to drive impacts for customer success and business through insights.

See other products by Koesmarno

Toma≈æ Ka≈°trun Kaštrun

Toma Katrun is a SQL Server developer and data scientist with more than 15 years of experience in the fields of business warehousing, development, ETL, database administration, and query tuning. He holds over 15 years of experience in data analysis, data mining, statistical research, and machine learning. He is a Microsoft SQL Server MVP for data platform and has been working with Microsoft SQL Server since version 2000. He is a blogger, author of many articles, a frequent speaker at the community and Microsoft events. He is an avid coffee drinker who is passionate about fixed gear bikes.

See other products by Toma≈æ Ka≈°trun Kaštrun