Jamie's Junk

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

Browse by Tags

Tagged Content List
  • Blog Post: 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 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!  Joris Valkonet of Avanade Netherlands along...
  • Blog Post: Visual Numerics integration into SQL Server Data Mining

    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-by-step tutorial demonstrating how to integrate...
  • Blog Post: 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 using data mining to determine which of the 300+ questions were actually necessary for them to get the understanding they required. By using a tree model, and playing with the COMPLEXITY_PENALTY parameter...
  • Blog Post: 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 using the Association Rules algorithm and some custom Analysis Services stored procedures to implement link analysis (a.k.a. social network analysis). His implementaion was extremely novel, and the product...
  • Blog Post: Automatically Label Clusters using Analysis Services Stored Procedures

    I just found this awesome posting on CodePlex by furmangg to automatically label the clusters generated by the clustering algorithm. It examines the cluster content to generate human-readable descriptions and then changes the labels appropriately. Check it out - it might just save you a bunch of time...
  • Blog Post: Direct Links to Data Mining feature pack items

    Many people have asked me for the links to the embeddable viewers and the .NET interfaces for plug-in algorithms. Instead of my usual response, "go to the feature pack page and scroll until you find them", here are the direct links. Enjoy! Data Mining Embeddable Viewers http://www.microsoft.com/downloads...
  • Blog Post: Managed Plug-ins at Last!

    For all those of you who have been waiting and waiting to implement your own data mining algorithms for SQL Server 2005, but didn't want to get into the complexity of writing C++ COM code - it's finally here! The Managed Plug-in API's are available as part of the SQL Server 2005 feature pack . Scroll...
  • Blog Post: Automatic Generation of CREATE MINING MODEL statements

    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 that we use to create models use an XML DDL that is...
  • Blog Post: Two similar but different resources now available

    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, along with links to more technical resources. ...
  • Blog Post: Code from book and new XMLA template at SSDM

    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, but it's at SSDM for those of you who want it...
  • Blog Post: Updated sample viewer for Sept CTP and RTM

    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 newer builds. If you want it soon, grab it right...
  • Blog Post: On PASS, PDC and new Downloadable Demos

    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 and I wrote the clustering sample. As I'm writing...
  • Blog Post: Updated viewer client sample for the June CTP

    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. For the most part, the update involved removing...
  • Blog Post: New data mining sample available

    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 the box to it's new location, the hard drive...
  • Blog Post: Text Mining and AMO in MSDN

    The current issue of MSDN has two data mining articles The first Say What? Make Sense of Your Web Feedback using SQL Server 2005 by Peter Kim takes you through the steps of using SQL Server 2k5 Text Mining and Data Mining to extract information from verbatim comments. The second Mine Your Business...
  • Blog Post: Spam, Viewers, Programming and Press Releases

    I just started a new subscription is Scientific American and my first issue caught me by surprise with this article about spam . David Heckerman, one of the authors, manages the group in Microsoft Research with which we collaborate on the algorithms in SQL Server Data Mining. Another of the authors,...
Page 1 of 1 (16 items)