Speaking of spam, I just checked the blog database to see how my blog spam filter has been working.
11,664 blog spam messages blocked. Holy smokes, that is way more than I thought it would be.
I use a SQL trigger method, which I documented once before on this blog: http://www.coreyh.com/blog/archive/2005/01/25/1349.aspx
I still get maybe one message per week that makes it through the list, and I always find at least one word or url part to add to the “BannedWords” table, just to be sure I never have to delete the same message type twice.