Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

A Rickety Stairway to SQL Server Data Mining, Part 14.2: Writing a Bare Bones Plugin Algorithm

By Steve Bolton

…………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one of the most powerful yet neglected products Microsoft has to offer. The ability to extend it with your own algorithms is in turn the most powerful yet neglected… Read more

0 comments, 1,640 reads

Posted in Multidimensional Mayhem on 26 August 2013

At the Top of the Rickety Stairway…

by Steve Bolton

…………As expected, I’ve run into quite a few obstacles while trying to deploy and debug my first plug-in algorithm. I’ve finally emerged from “DLL Hell” and have successfully deployed the first algorithm I’ll be using in this tutorial, but still have fatal errors lurking somewhere in… Read more

0 comments, 342 reads

Posted in Multidimensional Mayhem on 31 July 2013

A Rickety Stairway to SQL Server Data Mining, Part 14.1: An Introduction to Plug-In Algorithms


by Steve Bolton

…………In my last post in this amateur series of self-tutorials on SQL Server Data Mining (SSDM), I got into a lengthy discussion of how neglected but powerful SQL Server Analysis Services (SSAS) stored procedures are. This is part of a larger pattern of under-utilization of some… Read more

0 comments, 1,821 reads

Posted in Multidimensional Mayhem on 25 June 2013

A Rickety Stairway to SQL Server Data Mining, Part 13: Using CLR with Analysis Services


by Steve Bolton

               I was drawn into the realm of SQL Server in a roundabout manner thanks to Visual Basic. Around the time I got my Microsoft Certified Solution Developer (MCSD) certification in VB 6.0 (at precisely the same time .Net hit the market, instantly leaving me a year or… Read more

0 comments, 2,037 reads

Posted in Multidimensional Mayhem on 23 May 2013

A Rickety Stairway to SQL Server Data Mining, Part 12: Accessing SSDM with AMO, ADOMD, SSIS, XMLA and RS

by Steve Bolton

                It may set a SQLServerCentral record for the thickest alphabet soup of acronyms ever crammed into a single title, but this post neatly wraps up numerous alternative means of accessing SQL Server Data Mining (SSDM) programmatically. In four previous posts in the series of amateur self-tutorials on… Read more

0 comments, 1,145 reads

Posted in Multidimensional Mayhem on 9 May 2013

A Rickety Stairway to SQL Server Data Mining, Part 11: Model Comparison and Validation

by Steve Bolton               

              Throughout this series of amateur self-tutorials on SQL Server Data Mining (SSDM) I’ve typically included some kind of disclaimer to the effect that I’m writing this in order to learn the material faster (while simultaneously providing the most underrated component of SQL Server some badly needed free…

Read more

0 comments, 1,402 reads

Posted in Multidimensional Mayhem on 26 April 2013

A Rickety Stairway to SQL Server Data Mining, Part 10.4: Data Mining Dimensions vs. Drastic Dynamic DMX


by Steve Bolton

                Anyone who’s gotten this far in this series of amateur self-tutorials on SQL Server Data Mining (SSDM) is probably capable of using it to unearth some worthwhile nuggets of wisdom in their data. One of the key remaining questions at this step of our rickety stairway is… Read more

1 comments, 1,432 reads

Posted in Multidimensional Mayhem on 16 April 2013

A Rickety Stairway to SQL Server Data Mining, Part 10.3: DMX Prediction Queries

 
by Steve Bolton

               In the last two installments of this series of amateur self-tutorials on SQL Server Data Mining (SSDM), I discussed how to performed Data Definition Language (DDL) and Data Manipulation Language (DML) tasks with Data Mining Expressions (DMX), the SQL-like language used to administer SSDM. These topics were… Read more

0 comments, 1,905 reads

Posted in Multidimensional Mayhem on 1 April 2013

A Rickety Stairway to SQL Server Data Mining, Part 10.2: DMX DML

by Steve Bolton

                The three introductory posts in this series of self-tutorials on SQL Server Data Mining (SSDM) and the separate articles on the nine algorithms Microsoft ships with it covered the most complex and essential elements of of the most under-utilized and underestimated component of the product. Most of… Read more

2 comments, 1,196 reads

Posted in Multidimensional Mayhem on 26 March 2013

A Rickety Stairway to SQL Server Data Mining, Part 10.1: DDL with DMX

by Steve Bolton

                As users become more familiar with software, they typically follow a progression that begins with learning the GUI, followed by how to perform the same functions programmatically, then perhaps becoming adept at writing custom code. Other instructional material on SQL Server Data Mining (SSDM), such as that… Read more

0 comments, 2,044 reads

Posted in Multidimensional Mayhem on 11 March 2013

A Rickety Stairway to SQL Server Data Mining, Algorithm 9: Time Series

by Steve Bolton

                The data mining method known as Time Series is aptly named, because it seems to take a long series of time to get it right.
                Out of the nine algorithms included in SQL Server Data Mining (SSDM), Time Series is on a par with Neural Networks in… Read more

0 comments, 1,713 reads

Posted in Multidimensional Mayhem on 26 February 2013

A Rickety Stairway to SQL Server Data Mining, Algorithm 8: Sequence Clustering

by Steve Bolton

               In last week’s edition of this amateur series of self-tutorials[i] on SQL Server Data Mining (SSDM), we covered Clustering, an algorithm with an exceptionally wide variety of uses in comparison to the other eight Microsoft includes with the product. Sequence Clustering may be derived from that… Read more

3 comments, 1,061 reads

Posted in Multidimensional Mayhem on 21 February 2013

A Rickety Stairway to SQL Server Data Mining, Algorithm 7: Clustering

by Steve Bolton

                In last week’s installment of this amateur series of self-tutorials on SQL Server Data Mining (SSDM), we covered my least favorite of the nine algorithms Microsoft includes with the product. There is a right time and place for every tool, but the times and places where Association… Read more

1 comments, 2,040 reads

Posted in Multidimensional Mayhem on 12 February 2013

A Rickety Stairway to SQL Server Data Mining, Algorithm 6: Association Rules

by Steve Bolton

                In last week’s installment of this series of self-tutorials on SQL Server Data Mining (SSDM), we covered my favorite algorithm, Neural Networks, which is also among the most intricate but productive of the nine data mining methods Microsoft provides. The major drawback is that its inner workings… Read more

1 comments, 1,277 reads

Posted in Multidimensional Mayhem on 7 February 2013

A Rickety Stairway to SQL Server Data Mining, Algorithm 5: The Neural Network Algorithm

by Steve Bolton

                Anyone who has been following this series of self-tutorials has probably grown accustomed to me adding some kind of disclaimer about my shortcomings as a data miner. These blog posts are designed to simultaneously give the most under-utilized part of SQL Server some badly needed free press,… Read more

0 comments, 1,574 reads

Posted in Multidimensional Mayhem on 30 January 2013

A Rickety Stairway to SQL Server Data Mining, Algorithm 4: Logistic Regression

  by Steve Bolton

              In the last installment of this series of self-tutorials on SQL Server Data Mining (SSDM), A Rickety Stairway to SQL Server Data Mining, Algorithm 3: Decision Trees, I glossed over an algorithm that built upon the data mining methods touched on in my first two posts,… Read more

0 comments, 1,489 reads

Posted in Multidimensional Mayhem on 23 January 2013

A Rickety Stairway to SQL Server Data Mining, Algorithm 3: Decision Trees

by Steve Bolton 

                This series of self-tutorials is an elementary-level introduction to SQL Server Data Mining (SSDM), not the product of someone who’s done postgraduate work in statistics. Instead of being the last word on the subject, it is a little more like a child learning to speak its first… Read more

0 comments, 1,511 reads

Posted in Multidimensional Mayhem on 16 January 2013

A Rickety Stairway to SQL Server Data Mining, Algorithm 2: Linear Regression

            An algorithm that starts with the word “regression” seems an unlikely candidate to move forward with this series of self-tutorials in SQL Server Data Mining (SSDM), but don’t let the name fool you: Linear Regression is a powerful data mining tool that represents a logical second step in any workflow,… Read more

0 comments, 1,962 reads

Posted in Multidimensional Mayhem on 8 January 2013

A Rickety Stairway to SQL Server Data Mining, Algorithm 1: Not-So-Naïve Bayes

            Thankfully, the simplest of SQL Server’s algorithms is not quite as naïve about data mining as I am.
            As mentioned in my last post, I had to delay my article on the simplest of Microsoft’s data mining algorithms due to a number of factors, the worst of which turned out… Read more

0 comments, 4,086 reads

Posted in Multidimensional Mayhem on 4 January 2013

A Rickety Stairway to SQL Server Data Mining, Part 0.2: How to Dig Out of a Data Mining Cave-In

         This third part in my series of self-tutorials in SQL Server Data Mining (SSDM) was delayed for several weeks due to some unforeseen mishaps, like an antibiotic resistant infection that almost put me in the hospital for the holidays, but most of the delay was due to performance problems stemming… Read more

2 comments, 1,064 reads

Posted in Multidimensional Mayhem on 3 January 2013

Newer posts

Older posts