Jamie's Junk

Whatever comes to mind "The official blog of the SQL Server Analysis Services Data Mining Architect" (tm)

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

Author: MSDN Archive Date: 01/01/2010

The amazing flexibility of DMX Table Valued Parameters

When most people think of “Table Valued Parameters” they think of “possibly the most anticipated...

Author: MSDN Archive Date: 09/24/2009

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

Author: MSDN Archive Date: 05/12/2009

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

Author: MSDN Archive Date: 05/07/2009

In Germany this April?

If so – check out the European PASS Conference, if not – maybe you should be! This conference will...

Author: MSDN Archive Date: 02/05/2009

Querying the Dependency Net

OK, ok, so just yesterday I posted that it was easy to determine what queries were being used by the...

Author: MSDN Archive Date: 12/12/2008

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

Author: MSDN Archive Date: 12/11/2008

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

Author: MSDN Archive Date: 12/10/2008

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

Author: MSDN Archive Date: 11/20/2008

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

Author: MSDN Archive Date: 11/20/2008

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

Author: MSDN Archive Date: 11/13/2008

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

Author: MSDN Archive Date: 11/07/2008

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

Author: MSDN Archive Date: 10/14/2008

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

Author: MSDN Archive Date: 10/14/2008

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

Author: MSDN Archive Date: 10/08/2008

Data Mining with SQL Server 2008

Last week Bogdan and I went through the final steps in completing the SQL (sic) to the wildly...

Author: MSDN Archive Date: 10/02/2008

Time Series Reporting Stored Procedure - part 3 of 3

This post continues part 2 of the series. In this part of the series I will demonstrate how to...

Author: MSDN Archive Date: 09/19/2008

Time Series Reporting Stored Procedure - part 2 of 3

This post continues part 1 of the series. In this part of the series, I will walk through the code...

Author: MSDN Archive Date: 08/27/2008

Time Series Reporting Stored Procedure - part 1 of 3

Many people have been asking for complete coding samples involving data mining.  Also, many...

Author: MSDN Archive Date: 08/26/2008

Data Mining in the Cloud

In case the title of my last post wasn't provocative enough, I'll post it again! Here's an excerpt...

Author: MSDN Archive Date: 08/25/2008

KDD 2008 and Incredibly Awesome SQL 2008 Data Mining Demos

Bogdan and Raman are currently outside of Las Vegas at the KDD 2008 (Knowledge Discovery and Data...

Author: MSDN Archive Date: 08/25/2008

Data Mining Addins on Channel 9

Wee Hyong, a SQL Server MVP in Singapore discusses with Channel 9 how he improved the event...

Author: MSDN Archive Date: 06/03/2008

Data Mining Case Studies

As I'm in the mood for finally responding to frequent requests, here is a list of case studies...

Author: MSDN Archive Date: 06/03/2008

FREE Data Mining training by Rafal Lukawiecki

Many people ask me fore pointers to data mining and this fell into my lap over the past few...

Author: MSDN Archive Date: 06/03/2008

Visual Numerics integration into SQL Server Data Mining

Our friends at Visual Numerics, Inc have created an excellent white paper covering the creation of...

Author: MSDN Archive Date: 05/29/2008

What's a book without a cover - redux

Three years ago next month I posted on our first book and now we can peek at what's to come! I guess...

Author: MSDN Archive Date: 04/21/2008

Screencasts, more screencasts, plus some scripts.

Oddly enough, this week was a banner week for data mining screencast references. I took some...

Author: MSDN Archive Date: 03/14/2008

"Supercrunchers" and Microsoft Data Mining

Ian Ayres, Yale Law school professor and author of SuperCrunchers, talks about data driven decisions...

Author: MSDN Archive Date: 03/12/2008

Unwinding MDX Flattening Semantics with DMX

When issuing an MDX statement in code, you have the option of requesting either a multidimensional...

Author: MSDN Archive Date: 03/10/2008

A data mining survey

Karl Rexer of Rexer analytics has taken up a hobby of implementing a somewhat unscientific survey of...

Author: MSDN Archive Date: 03/04/2008

Silverlight Viewers, Data Mining Road Show, and TechEd

A enthusiast in China took a suggestion all the way and has implemented at least a decision tree...

Author: MSDN Archive Date: 02/22/2008

DMX Queries - the DataSource hole

So many people have told me how much they like DMX - the fact that they can use a query language to...

Author: MSDN Archive Date: 02/03/2008

To (a) or not to (a), that is the question?

While looking for content for the next edition of my book (newsflash! I'm currently working on the...

Author: MSDN Archive Date: 01/14/2008

Tools Can Be So Much Fun PLUS Cluster Accuracy

For a project I was working on I had to create a lot of models and extract one piece of information...

Author: MSDN Archive Date: 12/05/2007

New Server at SQLServerDataMining.com

After three years the data mining team has upgraded the server for SQLServerDataMining.com. ...

Author: MSDN Archive Date: 11/28/2007

How can we mine? Let me count the ways...

Recently I received some customer feedback that SQL Server Data Mining "doesn't have enough...

Author: MSDN Archive Date: 11/19/2007

New DM Team Blog

Bogdan Crivat - whom many of you know from sqlserverdatamining.com and the DM Forums has started his...

Author: MSDN Archive Date: 11/19/2007

Test post from Windows Live Writer

This isn't really a post, but since these giant blue and green guys showed up on campus, I figured I...

Author: MSDN Archive Date: 11/09/2007

New Time Series Features for SQL Server 2008

The time series algorithm has had some major changes for SQL Server 2008. We've ramped up the...

Author: MSDN Archive Date: 10/22/2007

Preview the Model Documentation feature of the next version of the Data Mining Client for Excel

The attached document has a preview of the output of a new "Model Documentation" feature for our...

Author: MSDN Archive Date: 10/19/2007

SQL Server 2008 and Analysis Services DMV's

One of the cool new features coming in SQL Server 2008 Analysis Services are Dynamic Management...

Author: MSDN Archive Date: 09/21/2007

Data Mining Virtual Hands-on Lab Now Available! Also, in other news, Donald in a fishbowl!

For those of you who have been dying to try out the data mining addins we released earlier this year...

Author: MSDN Archive Date: 07/23/2007

BIDS Helper available on CodePlex

Furmanng posted a set of utilities to CodePlex that help your OLAP development called BidsHelper....

Author: MSDN Archive Date: 05/16/2007

New DMX Syntax option in SQL Server SP2

Quite a while back I promised to tell everyone about the subtle new feature in DMX in SQL Server...

Author: MSDN Archive Date: 04/25/2007

Important Update for the Data Mining Addins!

Due to a late found performance regression we decided to rerelease the data mining addins. A change...

Author: MSDN Archive Date: 03/22/2007

Tree Utilities in Analysis Services Stored Procedures

This past week I was helping out a customer that wanted to reduce the length of a questionairre by...

Author: MSDN Archive Date: 03/02/2007

Social Network Analysis with SQL Server 2005 Data Mining

A few years ago John Hancock spent some time with our team and did some interesting work around...

Author: MSDN Archive Date: 02/26/2007

Automatically Label Clusters using Analysis Services Stored Procedures

I just found this awesome posting on CodePlex by furmangg to automatically label the clusters...

Author: MSDN Archive Date: 02/21/2007

Data Mining Addins Released to Web!

The SQL Server 2005 Data Mining Add-ins for Office 2007 have finally released to web yesterday along...

Author: MSDN Archive Date: 02/20/2007

Predictive Traffic Analytics with SQL Server 2005

Inrix is a company that uses data mining is a very interesting way - they combine department of...

Author: MSDN Archive Date: 02/14/2007

Next>