11 years of PASS Summit

This is a story of my 11-year association with PASS, and the many ways it helped me grow as a...

Why SQL Cruise?

I was riding the elevator up from lunch today, at work. I am relatively new at my job and do...

Statistics with TSQL and R: Chi Square Test

As I move on from descriptive and  largely univariate (one variable based) analysis of data into more multivariate data – one...

Budgeting for SQL Saturdays

We’ve been doing SQLSaturdays for eight years at Louisville now. We’ve had a quite a wide range of budgets depending on...

Statistics with T-SQL and R – the Pearson’s Correlation Coefficient

In this post I will attempt to explore calculation of a very basic statistic based on linear relationship between two...

Calculating odds ratio with T-SQL and R

Simple steps towards understanding what is an Odds Ratio, and how do we arrive at it using TSQL and R scripts.

Script for creating test data for odds ratio

Make sure you have a working version of SQL Server 2016.
USE [master]

GO
/****** Object: Database [WorldHealth] ******/

CREATE DATABASE [WorldHealth]

CONTAINMENT = NONE

ON PRIMARY

(...

TSQL Tuesday #081 – Sharpening something

This TSQL tuesday is hosted by my good friend Jason Brimhall – Jason has put forth a creative challenge – plan to...

Descriptive Statistics with SQL and R – II

In the previous post I looked into some very basic and common measures of descriptive statistics – mean, median and mode,...

Script to create demo database and load data for statistics and R

Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...