I agree with the SSMS requests - especially built-in intellisense and SQL formatting options.
I would also add a request for some visual aids to see how healthy a database is. I know a lot of this depends on circumstances, but it would be neat to hover the cursor over a database server top-level node and see a bar graph or pie chart of used vs. free space on that server's data drive. And if you hover the cursor over a table, show the number of rows in the table. And if a table has an index with greater than a certain amount of fragmentation (or whatever other statistics would be useful), show that table in a different color - a shade of red or something like that. Similarly, it would be helpful to have a kind of top waits report node where you could see the wait types that were most experienced in a given database, possibly with a way to drill down to see what queries were involved.
I'm not saying I want SQL Server to do everything for me, and I know a lot of these things are available in third-party (and expensive) products, but it would be nice for it to tell me things it can already know on its own, to help narrow down possible issues as soon as the database GUI is brought up, if a DBA (say, for example, me :blush
has not yet gotten to the state of having a lot of these checks automated. SSMS seems like the best place to add these features.
Just my two cents.
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
"Operator! Give me the number for 911!" - Homer Simpson
"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"