SQL Prompt by Red Gate Software looks like a very neat utility. It uses intellisense auto-complete to help you finish sections of SQL statements that you might be writing. Being only 80% fluent in SQL syntax like 99% of all SQL syntax writers this sort of help is very useful. Not only does it provide accurate completion of a sentence, more importantly it teaches you correct syntax the first time you type and thereby naturally enforces learning by repetition.
I haven't tried it yet but was sufficiently impressed to blog it though.