With SQL Server 2016, R Language for statistical programming is now supported natively in T-SQL. Powerful R Language enables to do statistical analysis and predictive analytics on your everyday T-SQL queries. In addition, data wrangles, data engineers, data stewards, DBA, and sysadmins can now profit from this integration. R can support any kind of data related task (data cleaning, data manipulation, data migration, data analysis) and can even help to predict when your SQL Server database will need to be extended. In this session we will look 1) the powerful R language and available RevoscaleR package for multi-threaded and parallelization computation, 2) using R language in T-SQL for data analysis and predictions and 3) practical usage and visualization.
Tomaž Kaštrun is BI developer and data analyst at SPAR Business Services GmbH, Spar Slovenija.
His main focus are data mining, T-SQL development, programming and query optimization.
He has been working with SQL server since version 2000. He is Microsoft Certified Professional and Microsoft trainer.