Follow @RoyOsherove on Twitter

SqlAssist is to VS SQL text as CodeSmart is to VB 6 code - Wonderful

Wow, what a cool addin for VS 2005 to add Intellisense to your SQL queries!
Check out SqlAssist [via Hannes]
Best of all - it's in beta testing and is free to download!
some of the coolest features:
  • Intellisense for tables, columns  and variables. works on temp tables and aliases just as well
  • Code formatting with changeable rules
  • Templates (like snippets) of SQL code with shortcut macros
  • Char completion - automatically closes '(', single quotes etc. even on selected text
  • Has an object explorer just like the SQL analyzer you know and love, complete with "Script to" ability.
  • Works in VS 2003 and VS 2005

Ask The Pros - Keyboard Shortcut Junkies (and some extra shortcuts from me)

Google upgrades to "BigDaddy"