Jamie's Junk

I've been asked this question a few times and never thought of an answer until I was asked again today on the data mining newsgroups. We'll be posting a tip or trick on sqlserverdatamining.com on this, but since it's fresh in my mind I'll let everyone...

I noticed through answering newsgroup and forum posts that we always want to know model definitions when discussing a problem. Luckily we have this great language called DMX that makes it very easy and simple to describe a model. Unluckily, our tools...

Zulfiqar Syed has taken on the challenge of learning everything there is to know about SQL Server Data Mining and his sharing his experiences with the world - it's really good reading, and uncovers a bunch of the stuff we took for granted or just missed...

Watch this channel 9 video on MSN Search. They talk a bunch about data mining in general and indicate that they are using SQL Server 2005 Data Mining at about 14 minutes.

Just found this great article on MSDN showing how to use session Time Series models in RS to forecast while generating a report. Cool beans!

As the tumbleweeds drift through my lonely blog I decided to visit here again before the wake of progress reclaims these lost bits into oblivion. It's been interesting lately seeing the uptake of data mining throughout our customer and partner base -...

For those of you who still want more from SQL BI, you can now download the SPSS Statistical Services for Microsoft SQL Server 2005 Preview which adds statistical analyses to the BI Dev Studio and some custom transforms to SQL Server Integration Services...

There are two new resources available for writing custom algorithms for SQL Server Data Mining " Add Custom Data Mining Algorithms to SQL Server 2005 " by our own Raman Iyer, provides an overview of the plug-in process, what you do and what you get...

I just added a couple of new downloads on SQLServerDataMining.com The first is the sample from chapter 16 (Forecasting in Excel) of my book, Data Mining with SQL Server 2005 which was misposted on the publisher's site (it will be updated there as well...

This article is an interesting short read about the collaboration between my team and MSR (plus some others as well).

Not only is October the RTM month for SQL Server - it is also the one-year anniversary for SQLServerDataMining . We now have over 3100 registered mambers from over 32000 distinct IP's all over the world. To celebrate we've added the live sample " The...

A couple people found that the sample plug-in viewer I posted on SQLServerDataMining.com didn't install on the September CTP or later builds (although it continued to work if already installed). I posted a new version that installs correctly with the...

No, no, no - not Yukon! (launch date Nov 7) Our book! I just checked Amazon and it has those now famous words "Usually available within 24 hours." You can download the companion material directly from Wiley

I've just finished uploading some new demos that I've shown at PDC and PASS. Both of these demos show how to use VBA to integrate data mining functionality into Excel. Their pretty cool - you should check them out. Bogdan wrote the DMPredict function...

We finally upgraded the memory of http://www.sqlserverdatamining.com - the system was running live applications on SQL Server, Analysis Services, Reporting Services, and IIS with ASP.NET all with 512 MB of memory. Now that the system has a bit more room...

If you're looking for companies that can help you out with data mining for SQL Server 2005, I added a vendor's page on SSDM. Currently there's three SI's from three different locations around the globe and SPSS that has a downloadable beta working with...

I found that not all of the data mining webcasts are listed under BI - some are a bit scattered. To make it easier to find them so you can have a Data Mining Webcast marathon and do your best MST 3000 imitations, I added a Webcasts section to SQLServerDataMining...

I just watched the MSDN TV episode I did on Data Mining and I'm less embarassed than I thought I would be... [:D] If you've watched any of the data mining webcasts it's old hat, but if you haven't it's a good teaser to get you started - after which...

I updated the DataMiningViewerClient sample on the downloads section of www.sqlserverdatamining.com . This sample demonstrates how to host the data mining viewers from SQL Server 2005 in your own applications, and allows you to view models side-by-side...

I just saw Euan Garden's video of me from TechEd Orlando this year - you can watch it streaming here - or for the true collector, you can download and save the video here .

Those of you who read my blog likely know that our site went down again (not because I said so, but because there's a high correlation between people who read my blog and visit sqlserverdatamining.com) This time the reason was a bit more benign - in moving...

I'm in Amsterdam now for TechEd EMEA. Everytime you visit a different country there are lots of little surprises - even if you 've been there before. Take for example yesterday, when I got off the plane. As any one would expect, the first thing you do...

I've kind of gotten out of the blog habit since before TechEd in June. Before TechEd I was disconnected for a week on a "vacation" visiting family for a niece-in-law's graduation. Boy, I could have blogged a lot that week - but only if I could guarantee...

Our publisher has finally released the cover art for my upcoming book (with Zhaohui Tang) "Data Mining in SQL Server 2005" You can pre-order at Amazon - buy 10 copies!

SQL Server Data Mining is still down after a week. We had been using a free hosting service for the site ( a favor from a friend ). However, since I annouced the site last week to over 500 people at the BI Power Hour at TechEd in Orlando, the site's been...