Unearth the New Data Mining Features of Analysis Services 2005

Unearth the New Data Mining Features of Analysis Services 2005 is a writeup on the data mining features in the upcoming beta 2 of SQL Server 2005 (formerly formally named and still referred to as Yukon). Has a couple of screenshots and some explanations of the extensions to the little-used "DMX", or Data Mining Extensions for SQL, which allows you to query Data Mining Models for results.

Here's an example of what a DMX statement looks like:

SELECT NewCustomers.CustID, PredictProbability(Churned, True)
FROM CustomerChurn NATURAL PREDICTION JOIN
OPENQUERY ('My Datasource', 'SELECT * FROM NewCustomers') AS
NewCustomers
SELECT * FROM CustomerChurn.CONTENT

Looks like there's alot of great tools coming up in SQL Server, time will tell if they deliver the goods.