TSQL Tuesday

T-SQL Tuesday #97 – Setting learning goals for 2018

  This is my first opportunity hosting a T-SQL Tuesday and am super excited!! T-SQL Tuesday is the brainchild of well respected SQL Guru and author of ‘sp_whois active’ – Adam Machanic (b|t).  Adam rightly predicted that we all could benefit from ‘a recurring, revolving blog party’ with a new topic given each month – the party has… Continue reading T-SQL Tuesday #97 – Setting learning goals for 2018

Statistics with R and SQL

Box-and-whisker plot and data patterns with R and T-SQL

R is particularly good with drawing graphs with data. Some graphs are familiar to most DBAs as it has been things we have seen and used over time – bar charts, pie diagram and so on. Some are not. Understanding exploratory graphics is vitally important to the R programmer/data science newbie. This week I wanted… Continue reading Box-and-whisker plot and data patterns with R and T-SQL

Statistics with R and SQL

Confidence Intervals for a proportion – using R

What is the difference between reading numbers as they are presented, and interpreting them in a mature, deeper way? One way perhaps to look at the latter is what statisticians call ‘confidence interval’. Suppose I look at a sampling of 100 americans who are asked if they approve of the job the supreme court is… Continue reading Confidence Intervals for a proportion – using R