Basic Data Manipulation for Relational Data in R

In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.

TSQL Tuesday #83 – The Stats update solution

TSQL Tuesday is a monthly blog part hosted by a different blogger every month – it was started by Adam Machanic....

Associative Statistics – One sample T-Test with TSQL and R

In this post am going to attempt to explore a statistical procedure called ‘One Sample T Test’.
A T-Test is used...

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

(...