Jamie's Junk

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

  • 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

    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

    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

    New Cloud Data Mining Addin Usability Feature (well kind of)

    • 1 Comments
    Bogdan did an awesome job putting together the modified Data Mining Addin for the cloud. We saw quite a few downloads of his new addin, but surprisingly and unfortunately, didn't see a lot of usage! Strange? Maybe. Bogdan thought about the issue for a...
  • 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

    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

    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

    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

    Time's running out for your free data mining book!

    • 1 Comments
    The survey is now closed. Thank you. Tomorrow is the last day you can fill out this survey for a chance to win one of ten copies of Data Mining with SQL Server 2008 . I used the the Data Exploration tool in the SQL Server 2008 Data Mining Client for...
  • Jamie's Junk

    See me at PASS in Seattle next week

    • 1 Comments
    I'll be at the PASS 2008 conference in Seattle most of next week.  Currently (subject to change) I'll be presenting at the BI Power Hour on Wednesday at 1:45 and will be in the Ask the Experts area on Wednesday after the Power Hour session and Thursday...
  • Jamie's Junk

    Get a FREE AUTOGRAPHED copy of Data Mining with SQL Server 2008

    • 1 Comments
    The survey is now closed. Thank you I checked on Amazon today and Data Mining with SQL Server 2008 is finally in stock! However, if you are currently using SQL Server Data Mining, before you rush out and buy a copy, please take this opportunity...
  • Jamie's Junk

    Time Series Reporting Stored Procedure - Part 4 of 3

    • 0 Comments
    OK, OK, I know it's just not right to do a part 4 of a three part series , but I've gotten enough demand to expand these stored procedures just a little bit. I casually left out a class of time series models that contain nested tables since it made things...
  • 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

    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

    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

    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

    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

    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

    Data Mining in the Cloud

    • 1 Comments
    In case the title of my last post wasn't provocative enough, I'll post it again! Here's an excerpt "access the Table Analysis Tools for Excel 2007 by connecting to our hosted data mining service"... If you don't want to read the long-winded post 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

    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

    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

    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

    Visual Numerics integration into SQL Server Data Mining

    • 1 Comments
    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...
Page 1 of 5 (117 items) 12345