Understanding ANOVA
ANOVA – or analysis of variance, is a term given to a set of statistical models that are used to analyze...
2017-10-16 (first published: 2017-10-09)
2,517 reads
Mala's Data Blog
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...
2017-10-03 (first published: 2017-09-25)
2,645 reads
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...
2017-09-28 (first published: 2017-09-18)
1,333 reads
What is networking, really?
I am still trying to get up to speed on blogging after a gap. Today I managed to push myself...
2017-09-15 (first published: 2017-09-10)
1,582 reads
14 years of Summit…
I have been trying to get my blogging going again after a gap of two months. It has been incredibly...
2017-09-04
511 reads
Getting back to blogging
The past two months have been very hectic for me. I had an unexpected job offer towards end of July,...
2017-08-28
466 reads
Understanding Relative Risk – with T-SQL
In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a...
2017-06-21 (first published: 2017-06-19)
1,962 reads
Cochran-Mantel-Haenzel Method with T-SQL and R – Part I
This test is an extension of the Chi Square test I blogged of earlier. This is applied when we have...
2017-06-12
560 reads
Dataset for Cochran-Mantel-Hanzel Test
Below is the script to create the table and dataset I used. This is just test data and not copied...
2017-06-12
437 reads
Fischer’s Exact Test – with T-SQL and R
This post is a long overdue second part to the post on Chi Square Test that I did a few months...
2017-05-31 (first published: 2017-05-22)
1,478 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers