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
800 reads
Mala Mahadevan
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
900 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
951 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,546 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,746 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
393 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
366 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,660 reads
TSQL Tuesday #83 – The Stats update solution
TSQL Tuesday is a monthly blog part hosted by a different blogger every month – it was started by Adam Machanic....
2016-10-11
401 reads
Associative Statistics – One sample T-Test with TSQL and R
In this post am going to attempt to explore a statistical procedure called ‘One Sample T Test’.
A T-Test is used...
2016-09-30 (first published: 2016-09-21)
1,946 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