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.
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.
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.
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.
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.
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.
Link to article: http://www.sqlservercentral.com/articles/R+Language/151405/
More articles will follow, so stick around.
Happy R-SQLing!
[…] Tomas Kastrun links to a series of his published articles on working with SQL Server and R: […]
LikeLike
[…] article was first published on R – TomazTsql, and kindly contributed to […]
LikeLike
[…] 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. […]
LikeLike
[…] Tomaž Kaštrun is developer and data analyst working for the IT group at SPAR (the ubiquitous European chain of convenience stores) in Austria. He blogs regularly about using Microsoft R and SQL Server for data analyis, and recently published a roundup of his articles about R and SQL Server. […]
LikeLike
[…] Tomaž Kaštrun is developer and data analyst working for the IT group at SPAR (the ubiquitous European chain of convenience stores) in Austria. He blogs regularly about using Microsoft R and SQL Server for data analyis, and recently published a roundup of his articles about R and SQL Server. […]
LikeLike
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
LikeLike
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
LikeLike