For what it's worth, I'm pretty sure these were compiled into a GitHub repo here: https://github.com/red-gate/SQL-code-smells

And for those using SSDT, Dave Bally wrote an add-in here:

https://github.com/davebally/TSQL-Smells

(Note that the add-in could use some tweaking to get it working w/ other versions of SSDT:

dataidol.com/davebally/2015/03/23/getting-out-of-the-ground-with-tsql-smells/