Publications by tomaztsql
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 sharing this w...
4195 sym R (4020 sym/12 pcs) 12 img
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 the diffe...
3889 sym R (7243 sym/14 pcs) 10 img
Installing R packages with rxInstallPackages in Microsoft R Server
In MicrosoftML package comes – in my opinion – long anticipated function for installing R packages for SQL Server and Microsoft R Server. And, I am super happy. Last year, in one of my previous blog posts, I have been showing how to install R package from SSMS using sp_execute_external_script. Now, with new package MicrosoftML (that is part o...
1572 sym R (417 sym/1 pcs) 4 img
Passing two SQL queries to sp_execute_external_script
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 the inputting dataset and as the name of argument @input_da...
2518 sym R (1779 sym/5 pcs) 8 img
Robust IRIS Dataset?
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, we were measuring the length of the frog ...
2641 sym R (921 sym/4 pcs) 11 img
SQL Saturday statistics – Web Scraping with R and SQL Server
I wanted to check a simple query: How many times has a particular topic been presented and from how many different presenters. Sounds interesting, tackling the problem should not be a problem, just that the end numbers may vary, since there will be some text analysis included. First of all, some web scraping and getting the information from Sqlsa...
2734 sym R (2601 sym/4 pcs) 14 img
R or Python? Python or R? The ongoing debate.
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 I would know my preferences but because you ar...
5391 sym 2 img
Using R in SQL Server Reporting Services (SSRS)
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 your data, your statistical...
4155 sym R (1660 sym/5 pcs) 20 img
Native scoring in SQL Server 2017 using R
Native scoring is a much overlooked feature in SQL Server 2017 (available only under Windows and only on-prem), that provides scoring and predicting in pre-build and stored machine learning models in near real-time. �...
5629 sym R (3044 sym/5 pcs) 10 img
R null values: NULL, NA, NaN, Inf
R language supports several null-able values and it is relatively important to understand how these values behave, when making data pre-processing and data munging. In general, R supports: NULL NA NaN Inf / -Inf NULL is an object and is returned when an expression or function results in an undefined value. In R language, NULL (capital letters) ...
6148 sym R (3478 sym/18 pcs) 8 img