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,659 reads
Mala Mahadevan
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,336 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,585 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
514 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
469 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,971 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
569 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
449 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,479 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
445 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
Alamat Kantor BCA KCU SIDOARJO Wa(082144477715)
Wa:0821-4447-7715 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
Alamat Kantor BCA KCU PASURUAN Telp (0817866887)
Wa:0817-866-887 Jl. Soekarno Hatta No.33, Trajeng, Kec. Panggungrejo, Kota Pasuruan, Jawa Timur 67111
ALAMAT BCA KCU BUKIT BARISAN TLP/WA 08218200174
Telp Cs: 08218200174 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers