Monthly Archives: June 2016

Running multiple correlations with R and T-SQL

Getting to know the data is always an interesting part of data science. With R integration into SQL Server, the exploration part is still part of the game. Usual way to get some statistics out of the dataset is to

Tagged with: , , , , , ,
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: , , , , ,
Posted in Uncategorized

Case sensitive R in sp_execute_external_script

R Language is case sensitive! Any R-coder can tell you this and share the experience. Case sensitive in R can be a challenge as with any case sensitive language. This also applies to SP_EXECUTE_EXTERNAL_SCRIPT stored procedure in T-SQL. This is

Tagged with: , ,
Posted in Uncategorized

Passing T-SQL select statement to sp_execute_external_script

Passing T-SQL Statement to sp_execute_external_script has couple of limitations which are not mentioned on MSDN or on known issues list. Or I haven’t seen it yet on MSDN. So in this blog post I will discuss what are the limitations

Posted in Uncategorized

Importing CSV data using T-SQL and R

Several ways exists to import CSV (excel) data into your SQL Server Database. One is of course, using SSIS. The other one – similar to SSIS – is using import/export function in SSMS. With wizard, you will be able to

Tagged with: , , , ,
Posted in Uncategorized

Find installed R packages on your Microsoft R Server

Want to find out what R libraries you have available in your SQL Server 2016 environment? Run the following scripts to find out how many R Libraries you have available for your R Server in SSMS: EXECUTE sp_execute_external_script       

Posted in Uncategorized

Data types: R and SQL Server – get NVARCHAR working

I like data types. Data type is an attribute that specifies what kind of data the object can hold. And object can be from variable, to column, to table, expression, etc. By defining the allowed data for objects, this inadvertently

Posted in Uncategorized
Follow TomazTsql on
Programs I Use
Programs I Use
Programs I Use
Rdeči Noski – Charity

Rdeči noski

100% of donations made here go to charity, no deductions, no fees. For CLOWNDOCTORS - encouraging more joy and happiness to children staying in hospitals (


Top SQL Server Bloggers 2018

A daily selection of the best content published on WordPress, collected for you by humans who love to read.


Tomaz doing BI and DEV with SQL Server and R, Python and beyond

attaining enlightenment with sql server, .net, biztalk, windows and linux

SQL DBA with A Beard

He's a SQL DBA and he has a beard

Reeves Smith's SQL & BI Blog

A blog about SQL Server and the Microsoft Business Intelligence stack with some random Non-Microsoft tools thrown in for good measure.

SQL Server

for Application Developers

Clocksmith Games

We make games we love to play

Business Analytics 3.0

Data Driven Business Models

SQL Database Engine Blog

Tomaz doing BI and DEV with SQL Server and R, Python and beyond

Search Msdn

Tomaz doing BI and DEV with SQL Server and R, Python and beyond


Tomaz doing BI and DEV with SQL Server and R, Python and beyond

Ms SQL Girl

Julie Koesmarno's Journey In Data, BI and SQL World


R news and tutorials contributed by (750) R bloggers

Data Until I Die!

Data for Life :)

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

Grant Fritchey

Intimidating Databases and Code

Madhivanan's SQL blog

A modern business theme

Alessandro Alpi's Blog

SQL Server, Azure and .net in a nutshell :D

Paul te Braak

Business Intelligence Blog

Sql Server Insane Asylum (A Blog by Pat Wright)

Information about SQL Server from the Asylum.

Gareth's Blog

A blog about Life, SQL & Everything ...

SQLPam's Blog

Life changes fast and this is where I occasionally take time to ponder what I have learned and experienced. A lot of focus will be on SQL and the SQL community – but life varies.

William Durkin

William Durkin a blog on SQL Server, Replication, Performance Tuning and whatever else.