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…
Monthly Archives: June 2016
Running multiple correlations with R and T-SQL
Tagged with: Correlations, R, significance, sp_execute_external_script, SQL Server, statistics, T-SQL
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
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…
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…
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
 | tomaztsql on Installing SSIS, SSRS and SSAS… |
| tomaztsql on R graphs and tables in Power B… |
 | John on R graphs and tables in Power B… |
 | Kalyani cynixit on Installing SSIS, SSRS and SSAS… |
 | raymond shaw on Installing SSIS, SSRS and SSAS… |
