Below is the script to create the table and dataset I used. This is just test data and not copied from anywhere. USE [yourdb] GO /****** Object: Table [dbo].[DrugResponse] Script Date: 6/12/2017 6:45:46 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIERl ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[DrugResponse]( [seqno] [int] IDENTITY(1,1) NOT NULL,… Continue reading Dataset for Cochran-Mantel-Hanzel Test
A casual twitter-conversation with Karla Landrum and some other peeps led me down memory lane on older events. Our SQL Saturday at Louisville will be 9 years old this year. We were event #23, in 2009. SQL Saturdays started two years before, in 2007. Our first event was held at a training center – 2 tracks,… Continue reading SQL Saturdays – down memory lane
In this post am going to explain (in highly simplified terms) two very important statistical concepts – the sampling distribution and central limit theorem. The sampling distribution is the distribution of means collected from random samples taken from a population. So, for example, if i have a population of life expectancies around the globe. I draw… Continue reading Sampling Distribution and Central Limit Theorem
Today is Thursday, October 27th already. For some of us the summit begins monday – with precons and PASS Volunteering related meetings on Tuesday. For most other attendees the first day was Wednesday. I arrived in the afternoon on Sunday with six other friends from Louisville,including my good friend Chris Yates. I have been travelling to… Continue reading Days 1,2 and 3 of PASS Summit 2016
TSQL Tuesday is a monthly blog part hosted by a different blogger every month – it was started by Adam Machanic. This week’s TSQL Tuesday is hosted by Andy Mallon – the topic is ‘We’re dealing with the same problem’. I have chosen to write about a common problem I have encountered at many places… Continue reading TSQL Tuesday #83 – The Stats update solution
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
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
