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

Prerequisites for this chapter

Tools	URL	Notes
Visual Studio 2017	To download: https://www.visualstudio.com/downloads/	The Community Edition is free.
VSTS	Sign up/sign in: https://www.visualstudio.com/team-services/	Sign up for the personal account for free.
Power Shell v2.0 or above	Download PowerShell: https://www.microsoft.com/en-us/download/details.aspx?id=42554	You will need this for setting up the Private Agent locally.

Creating the SQL Server database project

In this section, we will walk you through how to create a database project in VS2017.

In VS2017, click on File | New Project.
Choose SQL Server from Installed on the left pane and click on the SQL Server Database Project template...

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 €18.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