Blog Archives

Size of XDF files using RevoScaleR package

Posted on September 22, 2016 by tomaztsql — 2 Comments

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…

Tagged with: R, R Integration, RevoScaleR, sp_execute_external_script, T-SQL
Posted in Uncategorized

Resource governor and external resource pool for Microsoft R Services

Posted on August 18, 2016 by tomaztsql — 2 Comments

Setting external resource pool for execution of R commands using sp_execute_external_script has proven extremely useful, especially in cases where you have other workers present, when you don’t want to overdo on data analysis and get to much resources from others…

Tagged with: performance, R, R Integration, resource pool, sp_execute_external_script, SQL Server
Posted in Uncategorized

Handling required and missing R packages in Microsoft R Services

Posted on August 11, 2016 by tomaztsql — 4 Comments

I have seen several times, that execution of the R code with procedure sp_execute_external_script was not valid due to missing library or library dependencies. Problem is – in general – not solved out of the box. But can be solved…

Tagged with: R, R Integration, R Packages, sp_execute_external_script, SQL Server, T-SQL
Posted in Uncategorized

Installing R packages in SQL Server using only T-SQL

Posted on August 2, 2016 by tomaztsql — 5 Comments

Installing R packages in SSMS using T-SQL can take some time, especially when you need to switch between R Tools for Visual Studio or R Studio or your favorite R GUI tool (or R CMD). But so far, installing any…

Tagged with: R, R Integration, R Packages, sp_execute_external_script, SQL Server, T-SQL
Posted in Uncategorized

Data science show at SQL Server Radio

Posted on July 22, 2016 by tomaztsql — 3 Comments

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…

Tagged with: data science, podcast, R, R Integration, SQL Server, SQL Server Radio, statistics
Posted in Uncategorized

First thoughs on R integration in SQL Server 2016

Posted on June 23, 2016 by tomaztsql — 1 Comment

This blog post is a very personal confession, might be delicate but it must be understood as a proposal or plan for improvement. Update #1: Typing error in title: correct title is First thoughts on R integration in SQL Server…

Tagged with: R, R Integration, sp_execute_external_script, SQL Server, T-SQL, thoughts
Posted in Uncategorized

	Rob Pattyn on Installing SSIS, SSRS and SSAS…
	Visual Studio 2019 a… on Installing SSIS, SSRS and SSAS…
	gopi on T-SQL date and time manip…
	Philip Noah on Using Python Pandas dataframe…
	PSIQUIATRA ASTRAL (@… on Real-time data visualization w…