Jamie's Junk

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

  • Jamie's Junk

    Data Mining with SQL Server 2008

    • 3 Comments
    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...
  • Jamie's Junk

    More Data Mining in the Cloud?

    • 3 Comments
    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...
  • Jamie's Junk

    Data Mining Addins Released to Web!

    • 2 Comments
    The SQL Server 2005 Data Mining Add-ins for Office 2007 have finally released to web yesterday along with SP2 of SQL Server 2005. The DM team has done a great write-up on how to get the add-ins (and everything else necessary) and also a really nice whitepaper...
  • Jamie's Junk

    Those kids won't eat anything!

    • 1 Comments
    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...
  • Jamie's Junk

    Happy New Year with a big bang!

    • 0 Comments
    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...
  • Jamie's Junk

    SQL Server 2008 and Analysis Services DMV's

    • 2 Comments
    One of the cool new features coming in SQL Server 2008 Analysis Services are Dynamic Management Views (DMV). Actually I never thought of them as DMVs coming from my background, but since everyone else calls them that, there's no reason we shouldn't either...
  • Jamie's Junk

    In Germany this April?

    • 1 Comments
    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...
  • Jamie's Junk

    Querying the Dependency Net

    • 1 Comments
    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...
  • Jamie's Junk

    New Time Series Features for SQL Server 2008

    • 1 Comments
    The time series algorithm has had some major changes for SQL Server 2008. We've ramped up the algorithm and added prediction against new data. While the new data prediction is just as cool as the algorithm changes, I'll have to save that for later - this...
  • Jamie's Junk

    Wisconsin Breast Cancer Dataset available

    • 0 Comments
    Frequently I use the Wisconsin Breast Cancer Dataset for demonstrating the Data Mining Addins for Office - enough people asked, so I made it available as an Excel 2007 file (free login required). For purists, the original data is available at the Machine...
  • Jamie's Junk

    Getting Data Mining results into SQL Tables

    • 1 Comments
    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...
  • Jamie's Junk

    FREE Data Mining training by Rafal Lukawiecki

    • 5 Comments
    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...
  • Jamie's Junk

    The amazing flexibility of DMX Table Valued Parameters

    • 0 Comments
    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...
  • Jamie's Junk

    Data Mining Case Studies

    • 1 Comments
    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...
  • Jamie's Junk

    KDD 2008 and Incredibly Awesome SQL 2008 Data Mining Demos

    • 4 Comments
    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...
  • Jamie's Junk

    Time Series Reporting Stored Procedure - part 3 of 3

    • 2 Comments
    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...
  • Jamie's Junk

    Data Mining Addins on Channel 9

    • 1 Comments
    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...
  • Jamie's Junk

    Support Vector Machines for SQL Server Data Mining

    • 1 Comments
    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...
  • Jamie's Junk

    Data Mining in SQL Server 2008 Book Review

    • 1 Comments
    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!)...
  • Jamie's Junk

    Time Series Reporting Stored Procedure - part 1 of 3

    • 1 Comments
    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...
  • Jamie's Junk

    Time Series Reporting Stored Procedure - part 2 of 3

    • 2 Comments
    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...
  • Jamie's Junk

    Unwinding MDX Flattening Semantics with DMX

    • 3 Comments
    When issuing an MDX statement in code, you have the option of requesting either a multidimensional set or a relational rowset as the result set. If you are familiar with MDX and multidimensional concepts, the multidimensional result is the obvious choice...
  • Jamie's Junk

    Querying like the Data Mining viewers do

    • 1 Comments
    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...
  • Jamie's Junk

    Tree Rendering with Reporting Services - my BI Power Hour Demo

    • 1 Comments
    This is the end result of the report I created in under 10 minutes during the BI Power Hour at TechEd 2006. It uses a matrix report and takes advantage of the parent-child nature of data mining content to render the hierarchy. The .rdl file for...
  • Jamie's Junk

    Standard and Enterprise Data Mining

    • 0 Comments
    This post could be a theoretical piece about the true meaining of "Enterprise Data Mining", but no, it's much more practical than that. As many of you know, Microsoft has released a grid indicating the differences between the various editions of SQL Server...
Page 1 of 5 (117 items) 12345