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...

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...

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...

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...

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...

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...

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...

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...

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...

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...