As some of you may be aware – fellow SQL family member, PASS Director, SQL Server MVP, founder of SQL Cruise and a good friend to many of us – Tim Ford – has a young son Trevor Ford who was recently diagnosed with a rare allergic drug reaction called Steven-Johnsons syndrome. Trevor has been… Continue reading Sending Trevor love…
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
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