blog spam

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:

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.


Leave a comment

Your email address will not be published. Required fields are marked *