Extending Analytical Capabilities of SQL Server with SPSS

For those of you who still want more from SQL BI, you can now download the SPSS Statistical Services for Microsoft SQL Server 2005 Preview which adds statistical analyses to the BI Dev Studio and some custom transforms to SQL Server Integration Services.  Pretty cool – check it out


Two similar but different resources now available

There are two new resources available for writing custom algorithms for SQL Server Data Mining “Add Custom Data Mining Algorithms to SQL Server 2005” by our own Raman Iyer, provides an overview of the plug-in process, what you do and what you get, along with links to more technical resources. Implementing Data Mining Algorithms in…


Code from book and new XMLA template at SSDM

I just added a couple of new downloads on SQLServerDataMining.com The first is the sample from chapter 16 (Forecasting in Excel) of my book, Data Mining with SQL Server 2005 which was misposted on the publisher’s site (it will be updated there as well, but it’s at SSDM for those of you who want it…


One year anniversary for SQLServerDataMining.com!

Not only is October the RTM month for SQL Server – it is also the one-year anniversary for SQLServerDataMining.  We now have over 3100 registered mambers from over 32000 distinct IP’s all over the world.  To celebrate we’ve added the live sample “The Art of Clustering” which allows you to create pretty pictures with the…


Updated sample viewer for Sept CTP and RTM

A couple people found that the sample plug-in viewer I posted on SQLServerDataMining.com didn’t install on the September CTP or later builds (although it continued to work if already installed).  I posted a new version that installs correctly with the newer builds. If you want it soon, grab it right away, we’re taking the site…


It shipped!!! It shipped!! It shipped!!

No, no, no – not Yukon! (launch date Nov 7) Our book!  I just checked Amazon and it has those now famous words “Usually available within 24 hours.”  You can download the companion material directly from Wiley    


On PASS, PDC and new Downloadable Demos

I’ve just finished uploading some new demos that I’ve shown at PDC and PASS.  Both of these demos show how to use VBA to integrate data mining functionality into Excel.  Their pretty cool – you should check them out.  Bogdan wrote the DMPredict function and I wrote the clustering sample. As I’m writing this PASS…


Finally – more memory!

We finally upgraded the memory of http://www.sqlserverdatamining.com – the system was running live applications on SQL Server, Analysis Services, Reporting Services, and IIS with ASP.NET all with 512 MB of memory.  Now that the system has a bit more room you shouldn’t get as many of those annoying timeouts! Since we’ve upgraded the system, we…


New Vendors page on SQLServerDataMining

If you’re looking for companies that can help you out with data mining for SQL Server 2005, I added a vendor’s page on SSDM.  Currently there’s three SI’s from three different locations around the globe and SPSS that has a downloadable beta working with the June CTP release. If you’re a vendor working with SSDM…