<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://www2.sqlblog.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx</link><description>Here on SQLblog, we take spam seriously. Actually, I should rephrase that: I take spam really, really, really seriously, some other people take spam somewhat seriously, and some don't really seem to care. It all balances out in the end. We've done a pretty</description><dc:language>en</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20027</link><pubDate>Wed, 16 Dec 2009 17:05:25 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20027</guid><dc:creator>mjswart</dc:creator><description>&lt;p&gt;Very a propos. About an hour ago I wrote a post on the topic of learning from failures. &lt;a rel="nofollow" target="_new" href="http://michaeljswart.com/?p=340"&gt;http://michaeljswart.com/?p=340&lt;/a&gt;&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20028</link><pubDate>Wed, 16 Dec 2009 17:10:19 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20028</guid><dc:creator>AaronBertrand</dc:creator><description>&lt;p&gt;Adam, do you know how to stop the topsy crap? &amp;nbsp;I get a comment from topsy on every post, &amp;quot;this post was mentioned on twitter...&amp;quot;&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20029</link><pubDate>Wed, 16 Dec 2009 17:40:15 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20029</guid><dc:creator>Adam Machanic</dc:creator><description>&lt;p&gt;Michael, glad you enjoyed the post. Yours is one of the accounts I killed :-)&lt;/p&gt;
&lt;p&gt;Aaron, I've allowed that topsy stuff (in addition to ubervu) to come through since just before it started I'd had requests for &amp;quot;tweetback&amp;quot; support on the site and that's what it seems to provide. Do you consider it to be spam? I can certainly reevaluate...&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20032</link><pubDate>Wed, 16 Dec 2009 18:29:38 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20032</guid><dc:creator>AaronBertrand</dc:creator><description>&lt;p&gt;I can see how some would see value in it, but I don't really.&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20034</link><pubDate>Wed, 16 Dec 2009 19:31:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20034</guid><dc:creator>Michael K. Campbell</dc:creator><description>&lt;p&gt;You guys need to give ReverseDOS a try. &lt;/p&gt;
&lt;p&gt;It's a simple HTTP Module for ASP.NET sites and uses filters to let you flag/trap spammy crap (patterns via plain text or regex). When it finds a matching result (or spammy comment) it lies to the bot pushing the spam up and tells it that it's 'processing' the request... for about a minute or so (you can configure the time as needed) then it throws a 503 - Server Busy. Other users on your site won't see anything out of the ordinary. But you'll end up:&lt;/p&gt;
&lt;p&gt;a) stopping the spam from going into your DB&lt;/p&gt;
&lt;p&gt;b) slowing the BOT down. &lt;/p&gt;
&lt;p&gt;I've found that most bots (or their owners) notice that you're slowing their bots down significantly, and start to leave you alone after a while. &lt;/p&gt;
&lt;p&gt;RDOS is designed to TRUST content from authenticated or logged-in users, but it shouldn't be too hard to turn that functionality off. (Let me know if you need a hand with that.)&lt;/p&gt;
&lt;p&gt;&lt;a rel="nofollow" target="_new" href="http://www.angrypets.com/tools/rdos/"&gt;http://www.angrypets.com/tools/rdos/&lt;/a&gt;&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20036</link><pubDate>Wed, 16 Dec 2009 20:26:13 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20036</guid><dc:creator>andyleonard</dc:creator><description>&lt;p&gt; &amp;nbsp; Adam: That's pretty harsh. I mean, I try to sell a few wireframe Christmas trees and you lock me out!&lt;/p&gt;
&lt;p&gt; &amp;nbsp; Aaron: I moderate comments. That caught a lot of the stuff I used to get.&lt;/p&gt;
&lt;p&gt;:{&amp;gt; Andy&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20037</link><pubDate>Wed, 16 Dec 2009 20:50:32 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20037</guid><dc:creator>Adam Machanic</dc:creator><description>&lt;p&gt;Michael: We're already running it :-) ... it's certainly saved us from a lot of stuff, but not everything.&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20046</link><pubDate>Wed, 16 Dec 2009 23:51:45 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20046</guid><dc:creator>AaronBertrand</dc:creator><description>&lt;p&gt;Andy, &lt;/p&gt;
&lt;p&gt;YMMV, but I don't like the idea of moderating comments. &amp;nbsp;It means that I have to &amp;quot;okay&amp;quot; the conversations of others and that they can't carry on in my absence. &amp;nbsp;Since there are many occasions in a given month where I don't visit the site for a week or more, I certainly would rather let a few crap comments get in than stifle discussions altogether.&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20052</link><pubDate>Thu, 17 Dec 2009 04:03:49 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20052</guid><dc:creator>Jimmy May, Aspiring Geek</dc:creator><description>&lt;p&gt;Adam, I'm sympathetic, applaud your efforts, &amp;amp; am proud of your mea culpas.&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20061</link><pubDate>Thu, 17 Dec 2009 14:52:05 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20061</guid><dc:creator>Brian Tkatch</dc:creator><description>&lt;p&gt;Adam, good story, and nice that you posted in. It's good to know you are a real person. :)&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20211</link><pubDate>Wed, 23 Dec 2009 22:40:31 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20211</guid><dc:creator>KKline</dc:creator><description>&lt;p&gt;Great post, Adam. &amp;nbsp;I especially appreciate that it probably took you as long to write the informative article as it did to write your initial scripts or run your recovery. &amp;nbsp;It takes time to instruct others, so you've done the community a services.&lt;/p&gt;
&lt;p&gt;I don't moderate comments, incidentally, but I've got alarms set whenever they come in and, when appropriate, delete them.&lt;/p&gt;
</description></item><item><title>re: Spam Fighting and Lessons Learned</title><link>http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/16/spam-fighting-and-lessons-learned.aspx#20352</link><pubDate>Wed, 30 Dec 2009 07:32:07 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:20352</guid><dc:creator>Web Design Company</dc:creator><description>&lt;p&gt;Excellent post Adam.I really appreciate your effort. &lt;/p&gt;
</description></item></channel></rss>