Outlier Detection with SQL Server, part 3.1: Grubbs’ Test
By Steve Bolton
…………In the last two installments of this series of amateur self-tutorials, I mentioned that the various means of...
2014-12-03 (first published: 2014-11-29)
11,094 reads
Outlier Detection with SQL Server, part 2.2: Modified Z-Scores
By Steve Bolton
…………There are apparently many subtle variations on Z-Scores, a ubiquitous measure that is practically a cornerstone in the...
2014-11-13
2,547 reads
Outlier Detection with SQL Server, part 2.1: Z-Scores
By Steve Bolton
…………Using SQL Server to ferret out those aberrant data points we call outliers may call for some complex...
2014-10-28
2,847 reads
Outlier Detection with SQL Server, part 1: Finding Fraud and Folly with Benford’s Law
By Steve Bolton
…………My last blog series, A Rickety Stairway to SQL Server Data Mining, often epitomized a quip by University...
2014-09-19
3,345 reads
Stay Tuned…for a SQL Server Tutorial Series Juggling Act
by Steve Bolton
…………If all goes according to plan, my blog will return in a few weeks with two brand new...
2014-07-01
703 reads
A Rickety Stairway to SQL Server Data Mining, Part 15, The Grand Finale: Custom Data Mining Viewers
By Steve Bolton
…………As mentioned previously in this amateur self-tutorial series on the most neglected component of Microsoft’s leading database server...
2014-02-17 (first published: 2014-02-11)
2,065 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.8: PMML Hell
By Steve Bolton
…………In A Rickety Stairway to SQL Server Data Mining, Part 14.3: Debugging and Deployment, we passed the apex...
2014-01-15
1,605 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.7: Additional Plugin Functionality
By Steve Bolton
…………In order to divide this segment of my amateur tutorial series on SQL Server Data Mining (SSDM) into...
2014-01-07 (first published: 2013-12-31)
2,261 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.6: Custom Mining Functions
by Steve Bolton
…………In the last installment of this amateur series of mistutorials on SQL Server Data Mining (SSDM), I explained how to...
2013-12-06 (first published: 2013-11-28)
2,690 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.5: The Predict Method
By Steve Bolton
…………In order to divide the Herculean task of describing custom algorithms into bite-sized chunks, I omitted discussion of...
2013-11-04 (first published: 2013-10-30)
2,786 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers