Articles by tomaztsql

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...]

Using parameter and multiparameters with sp_execute_external_script

August 1, 2016 | tomaztsql

With RTM version of SQL Server 2016, sp_execute_external_script stored procedure has undergone couple of changes prior to it’s final outlook. The parametrization of this external procedure somehow resembles a typical extended stored procedure. Indeed, sp_execute_external_script is an extended stored procedure written using CLR (whereas ...
[Read more...]

Data science show at SQL Server Radio

July 22, 2016 | tomaztsql

SQL Server Radio with Matan Yungman (info | twitter| company ) and Guy Glantser (info | twitter | company ) was hosting me for SQL Server radio 52th series. Main topic was discussion on  data science, statistics, who data scientist is and what SQL Server offers with R integration, SSRS, PowerBI, Excel and other tools. […]
[Read more...]

Effect of normalization of data

April 26, 2016 | tomaztsql

Clustering (distributed in particular) can  be dependent on normalization of data. With usage of distance models, data – when clustered – can produce different results or even different clustering models. A simple every day example can produce two different results. For example, measuring units.  For this purpose we will create two R ...
[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)