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
This month’s T-SQL Tuesday is hosted by Ewald Cress, and the topic is ‘Folks who have made a difference’. This is an opportunity – and right around thanksgiving – to give a shout-out to people who have made a difference in our careers and in the data community. To me this list is so long… Continue reading TSQL Tuesday #96 – Folks who have made a difference
Last week I listened to a podcast from one of my best friends in the sql community – Kendra Little. In this podcast Kendra talks of her encounter with anxiety attacks and how she dealt with them. When I listened to her honest, moving story – my mind was filled with thoughts on the many… Continue reading Dealing with disquiet
I have been a PASS summit attendee for 14 years now. This year is my 15th. Every year is different – some years are better than others, some make you feel it wasn’t as good as usual. This year was an odd experience for me. Quite a number of my friends were not attending for… Continue reading PASS Summit 2017 – the best ever
ANOVA – or analysis of variance, is a term given to a set of statistical models that are used to analyze differences among groups and if the differences are statistically significant to arrive at any conclusion. The models were developed by statistician and evolutionary biologist Ronald Fischer. To give a very simplistic definition – ANOVA… Continue reading Understanding ANOVA
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
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
