R and SQL Server articles

In past couple of months, I have prepared several articles on R and SQL Server that have been published on SQL Server Central.

The idea was, to have couple of articles covering the introduction to R, to basics on R Server, to some practical cases on R with SQL Server.

1) Using Microsoft R in Enterprise Environments

Article covers the concepts on Microsoft R Server, where and how to start with Microsoft R in enterprise environment and give answers to most common concerns people might have when introducing R language into corporation.

1

Link to article: http://www.sqlservercentral.com/articles/R+Language/140422/

 

2) Introduction to Microsoft R Services in SQL Server 2016

Integration and architecture on Microsoft R Services is main focus of this article. It outlinesdifferent flavors of R (Open, Client, Server, Services, Hadoop, etc.), how to deal with installation and basic overview and explanation on extended stored procedure SP_EXECUTE_EXTERNAL_SCRIPT.

2.png

Link to article: http://www.sqlservercentral.com/articles/Microsoft/145393/

 

3) Installing R packages in SQL Server R Services

Expand the functionality of R by adding new packages. Covers many ways how to install and add additional packages to your R environment.

3

Link to article: http://www.sqlservercentral.com/articles/R+Package/145571/

 

4) Using SQL Server and R Services for analyzing Sales data

Providing use cases on analyzing sales data was focus of this article with goal to show readers and users how to ope rationalize and bring R code into use in any enterprise (small or big) environment.

4

Link to article: http://www.sqlservercentral.com/articles/R+Services/145649/

 

5) Using Power BI and SSRS for visualizing SQL Server and R data

Visualizing the data for any use case, is also important aspect of understanding data insights. Article covers Power BI and SSRS visualization and how to embed R code in both tools.

5

Link to article: http://www.sqlservercentral.com/articles/R+Language/151358/

6) Using SQL Server and R Services for analyzing DBA Tasks

Broadening the use of Microsoft R for the DBA tasks was the main goal of this article. With simulation of  the disk usage, showing R example how to switch from monitoring the usage to predicting the usage of disk space. Clustering executed queries to narrow down performance issues and visualizing Query store information with heatmap were also introduced in article.

6

Link to article: http://www.sqlservercentral.com/articles/R+Language/151405/

 

More articles will follow, so stick around.

Happy R-SQLing!

 

 

Advertisements

7 thoughts on “R and SQL Server articles

  1. […] R and SQL Server articles In past couple of months, I have prepared several articles on R and SQL Server that have been published on SQL Server Central. The idea was, to have couple of articles covering the introduction to R, to basics on R Server, to some practical cases on R with SQL Server. […]

    Like

  2. Here’s a reply with a 1 year delay 😉
    AS a SQLServer R user, recently I’ve been curious about in-database services update.
    I see my in-database R version is stuck at 3.2.2, with a 8.0.0 Revolution packages version – the RTM SQL2016 version. As some R packages I use have evolved since R 3.2.2 and I would feel more comfortable with a more recent R version, I decided to test the in-database upgrading via SQL Server Service pack and Cumulative Updates.
    After updating, I was surprised to find out that in-database R was not updated at all, and still at 3.2.2 – 8.0.0.
    So I decided to test the “binding” functionality, being aware that it comes with Enterprise license. Everything worked, and I was able to get a 3.3.3 R (maybe a newer one, I don’t remember). The most surprising thing is that, when I “unbinded” my in-database R (as we usually don’t work with Enterprise license), the whole in-database installation was removed!!!
    So actually the question is: can I update in-database R, or should I adapt to an older version and modify my way to work?
    Thanks!!
    Paolo

    Like

    • Hi Paolo.
      Very good question and I hope you dont mind, I will write a blog ppst about that. And will stick and try to answer as much of the open questions as possible.

      Best, Tomaz

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s