Testing custom SpamAssassin rules As I was writing and testing my custom SpamAssassin rules, I often tried to figure out how to make sure my rule was running in production. I could easily test it locally by using the SpamAssassin command-line. But for production, I couldn’t use the command line. Perhaps there is a better way, but I...

SharePoint calculated fields reference If you ever use calculated fields (a.k.a. calculated columns) in SharePoint 2007 (WSS 3.0), there is an excellent set of examples from Microsoft WSS 2.0. There is also a newer set of examples for WSS 3.0, but they haven’t deprecated any of the formulas, so everything still applies. Update: I also...

Easy multi-value parameters in SQL Server Reporting Services I recently came across an application where I needed to use a multi-value parameter in SQL Server Reporting Services (SSRS).  I always seemed to have trouble with these in the past.  This time I found them very easy to use because I found (re-discovered?) a simple way. The basic idea is to set up a...

CAML queries, SSRS, and datetime fields I’ve been using Enesys Software’s product RS Data Extension to query data out of SharePoint 2007 lists in SQL Server (2005) Reporting Services.  One quirk with the queries is that they use CAML and the dates must be in a particular format, ISO8601. I wanted users to use the standard date-picker,...