Social Network Analysis with SQL Server 2005 Data Mining
A few years ago John Hancock spent some time with our team and did some interesting work around using the Association Rules algorithm and some custom Analysis Services stored procedures to implement link analysis (a.k.a. social network analysis). His implementaion was extremely novel, and the product team (self included) was duly impressed by what John was able to eek out of our system.
Well, as he puts it himself he "finally got around to posting" all the source, etc. for this work for the enlightenment of everyone!
I'm happy to hear of (and promote!) any other slick projects using SSDM that you want to share!