Blog Archives

Performance differences between RevoScaleR, ColumnStore Table and In-Memory OLTP Table

April 28, 2017
By
Performance differences between RevoScaleR, ColumnStore Table and In-Memory OLTP Table

Running *.XDF files using RevoScaleR computational functions versus have dataset available in Columnstore table or in In-Memory OLTP table will be focus of comparison for this blog post. For this test, I will use the AirLines dataset, available here. Deliberately, I have picked a sample 200 MB (of 13GB dataset) in order to properly test … Continue...

Read more »

Saving input and output with sp_execute_external_script using temporal table and file table (part #2)

April 17, 2017
By
Saving input and output with sp_execute_external_script  using temporal table and file table (part #2)

In my previous blog post, Saving input and output with sp_execute_external_script, I was exploring the possibilities how to capture the R code that external procedure sends it internally to the Launchpad.exe program.  And a blog comment by reader Bob gave me additional push to write the second part to same topic. Thank you Bob for … Continue...

Read more »

Saving input and output with sp_execute_external_script

April 10, 2017
By
Saving input and output with sp_execute_external_script

Again I was at the point, where I needed to store and save to external file all the R code that was executed through sp_execute_external_script. Soon, you will find out several interesting things. To show the example, I will start with following example: USE ; GO EXEC sys.sp_execute_external_script      @language = N'R'     ,@script … Continue...

Read more »

Linear regression in “The Man who counted”

March 25, 2017
By
Linear regression in “The Man who counted”

Recently, I got a book by Brasilian writer  Júlio César de Mello e Souza (published under pen name Malba Tahan), titled The Man who counted. Book is a collection of mathematical stories very similar to Scheherazada’s 1001 Nights, where mathematical story-telling is the center of book.                                                In story 5“In so many words”, Malba describes … Continue...

Read more »

Is it possible to use RevoScaleR package in Power BI?

March 20, 2017
By
Is it possible to use RevoScaleR package in Power BI?

I was invited to deliver a session for Belgium User Group on SQL Server and R integration. After the session – which we did online using web based Citrix  – I got an interesting question: “Is it possible to use RevoScaleR performance computational functions within Power BI?“. My first answer was,  a sceptical yes. But … Continue...

Read more »

RevoScaleR package dependencies with graph visualization

March 15, 2017
By
RevoScaleR package dependencies  with graph visualization

MRAN currently holds 7520 R Packages. We can see this with usage of following command (stipulating that you are using MRAN R version. ): library(tools) df_ap <- data.frame(available.packages()) head(df_ap) With importing package tools, we get many useful functions to find additional information on packages. Function package.dependencies() parses and check dependencies of a package in current … Continue...

Read more »

rxNeuralNet vs. xgBoost vs. H2O

February 20, 2017
By
rxNeuralNet vs. xgBoost vs. H2O

Recently, I did a session at local user group in Ljubljana, Slovenija, where I introduced the new algorithms that are available with MicrosoftML package for Microsoft R Server 9.0.3. For dataset, I have used two from (still currently) running sessions from Kaggle. In the last part, I did image detection and prediction of MNIST dataset … Continue...

Read more »

R and SQL Server articles

February 8, 2017
By
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 … Continue...

Read more »

RevoScaleR package for Microsoft R

February 3, 2017
By
RevoScaleR package for Microsoft R

RevoscaleR Package for R language is  package for scalable, distributed and parallel computation, available along with Microsoft R Server (and in-Database R Services). It solves many of limitations that R language is facing when run from a client machine. RevoScaleR Package addresses several of these issues: memory based data access model -> dataset can be … Continue...

Read more »

Animated barplot and google map with R

January 13, 2017
By
Animated barplot and google map with R

It might happen that you will need a animated graph of any kind. For purposes of plotting demographic data and changes through the years, Google Maps and plotting maps, merging and converting jpg files into a animated gif, sure will give a nice visualization effect. Here is a sample of changes over the time period … Continue...

Read more »

Sponsors

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)