SQL Server 2005 Feature Pack

Posted on Nov 14, 2005

The SQLServer 2005 Feature Pack is freely downloadable and contains a set of useful tools for SQLServer 2005: many items are for compatibility issues (DTS/DSO/DMO backward compatibility), but there are data mining viewer controls and JDBC drivers for J2EE developers. An OLE DB provider for DB2 worths another mention.

This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages. Read more

This article describes how to use the detail rows expression of a measure to obtain the equivalent of creating table functions in DAX. This allows the reusing of a table expression in multiple CALCULATE filters. Read more