Through this post on Stack Overflow I found an article called My SQL Server Wishlist which has a list of useful enhancements to SQL Server, along with links to their Microsoft Connect entries.
You can also see this article as a list of shortcomings or pitfalls for unexperienced MSSQL / TSQL developers.
Some of these entries, of course, have never been answered or commented on by MS, which makes me wonder.