Publications by tomaztsql
Using R sp_execute_external_script with JSON
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 it is gaining popularity for data exchange, I was curious to give...
1928 sym R (1359 sym/6 pcs) 8 img
Clustering executed SQL Server queries using R as tool for
When query execution performance analysis is to be done, there are many ways to find which queries might cause any unwanted load or cause stall on the server. By encouraging DBA community to start practicing the advantage or R Language and world of data science, I have created a demo to show, how statistics on numerous queries can be stored for l...
2655 sym R (6189 sym/5 pcs) 10 img
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 of three years on some dataset o...
1618 sym R (1354 sym/2 pcs) 14 img
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 -> da...
5804 sym R (1814 sym/13 pcs) 18 img
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 ...
2946 sym 16 img
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 and compare...
1883 sym R (1696 sym/7 pcs) 10 img
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...
1352 sym R (698 sym/4 pcs) 8 img
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 I said, that I hav...
5534 sym R (1124 sym/7 pcs) 18 img
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 a simp...
2062 sym R (922 sym/7 pcs) 8 img
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 [WideWorldImporters]; GO EXEC sys.sp_execute_external_script @language = N'R' ...
4129 sym R (2045 sym/6 pcs) 14 img