This is a story of my 11-year association with PASS, and the many ways it helped me grow as a person and in my career. And the many ways I saw other people grow. Summit #1 – 2006: Gaylord,TX: I was a visa holding dba-developer at a small shop. The Microsoft marketing person who came… Continue reading 11 years of PASS Summit
I was riding the elevator up from lunch today, at work. I am relatively new at my job and do not know several people at my workplace – yet. I live in a small town, and quite a lot of them know me as someone active in the local community. I am very used to… Continue reading Why SQL Cruise?
In this post am going to attempt to explore a statistical procedure called ‘One Sample T Test’. A T-Test is used to test the mean value of a data sample against a known mean of the entire population from where the sample came from. An example would be, if the average voting preference of the… Continue reading Associative Statistics – One sample T-Test with TSQL and R
We’ve been doing SQLSaturdays for eight years at Louisville now. We’ve had a quite a wide range of budgets depending on the year – a good year (our highest was 2013) and lowest, the first year we started, 2009. As main organizer, handling the dollars and making sure I spend them right has been an interesting, learning experience… Continue reading Budgeting for SQL Saturdays
As I move on from descriptive and largely univariate (one variable based) analysis of data into more multivariate data – one of the first data analysis tests that came to mind is the Chi Square Test. It is a very commonly used test to understand relationships between two variables that are largely categorical in nature.… Continue reading Statistics with TSQL and R: Chi Square Test
In this post I will attempt to explore calculation of a very basic statistic based on linear relationship between two variables. That is, a number that tells you if two numeric variables in a dataset are possibly correlated and if yes, by what degree. The Pearson’s coefficient is a number that attempts to measure this… Continue reading Statistics with T-SQL and R – the Pearson’s Correlation Coefficient
Make sure you have a working version of SQL Server 2016. USE [master] GO /****** Object: Database [WorldHealth] ******/ CREATE DATABASE [WorldHealth] CONTAINMENT = NONE ON PRIMARY ( NAME = N’WorldHealth’, FILENAME = N’D:\Microsoft SQL Server\DATA\WorldHealth.mdf’ , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ) LOG ON ( NAME = N’WorldHealth_log’, FILENAME… Continue reading Script for creating test data for odds ratio