Jamie's Junk

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Last week Bogdan and I went through the final steps in completing the SQL (sic) to the wildly popular "Data Mining with SQL Server 2005", cleverly titled "Data Mining with SQL Server 2008". We went through the final PDF's and signed off that the companion...

This post continues part 2 of the series. In this part of the series I will demonstrate how to create a report using the stored procedure and also how to call the stored procedure from Excel using the Data Mining Addins for Office 2007 . In creating...

This post continues part 1 of the series . In this part of the series, I will walk through the code of the stored procedure and explain what it does and why - and maybe expound on what could be as well. First, when creating an Analysis Services stored...

Many people have been asking for complete coding samples involving data mining.  Also, many people have been frustrated trying to generate reports using time series predictions.  So I decided to kill two birds with one stone and create a sample...

In case the title of my last post wasn't provocative enough, I'll post it again! Here's an excerpt "access the Table Analysis Tools for Excel 2007 by connecting to our hosted data mining service"... If you don't want to read the long-winded post and...

Bogdan and Raman are currently outside of Las Vegas at the KDD 2008 (Knowledge Discovery and Data Mining) conference. At the conference they are showing all the goodness that is SQL Server 2008 Data Mining, but also a "secret project" that Bogdan has...

Wee Hyong, a SQL Server MVP in Singapore discusses with Channel 9 how he improved the event experience for the Heroes Community launch using the Data Mining Addins. The first half of the video is the interview and then he presents a demo of the event...

As I'm in the mood for finally responding to frequent requests, here is a list of case studies referring to SQL Server Data Mining on Microsoft.com.  Note that these are "marketing" case studies and are notoriously sparse on details, and...

Many people ask me fore pointers to data mining and this fell into my lap over the past few days.  I've blogged about Rafal before when he first took up speaking on data mining - now he's created a lot of new material and presented to audiences around...

Our friends at Visual Numerics, Inc have created an excellent white paper covering the creation of SQL Server Data Mining plug-in algorithms in C#.  In addition to documenting all of the architecture and concepts required, they have created a step...