Skip to main content

Über dieses Buch

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.



Setup and Installation


Chapter 1. Setup and Installation of SQL Server 2016

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

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

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


Chapter 4. Building R Models with RTVS

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

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


Chapter 6. Configuring SQL Server Reporting Services

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

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

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

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



Appendix A. Installing a SQL Server 2016 Instance in a SQL Server 2014 Installation

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 (“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

This code gives the average temperature by airport ID in graphical format.
Bradley Beard


Weitere Informationen

Premium Partner

BranchenIndex Online

Die B2B-Firmensuche für Industrie und Wirtschaft: Kostenfrei in Firmenprofilen nach Lieferanten, Herstellern, Dienstleistern und Händlern recherchieren.



Best Practices für die Mitarbeiter-Partizipation in der Produktentwicklung

Unternehmen haben das Innovationspotenzial der eigenen Mitarbeiter auch außerhalb der F&E-Abteilung erkannt. Viele Initiativen zur Partizipation scheitern in der Praxis jedoch häufig. Lesen Sie hier  - basierend auf einer qualitativ-explorativen Expertenstudie - mehr über die wesentlichen Problemfelder der mitarbeiterzentrierten Produktentwicklung und profitieren Sie von konkreten Handlungsempfehlungen aus der Praxis.
Jetzt gratis downloaden!