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.

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.

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.

[…] 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. […]

[…] 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. […]

[…] 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. […]

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

100% of donations made here go to charity, no deductions, no fees. For CLOWNDOCTORS - encouraging more joy and happiness to children staying in hospitals (http://www.rednoses.eu/red-noses-organisations/slovenia/)