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…
TomazTsql
Tomaz doing BI and DEV with SQL Server and R
Blog Archives
Size of XDF files using RevoScaleR package
Tagged with: R, R Integration, RevoScaleR, sp_execute_external_script, T-SQL
Posted in Uncategorized
Posted in Uncategorized
Resource governor and external resource pool for Microsoft R Services
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
Posted in Uncategorized
Handling required and missing R packages in Microsoft R Services
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
Posted in Uncategorized
Installing R packages in SQL Server using only T-SQL
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
Posted in Uncategorized
Data science show at SQL Server Radio
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
Posted in Uncategorized
First thoughs on R integration in SQL Server 2016
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
Posted in Uncategorized
| R graphs and tables… on R graphs and tables in Power B… | |
 | SQL Server 2017 Mach… on SQL Server 2017 Machine Learni… |
| SQL Server 2017 Mach… on SQL Server 2017 Machine Learni… | |
| AI, Machine Learning… on Using Python Pandas dataframe… | |
| AI, Machine Learning… on Using Python Pandas dataframe… |
