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, 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, 1,913 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,102 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,374 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,188 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,245 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,674 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, 3,639 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, 902 reads

Posted in Multidimensional Mayhem on 3 January 2013

A Trip Down the Rickety Stairway…

I’ve had to delay my series of self-tutorials on data mining for a few weeks following an antibiotic resistant infection that almost put me in the hospital for the holidays, plus some unexpected performance problems with Analysis Services. I’ve had my next two posts on the Naive Bayes and Linear… Read more

0 comments, 466 reads

Posted in Multidimensional Mayhem on 24 December 2012

A Rickety Stairway to SQL Server Data Mining, Part 0.1: Data In, Data Out

                 In the first of a series of amateur tutorials on SQL Server Data Mining (SSDM), I promised to pull off an impossible stunt: explaining the broad field of statistics in a few paragraphs without the use of equations. What other SQL Server blog ends with a cliffhanger like that?… Read more

0 comments, 3,098 reads

Posted in Multidimensional Mayhem on 28 November 2012

A Rickety Stairway to SQL Server Data Mining, Part 0.0: An Introduction to an Introduction

 
      As I mentioned in my column in June, one of the many lessons I learned at the first-ever SQL Saturday event hosted by the Professional Association of SQL Server (PASS) Rochester chapter was that data mining is perhaps the least understood feature of Microsoft’s industry-leading database server software. It’s… Read more

1 comments, 2,322 reads

Posted in Multidimensional Mayhem on 15 November 2012

Another Stop-Gap Solution for the SQL Server 2012 Identity Crisis

                I haven’t seen this many fake ID’s since I was in college.
                Back on April 26, Grant Fritchey (of execution plan fame) reported a strange bug in the newly released version of SQL Server, in which the values of certain identity columns are suddenly incremented by about 1,000. Since then,… Read more

10 comments, 3,400 reads

Posted in Multidimensional Mayhem on 16 October 2012

A Novel Workaround for an Infamous SSAS Connection Error

For months I’ve been itching to get the latest version of SQL Server, thanks to the addition of new functionality on the OLTP side that I can make use of, like FileTables and the new windowing functions. Two Fridays ago, I finally got my copy of SQL Server 2012 Developer… Read more

10 comments, 819 reads

Posted in Multidimensional Mayhem on 28 August 2012

SQL Saturday in Rochester Exceeds Expectations

                 After being forced to deliver sour grapes in my last few columns – thanks to some unexpectedly negative experiences with Oracle and DB2, not to mention the lack of new features in MDX and Windows 8 – I am  pleased to have positive news to share. On May 12 I… Read more

0 comments, 858 reads

Posted in Multidimensional Mayhem on 29 May 2012

Thank God I Chose SQL Server part II: How to Improperly Install Oracle 11gR2

As part of my ongoing effort to teach by bad example and pass on what little I’ve learned about programming and database administration through mishap, my last column, Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial, told the tale of how my evaluation… Read more

6 comments, 2,123 reads

Posted in Multidimensional Mayhem on 1 May 2012

Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial

My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of errors of my own making. This week’s mistutorial likewise teaches through bad example, by the same heuristic principle that experiencing what can go wrong with a task can sometimes… Read more

1 comments, 1,826 reads

Posted in Multidimensional Mayhem on 31 March 2012

Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong

                Doing things by the book isn’t necessarily the only way to learn a new skill. Sometimes, experiencing everything that can possibly go wrong when you don’t follow the book can leave a more lasting impression.
I had that misfortune in December, when I tried to port some of my SQL…

Read more

2 comments, 1,537 reads

Posted in Multidimensional Mayhem on 28 February 2012

Sitting Between Two Stools: Analysis Services 2012, Windows 8 and Market Niche Confusion at Microsoft

In my last post, I wrote that the game plan was to post by Dec. 10 on changes in data mining and DMX in the upcoming version of SQL Server. As usual, I got behind the curve for a variety reasons, including taking some time out to learn about the… Read more

1 comments, 1,117 reads

Posted in Multidimensional Mayhem on 24 January 2012

Installing SQL Server 2012 Release Candidate 0

In my last post, I indicated that my plan was to post by Dec. 3 on the topic of data mining in the latest version of SQL Server. Thanks to a couple of hitches during installation, however, I wasn’t able to get through the section in Help or play around… Read more

0 comments, 1,603 reads

Posted in Multidimensional Mayhem on 3 December 2011

An Informal Compendium of SSAS Errors, Part 6: Common Errors

This is the last in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there is apparently little, if any, documentation anywhere on the planet. This particular post is a coda that discusses some common errors, for the benefit of beginners. For an introduction to… Read more

0 comments, 659 reads

Posted in Multidimensional Mayhem on 20 November 2011

Newer posts

Older posts