I like that SQL 2008 has Intellisense, but there are some quirks to it I don't likeneed to get used to,  namely capitalization. Take the following example:

If I want to use the Users table, I would normally hit the space bar. In this instance, however, Intellisense will finish the usersessionlist. Yes, C# works the same way. And yes, it will make me a better coder to actually use Users (which Intellisense interprets correctly) but there is a lot of legacy code that has no casing rhyme or reason to it and it will take some time to get used to typing correctly in SQL.

Ah well, lazy coding practices need banished.