I wanted to check a simple query: How many times has a particular topic been presented and from how many different presenters. Sounds interesting, tackling the problem should not be a problem, just that the end numbers may vary, since…
Blog Archives
SQL Saturday statistics – Web Scraping with R and SQL Server
Tagged with: Microsoft, Python, R, SQL Server, SQL Server R Services, SQLSaturday, statistics, T-SQL, web scrape
Posted in Uncategorized
Posted in Uncategorized
Robust IRIS Dataset?
This blog post was born out of pure curiosity about the robustness of the IRIS Dataset. Biological datasets do not need to be that big in comparison to datasets of customers, consumption, stock and anything that might be volatile. When…
Using R sp_execute_external_script with JSON
JSON has become part of the SQL Server in the same version as R. Both were very highly anticipated and awaited from the community. JSON has very powerful statements for converting to and from JSON for storing into / from…
Tagged with: JSON, R, sp_execute_external_script, SQL Server R Services, T-SQL
Posted in Uncategorized
Posted in Uncategorized
Clustering executed SQL Server queries using R as tool for
When query execution performance analysis is to be done, there are many ways to find which queries might cause any unwanted load or cause stall on the server. By encouraging DBA community to start practicing the advantage or R Language…
Tagged with: clustering, DBA, Query execution, R, SQL Server, SQL Server R Services, T-SQL, Visualization
Posted in Uncategorized
Posted in Uncategorized
SQL Saturday Vienna 2017 #sqlsatVienna
SQL Saturday Vienna 2017 is just around the corner. On Friday, January 20, 2017, a lot of local and international speakers will gather to deliver sessions relating to SQL Server and all related services. With great agenda – available here,…
Tagged with: pre con, R workshop, SQL Server, SQL Server R Services, SQLSaturday, workshop
Posted in Uncategorized
Posted in Uncategorized
Association Rules on WideWorldImporters and SQL Server R Services
Association rules are very handy for analyzing Retail data. And WWI database has really neat set of invoices that can be used to make a primer. Starting with following T-SQL query: USE WideWorldIMportersDW; GO ;WITH PRODUCT AS ( SELECT …
Tagged with: Association Rules, R, sp_execute_external_script, SQL Server, SQL Server R Services
Posted in Uncategorized
Posted in Uncategorized
 | tomaztsql on Retrieving user access list to… |
 | Paola A Zambrano on Retrieving user access list to… |
| “Reverse Hello… on Little useless-useful R functi… | |
 | Max Petter on Using R and Python in Microsof… |
 | detlef kissel on Using R and Python in Microsof… |
TomazTsql 