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,920 reads
Mala Mahadevan
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,718 reads
2016 – A Year to remember
2016 has undoubtedly been a landmark year in my life. To me it marked my first conscious entry into mid...
2016-12-31
805 reads
Internal Query Processor Error with ColumnStore Indexes
SQL Server 2016 does not allow computed columns to co exist with columnstore indexes and clustered btree indexes on same table.
2016-12-29
907 reads
Multivariate Variable Analysis using R
So far I’ve worked on simple analytical techniques using one or two variables in a dataset. This article is a...
2016-12-05
974 reads
Associative Analytics: Two sample T Test
In the previous post we looked at a one way T-Test. A one way T Test helped us determine if...
2016-11-25 (first published: 2016-11-21)
2,562 reads
PASSion Award and what it means to me
2016 is going to be a special year in my life. There was an article on Oscar awards a while...
2016-11-04 (first published: 2016-10-31)
1,753 reads
Days 1,2 and 3 of PASS Summit 2016
Today is Thursday, October 27th already. For some of us the summit begins monday – with precons and PASS Volunteering related meetings...
2016-10-27
397 reads
Sending Trevor love…
As some of you may be aware – fellow SQL family member, PASS Director, SQL Server MVP, founder of SQL Cruise...
2016-10-26
377 reads
Basic Data Manipulation for Relational Data in R
In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.
2016-10-20
1,663 reads
Blogs
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
Forums
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now
Comments posted to this topic are about the item Five SQL Server 2022 T-SQL...
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers