Detecting outliers and fraudulent behaviour (transactions, purchases, events, actions, triggers, etc.) takes a large amount of experiences and statistical/mathetmatical background. One of the samples Microsoft provided with release of new SQL Server 2016 was using simple logic of Benford’s law.…
Monthly Archives: October 2016
Microsoft MVP Award
On October 1st, 2016 humbled to be received Microsoft MVP Award. And today, October 17th, a special package awaited me at the post office. The award it self. The actual certificate to the MVP award for the Microsoft Data Platform…
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
Performance comparison between kmeans and RevoScaleR rxKmeans
In my previous blog post, I was focusing on data manipulation tasks with RevoScaleR Package in comparison to other data manipulation packages and at the end conclusions were obvious; RevoScaleR can not (without the help of dplyrXdf) do piping (or…
Comparing performance on dplyr package, RevoScaleR package and T-SQL on simple data manipulation tasks
Long I wanted to test a simple data manipulation tasks and compare the execution time, ease of writing the code and simplicity between T-SQL and R package for data manipulation. Couple of packages I will mention for data manipulations are…
Tagged with: dplyr, dplyrXdf, performance, R, RevoScaleR, sp_execute_external_script, statistics
Posted in Uncategorized
Posted in Uncategorized
 | laresbernardo on LazyMouse – R package fo… |
| laresbernardo on LazyMouse – R package fo… |
| Randomly Moving the… on LazyMouse – R package fo… | |
| Advent of 2025, Day… on Advent of 2025, Day 23 – SQL S… | |
| Advent of 2025, Day… on Advent of 2025, Day 22 – SQL S… |
TomazTsql 