Articles by tomaztsql

Using R in SQL Server Reporting Services (SSRS)

March 4, 2018 | tomaztsql

SQL Server Reporting services (SSRS) is an outstanding tool for creating, deploying and managing paginated, mobile, KPI reports as well as Power BI reports. Tool provides simple way to share and get data insights in your corporate environment. (Photo source: Microsoft docs) Using the privileges of R language to enrich ...
[Read more...]

R or Python? Python or R? The ongoing debate.

January 28, 2018 | tomaztsql

On every SQL community event, where there could be a cluster of sessions dedicated to BI or analytics, I would have people asking me, “which one would you recommend?” or “which one I  prefer?” So, questions about recommendation and preferences are in my opinion the hardest one. And not that ...
[Read more...]

Robust IRIS Dataset?

October 25, 2017 | tomaztsql

This blog post was born out of pure curiosity about the robustness of the IRIS Dataset. Biological datasets do not need to be that big in comparison to datasets of customers, consumption, stock and anything that might be volatile. When still at the university, on one occasion I can remember, ...
[Read more...]

Passing two SQL queries to sp_execute_external_script

July 25, 2017 | tomaztsql

Recently, I got a question on one of my previous blog posts, if there is possibility to pass two queries in same run-time as an argument to external procedure sp_execute_external_script. Some of the  arguments of the procedure sp_execute_external_script are enumerated. This is valid for ...
[Read more...]

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...]
1 2 3

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)