Great article, Andy - thanks. Can I just ask a question about Tip#4?
If you want to really make sure no resultsets occur you can use spconfigure to set disallow results from triggers to off.
Is this a typo and did you mean to say "on"? Also, if you do this, you'll get an error message every time a trigger tries to return a result set and so you'd need to add some error-handling code to your trigger and/or application.