I haven't posted for a while (please forgive me) as I've been quite busy over the past few weeks.  I should really try to post more frequently.  Anyway, I am not going to talk about Microsoft software but instead talk about the release of SQL Prompt 3 from Red Gate http://www.red-gate.com/products/SQL_Prompt/index.htm.  I recently received the 'we have a new version' email so decided to take a look and I must say it is looking good. The metadata look-up performance is certainly better than version 2. 

I'm also quite interested in the SQL Refactor tool http://www.red-gate.com/products/SQL_Refactor/index.htm which is also available from Red Gate.  The T-SQL formatter 'Lay Out SQL' option is something I've been looking for ever since I saw something similiar in Toad Formatter Plus for Oracle.