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,088 reads
Multidimensional Mayhem
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,464 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,833 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,343 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
699 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,058 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,597 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,256 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,677 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,775 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers