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

SQL Saturday Slovenia 2016 #SQLSatSlovenia – current statistics

On May 30, 2016 SQL Saturday Slovenia was announced. In less than 2 weeks we had 53 sessions submitted. To give you all some additional kick to submit more, here are some first statistics. This year, I will use Power

Posted in Uncategorized

Azure Machine Learning Algorithms – #sqlsatVienna session evaluation

After reading the session evaluation on my presentation of Azure Machine Learning Algorithms at SQL Saturday Vienna 2016 again it got me thinking. What got me thinking (again and again) is not the positive feedback or critical view (yes, I

Posted in Uncategorized

Precon at SQL Saturday Denmark 2016 #sqlsatdenmark

SqlSaturday Denmark 2016 will be taking place in Copenhagen on 17th September and pre-cons will be going on on Friday, 16th of September 2016. I will be honored to deliver a full-day session on SQL Server and R integration upon

Posted in Uncategorized
Follow TomazTsql on
Programs I Use: SQL Search
Programs I Use: R Studio
Programs I Use: Plan Explorer
Programs I use: Scraper API
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

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


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, Power BI, Azure and beyond - attaining enlightenment with the Microsoft Data and Cloud Platforms with a sprinkling of Open Source and supporting technologies!

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

Business Analytics 3.0

Data Driven Business Models

SQL Database Engine Blog

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

Search Msdn

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


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

Ms SQL Girl

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


R news and tutorials contributed by hundreds of 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

DevOps could be the disease you die with, but don’t die of.

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.