Happy New Year with a big bang!

It’s been over 10 years that I’ve been working on data mining for SQL Server and the new year brings big changes for me.  It’s been a very exciting time for me to learn this technology and industry, and with the new year, I’m leaving Microsoft to become the founding CTO of Predixion Software.  It’s…

0

The amazing flexibility of DMX Table Valued Parameters

When most people think of “Table Valued Parameters” they think of “possibly the most anticipated T-SQL feature of SQL Server 2008.”  However, little may you know, that the Data Mining team added table valued parameters and table valued functions to DMX in SQL Server 2005.  Not only has this feature been in shipping code for…

0

More Data Mining in the Cloud?

Since we released the Tech Preview of the Cloud Data Mining Addins last year, I’ve heard about and talked with Michael Zeller of Zementis.  Zementis has been very active in shaping the PMML (Predictive Modeling Markup Language) standard for representing learned knowledge in XML format.  They have a product called ADAPA that allows you to…

3

New Cloud Data Mining Addin Usability Feature (well kind of)

Bogdan did an awesome job putting together the modified Data Mining Addin for the cloud.  We saw quite a few downloads of his new addin, but surprisingly and unfortunately, didn’t see a lot of usage!  Strange?  Maybe.  Bogdan thought about the issue for a while and from a few anecdotal comments determined that once installed, the…

1

In Germany this April?

If so – check out the European PASS Conference, if not – maybe you should be! This conference will have a great BI focus including a pre-conference session on using SQL Server BI tools to monitor SQL Server BI tools and at least two data mining sessions, including one from Steve Simon of State Street…

1

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