Scott Hanselman's Computer Zen - Scott Hanselman's 200. Suite and PortableApps.com Platform. The Best-ever Freeware Utilities List. Free SQL Server tools that might make your life a little easier. Update: New Stuff from the latest update will be in RED.
This list will grow as I find new tools. So if you know of some not on this list do post them in the comments. SQL Server Management Studio Add-in's SSMS Tools Pack - an add-in with lots of IDE options (Query Execution history, regions, debug sections, CRUD stored procedures creation, new query templates, running custom scripts from Object explorer's context menu) for SQL Server Management Studio and SQL Server Management Studio Express.