Articles by tomaztsql

Saving input and output with sp_execute_external_script

April 10, 2017 | tomaztsql

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 [WideWorldImporters]; GO EXEC ...
[Read more...]

Linear regression in “The Man who counted”

March 25, 2017 | tomaztsql

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“...
[Read more...]

Is it possible to use RevoScaleR package in Power BI?

March 20, 2017 | tomaztsql

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 ...
[Read more...]

rxNeuralNet vs. xgBoost vs. H2O

February 20, 2017 | tomaztsql

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 ...
[Read more...]

R and SQL Server articles

February 8, 2017 | tomaztsql

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) ...
[Read more...]

RevoScaleR package for Microsoft R

February 3, 2017 | tomaztsql

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 ...
[Read more...]

Animated barplot and google map with R

January 13, 2017 | tomaztsql

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 ...
[Read more...]

Using R sp_execute_external_script with JSON

January 8, 2017 | tomaztsql

JSON has become part of the SQL Server in the same version as R. Both were very highly anticipated and awaited from the community. JSON has very powerful statements for converting to and from JSON for storing into / from SQL Server engine (FOR JSON and JSON VALUE, etc).  And since ...
[Read more...]

R graphs and tables in Power BI Desktop

December 18, 2016 | tomaztsql

Power BI Desktop enable users to use R script visual for adding custom visualization generated with R language – regardless of R package used. Before using R script visual, you will need to enable it by setting path to R Engine on your client in the global options. Once this is ...
[Read more...]

FileTable and storing graphs from Microsoft R Server

September 25, 2016 | tomaztsql

FileTable has been around now for quite some time and and it is useful  for storing files, documents, pictures and and binary files in a designated SQL Server table – FileTable. The best part of FileTable is the fact one can access it from windows or other application as if it ...
[Read more...]

Size of XDF files using RevoScaleR package

September 22, 2016 | tomaztsql

It came to my attention that size of XDF (external data frame) file can change drastically based on the compute context and environment. When testing the output of a dataset I was working on in SQL Server Management Studio I was simultaneously testing R code in RTVS or  R Studio ...
[Read more...]
1 5 6 7 8

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)