Mining data with Microsoft 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.


Recommended Reading

Comments Icon4 comments found on “Mining data with Microsoft SQL Server

  1. 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

  2. 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

  3. 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.

  4. 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!

Comments are closed.