Interesting discussion on intellisense and T-SQL
http://blogs.msdn.com/anthonybloesch/archive/2005/09/26/TSQL_intellisense.aspx
I've been meaning post about this, but haven't really had the chance until now. I'm pretty glad I waited because of this comment about the post made by Dave Russell:
It looks to me like MS are going away from "most" developers having to hand-code TSQL anyway. They're introducing LINQ/DLINQ which gives you language constructs that ultimately map to SQL and, supposedly, optimised SQL much better than you or I would imagine. These do have intellisense, so TSQL intellisense suddenly becomes much less important in their eyes...... I wouldn't expect it in SQL-Server-Next either.
Prophetic on LINQ, I think. But I do believe we will see at least some level of Intellisense in future versions of SQL Server.