We do a lot of SQL Server programming where I work. I'm using SQL Server Management Studio 2008, which is nice, but I just made it much nicer by installing Mladen Prajdic’s SSMS Tools Pack (
http://ssmstoolspack.com/). The features I've discovered so far are:
- color coding the editor by connection (so you have a visual cue that you're connected to production versus QA versus your development DB)
- auto-formatting
- snippets
- New Query templates (so you always start with a Begin Tran)
I like this quite a bit.