Querying the Dependency Net

OK, ok, so just yesterday I posted that it was easy to determine what queries were being used by the browsers to get the data underlying the view.  Of course it’s easy to get them, but without a teensy weensy bit of documentation, it’s not necessarily easy to understand what the parameters mean or possibly…

1

Data Mining in SQL Server 2008 Book Review

I just read a great review of our book from Richard Lees in Australia.  Richard is one of the early adopters of Analysis Service and Data Mining, so he has a lot of experience in this area (we actually reference some of his samples in the book!).  You should check out his blog anyway, just…

1

Querying like the Data Mining viewers do

It happens all the time.  You see some cool user interface trick and think “how can I do that?”  Or, maybe more likely, you think “gee, that’s useful, where’s that documented?”  In any case, if you have ever wondered about how the DM viewers get the data to display on the screen, then this is…

1

Those kids won’t eat anything!

I did my BI Power Hour demo at PASS 2008 yesterday and it featured my twin boys Bowen and Logan. Logan (right) has an ASD (Autism Spectrum Disorder) that limits his diet (no milk products, gluten, or soy) and Bowen has some sensory issues, but that doesn’t explain their extreme pickiness with food.  For example,…

1

Time’s running out for your free data mining book!

The survey is now closed.  Thank you.  Tomorrow is the last day you can fill out this survey for a chance to win one of ten copies of Data Mining with SQL Server 2008.  I used the the Data Exploration tool in the SQL Server 2008 Data Mining Client for Excel, and saw that it…

1

See me at PASS in Seattle next week

I’ll be at the PASS 2008 conference in Seattle most of next week.  Currently (subject to change) I’ll be presenting at the BI Power Hour on Wednesday at 1:45 and will be in the Ask the Experts area on Wednesday after the Power Hour session and Thursday from 11 to 2. Stop by if you…

1

Get a FREE AUTOGRAPHED copy of Data Mining with SQL Server 2008

 The survey is now closed.  Thank you  I checked on Amazon today and Data Mining with SQL Server 2008 is finally in stock!  However, if you are currently using SQL Server Data Mining, before you rush out and buy a copy, please take this opportunity to win a FREE COPY AUTOGRAPHED BY BOGDAN AND ME…

1

Time Series Reporting Stored Procedure – Part 4 of 3

OK, OK, I know it’s just not right to do a part 4 of a three part series, but I’ve gotten enough demand to expand these stored procedures just a little bit.  I casually left out a class of time series models that contain nested tables since it made things a bit more complicated to…

0

Support Vector Machines for SQL Server Data Mining

Many have requested that we implement Support Vector Machines (SVM’s) for SQL Server 2008, and for a wide variety of reasons, we just couldn’t get to it.  Luckily the community has come to the rescue for those needing an SVM implementation today!  Joris Valkonet of Avanade Netherlands along with colleague Thanh Luc have implemented an…

1

Getting Data Mining results into SQL Tables

I’ve been seeing lots of questions about how to get data mining results into SQL tables.  Most times the answers are “use the prediction query builder save button” or “build an SSIS package.”  Both of these have issues among them being that the former is really only suited to single-use, small jobs, and the latter…

1