Skip to main content
Disciplines
Automotive Business IT + Informatics Construction + Real Estate Electrical Engineering + Electronics Energy + Sustainability Insurance + Risk Finance + Banking Management + Leadership Marketing + Sales Mechanical Engineering + Materials
Events
DE
EN
Books
Journals
Topic Page
Marketing
Start single access now
Access for companies
EXTENDED SEARCH
Log in
Top

2016 | Book

Setup and Installation of SQL Server 2016 Read chapter Read first chapter

Beginning SQL Server R Services

Analytics for Data Scientists

Author: Bradley Beard

Publisher: Apress

Part of: Springer Professional "Wirtschaft+Technik" , Springer Professional "Technik" , Springer Professional "Wirtschaft"

Login to get access
insite
SEARCH

About this book

Learn how to develop powerful data analytics applications quickly for SQL Server database administrators and developers. Organizations will be able to sift data and derive the business intelligence needed to drive business decisions and profit. The addition of R to SQL Server 2016 places a powerful analytical processor into an environment most developers are already comfortable with – Visual Studio. This book walks even the newest of users through the creation process of a powerful R-language tool set for use in analyzing and reporting on your data.

As a SQL Server database administrator or developer, it is sometimes difficult to stay on the bleeding edge of technology. Microsoft’s addition of R to SQL Server 2016 is sure to be a game-changer, and the language will certainly become an integral part of future releases. R is in fact widely used today in statistical and related applications, and its use is only growing. Beginning SQL Server R Serviceshelps you jump on board this important trend by providing good examples with detailed explanations of the WHY and not just the HOW.

Walks you through setup and installation of SQL Server R Services.Explains the basics of working with R Tools for Visual Studio.Provides a road map to successfully creating custom R code.What You Will LearnDiscover R’s role in the SQL Server 2016 hierarchy.Manage the components needed to run SQL Server R Services code.Run R-language analytics and queries inside the database.Create analytic solutions that run across multiple datasets.Gain in-depth knowledge of the R language itself.Implement custom SQL Server R Services solutions.

Who This Book Is For

Beginning SQL Server R Services is for any level of database administrator or developer, but specifically it's for those developers with the need to develop powerful data analytics applications quickly. Seasoned R developers will appreciate the book for its robust learning pattern, using visual aids in combination with properties explanations and scenarios. Beginning SQL Server R Services is the perfect “new hire” gift for new database developers in any organization.

Table of Contents

Frontmatter

Setup and Installation

Frontmatter
Chapter 1. Setup and Installation of SQL Server 2016
Abstract
One of the major updates to SQL Server 2016 is the addition of R as an integral part of the database engine. R began in 1993 as a data analysis language developed by Robert Gentleman and Ross Ihaka at the University of Auckland. It started as a language that could rival the S language in statistical analysis and evolved into arguably the most popular language in the world for statistical computing, data analysis, and machine learning.
Bradley Beard
Chapter 2. Setup and Installation of R Tools for Visual Studio
Abstract
Now that we’ve got SQL Server 2016 installed correctly, we need to have some sort of IDE to develop our code in. Microsoft has made Visual Studio 2015 even better by introducing a brand-new R GUI as part of Visual Studio. This is simply named R Tools for Visual Studio.
Bradley Beard
Chapter 3. Project Scenario Definition
Abstract
Before we get started with this chapter, I want to take a second and explain that this chapter deals with the program management side of development, and not the actual development side. Sometimes, dealing with the management side can be perhaps the most frustrating part of your job, but it is still necessary. For those that don’t have a lot of experience in this area, I included this chapter. Hopefully, it will help you to understand how essential it is to have a plan moving forward in your next project.
Bradley Beard

Learning the Basics

Frontmatter
Chapter 4. Building R Models with RTVS
Abstract
In this chapter, we actually build the models in R and then display the information contained within that model in a series of charts. The charts become progressively more advanced until we reach the final culmination of the data visualization.
Bradley Beard
Chapter 5. Plotting in RTVS
Abstract
We are far enough along to understand some basics and we are now going to expound on that knowledge by pressing forward, while still recognizing that we are crawling and not yet walking.
Bradley Beard

Creating and Viewing Reports

Frontmatter
Chapter 6. Configuring SQL Server Reporting Services
Abstract
The purpose of this chapter is to familiarize you with the options available within Reporting Services Configuration Manager, so that if you need to change a setting in your own installation, you have the knowledge and confidence of how to make the required change and where to look for the solution.
Bradley Beard
Chapter 7. Report Builder Installation and Data Preparation
Abstract
Now that we have SQL Server Reporting Services installed, we need to figure out how to create and deliver the reports requested by the customer in our software requirements document. Probably the best way to create the reports is using Report Builder, a free download from Microsoft.
Bradley Beard
Chapter 8. Building Reports Using Report Builder
Abstract
Up until now, we’ve dealt with an awful lot of information in this book. We’ve performed a new installation of SQL Server R Services, installed R Tools for Visual Studio, configured Reporting Services, and installed and configured Report Builder. We learned quite a bit about R and how it works and we generally got a lot of experience with writing code in general. If you have gotten this far, nice work! This is really sort of advanced stuff, since it’s basically brand-new functionality. It’s pretty safe to assume that R will continue to be offered as part of SQL Server for future releases, so it’s best to go ahead and get acquainted with it now instead of having to deal with the learning curve later.
Bradley Beard
Chapter 9. Viewing the Reports in Report Server
Abstract
Now that we have built the required reports in Report Builder, we can view them through the report server web portal. Later in this chapter, we get into other aspects of Report Server, but for now, let’s take a look at our reports.
Bradley Beard

Appendices

Frontmatter
Appendix A. Installing a SQL Server 2016 Instance in a SQL Server 2014 Installation
Abstract
In this chapter, we actually build the models in R and then display the information contained within that model in a series of charts. The charts become progressively more advanced until we reach the final culmination of the data visualization.
Bradley Beard
Appendix B. Software Requirements Document
Abstract
PleaseGiveUs-R-AnalysisData.com (“Customer”) has approached We R Pros, LLC (“Vendor”) with a unique request.
Bradley Beard
Appendix C. R Plot and Tabular Code for R Tools for Visual Studio
Abstract
This code gives the average temperature by airport ID in graphical format.
Bradley Beard
Backmatter
Metadata
Title
Beginning SQL Server R Services
Author
Bradley Beard
Copyright Year
2016
Publisher
Apress
Electronic ISBN
978-1-4842-2298-0
Print ISBN
978-1-4842-2297-3
DOI
https://doi.org/10.1007/978-1-4842-2298-0

Premium Partner

    Image Credits