A quick list of relevant [to me] tools as they relate to working on or around SQL Server for maintenance and development.

• The folks at xSQL Software produce great tools that work without too much flash, although some DO have “all the bells and whistles”.  Go ahead and download their free offerings here.
• SSMS Tool Pack.  Dude, dude, dude… what can I say… phenomenal (and after a month of using them, indispensable) add on to SSMS 2005 on…  There is some code gen goodness there, some “refactoring”, snippets, debugging capability, etc... I can’t see how you wouldn’t be able to find a good use for this add on if you are a somewhat “daily” SQL Server and SSMS user.
• SQLMonitoring Tool.  Available on Codeplex.
• SSIS Community Tasks and Components.  Available on Codeplex.
• SQL Search from RedGate software.  I’ve blogged about it before here.  It has to make this list though… I use it pretty much “daily”.
• [UPDATE] The MEGA Guide to Free SQL Tools

An additional not on the offerings from xSQL Software: For those that are not free, the cost of their software is WAY less that their value.  You can’t go wrong.  I am a user of their tools, more specifically their Script Executor Community Edition which has saved me hours of frustrating, repetitive and manual work.  (Review to follow soon).