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,422 reads
Mala Mahadevan
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,918 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
694 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,498 reads
Generating Frequency Table
This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete...
2017-03-20 (first published: 2017-03-06)
8,270 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
437 reads
The Empirical Rule
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning...
2017-03-02 (first published: 2017-02-27)
2,508 reads
SQL Cruise 2017 – Western Carribean – my experience
As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is...
2017-02-19
612 reads
My Epic Life Quest
I have always maintained a private bucket list. I have not had the courage to actually put it down in...
2017-01-13 (first published: 2017-01-02)
1,917 reads
Simpson's Paradox
This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox.
2017-01-10
3,705 reads
Blogs
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
The PASS Data Community Summit 2025 Recap
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
Microsoft Post-Quantum Crypto APIs Are Now Generally Available
By Brian Kelley
I mentioned this in my talk on Quantum Computing at the PASS Data Community...
Forums
Find all the tables in a database containing particular column value
Hi, I want to find all the tables name under a database where tables...
The Ending Substring
Comments posted to this topic are about the item The Ending Substring
Done is Better than Good
Comments posted to this topic are about the item Done is Better than Good,...
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers