Mining data with Microsoft SQL Server

November 16, 2006 by
Filed under: SQL Server 

I have recently discussed with people working at Microsoft. Unfortunately, they are not doing data mining or machine learning research in Switzerland. I think that everything concerning research is in Redmond. I suppose that they are involved in data mining for at least two reasons: MSN Search and Microsoft SQL Server. The website IT-director has an article concerning SQL Server. According to its author, David Norris, data mining services in SQL Server are very interesting. He writes that “what Microsoft has done is to make data mining available on the desktop to everyone“. However, no details are given in his article about data mining techniques used. Although I have never used SQL Server, I suspect that it is more about data analysis than really data mining.



4 Comments on Mining data with Microsoft SQL Server

  1. Jamie MacLennan on Fri, 17th Nov 2006 8:51 pm
  2. Actually SQL Server has a full data mining suite with nine algorithms, model building tools, viewers plus integration with OLAP, Reporting and the ETL pipeline – not to mention a fully fledged programming model that is “easy” to use – i.e. language looks like SQL, API is .Net friendly and also accessible as a web service. You can get more details at

  3. Sandro Saitta on Sat, 18th Nov 2006 6:06 pm
  4. Thanks for the comment Jamie. It seems I have underestimated SQL Server possibilities. Here are the nine proposed techniques:

    Decision Trees
    Time Series
    Association Rules
    Sequence Clustering
    Naive Bayes
    Neural Network
    Linear Regression
    Logistic Regression

  5. Kevin Schofield on Sun, 19th Nov 2006 12:44 am
  6. And actually, Microsoft Research has labs in five locations: Redmond, Cambridge UK, Beijing, Silicon Valley, and Bangalore.

    We do research related to machine learning, applied statistics, and data mining in several of them.

  7. Sandro Saitta on Mon, 20th Nov 2006 2:05 pm
  8. The guy from Microsoft Switzerland was telling me that all research was certainly in Redmond… good to know that it’s not exactly the case. Thanks!

Tell me what you're thinking...

  • Swiss Association for Analytics

  • Most Popular Posts

  • T-shirts, Mugs & Mousepads

    All benefits given to a charity association
  • Archives

  • Visitors