Articles by tomaztsql

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

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 4 5 6

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)