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…
TomazTsql
Tomaz doing BI and DEV with SQL Server and R
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
| 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… |
