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
452 reads
Mala's Data Blog
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,480 reads
SQL Saturday Louisville precon – interview Andy Leonard
This will be year #9 of sql saturdays in Louisville. Every year (starting with 3rd or 4th), it has been...
2017-05-08
446 reads
SQL Saturdays – down memory lane
A casual twitter-conversation with Karla Landrum and some other peeps led me down memory lane on older events. Our SQL...
2017-05-01
434 reads
The Birthday Problem – with T-SQL and R
When I was on SQLCruise recently – Buck Woody (b|t) made a interesting statement – that in a room of 23 people,...
2017-05-03 (first published: 2017-04-24)
1,937 reads
Normal approximation to binomial distribution using T-SQL and R
In the previous post I demonstrated the use of binomial formula to calculate probabilities of events occurring in certain situations....
2017-04-17
1,454 reads
The Binomial Formula with T-SQL and R
In a previous post I explained the basics of probability. In this post I will use some of those principles to...
2017-04-17 (first published: 2017-04-10)
1,932 reads
Sampling Distribution and Central Limit Theorem
In this post am going to explain (in highly simplified terms) two very important statistical concepts – the sampling distribution and central...
2017-04-03
700 reads
Basics of Probability
In this post am going to introduce into some of the basic principles of probability – and use it in other posts...
2017-03-30 (first published: 2017-03-20)
4,514 reads
TSQL2sday – Daily database WTF
This month’s TSQL Tuesday is organized by Kennie T Pontoppidan(t) – the topic is ‘Daily Database WTF‘ – or a horror story...
2017-03-12
456 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers