Jamie's Junk

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

  • 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

    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

    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

    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

    DMX Queries - the DataSource hole

    • 3 Comments
    So many people have told me how much they like DMX - the fact that they can use a query language to create, train, and query mining models is simply unprecedented in the data mining world. And they love it. Until..... Until, that is, they decide...
  • 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

    Data Mining Virtual Hands-on Lab Now Available! Also, in other news, Donald in a fishbowl!

    • 2 Comments
    For those of you who have been dying to try out the data mining addins we released earlier this year - here's your chance! Ok, scratch that, if you're reading my blog you've been there done that, but if there's that someone special who you know would...
  • 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

    Preview the Model Documentation feature of the next version of the Data Mining Client for Excel

    • 2 Comments
    The attached document has a preview of the output of a new "Model Documentation" feature for our next version of the data mining addins. You just click on a button, select a model and recieve a report containing (hopefully) interesting and pertinent information...
  • Jamie's Junk

    Your chance to see the Data Mining Office Addins for yourself!

    • 2 Comments
    I was happily surprised at the reception of the Addins at my presentation at PASS in Seattle yesterday - one report was that the audience was "drooling". If you're one that just couldn't make it to Seattle this week - no sweat! I will be presenting the...
  • Jamie's Junk

    A Data Mining Web Log

    • 2 Comments
    This is to be my WebLog which I have been putting off writing for quite some time. Now that we are getting closer to Beta 3 of SQL Server 2005 it seems more appropriate to get started as what I'm working on and talking about will have more relevance since...
  • Jamie's Junk

    Bugs bugs bugs in beta beta beta

    • 2 Comments
    You know, we have betas for a reason - to get your feedback and to help us find bugs we've missed that show up in production, or using customer's data, or using the product in ways we didn't envision here at Microsoft. Oft times, I've run into the situation...
  • Jamie's Junk

    BI Training in LA towards the end of June

    • 2 Comments
    MSEvents is hosting a hands-on lab in June where you can learn about BI for IT professionals. From this training (according to their site) you will learn how to create An Analysis Services cube A SQL Server 2005 Integration Services package SQL...
  • 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 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

    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

    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

    BIDS Helper available on CodePlex

    • 1 Comments
    Furmanng posted a set of utilities to CodePlex that help your OLAP development called BidsHelper . The features are directly integrated into BI Development Studio in toolbars and menus inside the Analysis Services designers. It currently has an aggregation...
  • Jamie's Junk

    "Supercrunchers" and Microsoft Data Mining

    • 1 Comments
    Ian Ayres, Yale Law school professor and author of SuperCrunchers , talks about data driven decisions and the Data Mining Addins in this Gartner podcast . He also mentions some other company, but we won't talk about them :) Give it a listen!
  • Jamie's Junk

    Screencasts, more screencasts, plus some scripts.

    • 1 Comments
    Oddly enough, this week was a banner week for data mining screencast references. I took some internal strategy training, and was asked by several attendees for links to the screencasts that I made (on the download page ) and received two (maybe three...
  • Jamie's Junk

    What's a book without a cover - redux

    • 1 Comments
    Three years ago next month I posted on our first book and now we can peek at what's to come! I guess with the price of gas, Wiley decided that black gold was more interesting than the yellow stuff.  Readers of the last edition will notice a new addition...
  • 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...
  • 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

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