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...
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...
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...
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...
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...
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...
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...
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...
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....
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 03/14/2008
"Supercrunchers" and Microsoft Data Mining
Ian Ayres, Yale Law school professor and author of SuperCrunchers, talks about data driven decisions...
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...
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...
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...
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...
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...
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...
Date: 12/05/2007
New Server at SQLServerDataMining.com
After three years the data mining team has upgraded the server for SQLServerDataMining.com. ...
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...
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...
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...
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...
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...
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...
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...
Date: 07/23/2007
BIDS Helper available on CodePlex
Furmanng posted a set of utilities to CodePlex that help your OLAP development called BidsHelper....
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...
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...
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...
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...
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...
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...
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...
Date: 02/14/2007