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,710 reads
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,710 reads
2016 has undoubtedly been a landmark year in my life. To me it marked my first conscious entry into mid...
2016-12-31
801 reads
SQL Server 2016 does not allow computed columns to co exist with columnstore indexes and clustered btree indexes on same table.
2016-12-29
905 reads
So far I’ve worked on simple analytical techniques using one or two variables in a dataset. This article is a...
2016-12-05
958 reads
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,553 reads
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,750 reads
Today is Thursday, October 27th already. For some of us the summit begins monday – with precons and PASS Volunteering related meetings...
2016-10-27
395 reads
As some of you may be aware – fellow SQL family member, PASS Director, SQL Server MVP, founder of SQL Cruise...
2016-10-26
370 reads
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
TSQL Tuesday is a monthly blog part hosted by a different blogger every month – it was started by Adam Machanic....
2016-10-11
406 reads
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Comments posted to this topic are about the item 25 Years of SQL Server...
Comments posted to this topic are about the item The Decoded Value
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers