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,091 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,509 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,839 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
700 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,061 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,598 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,259 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,685 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,781 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers