Simon Sabin has asked for better usability in the SQL Server Agent log viewer: specifically, to allow you to get to job / step properties directly from the history viewer.
#531889 : Allow access to job details from the log file viewer to improve manageability
Guru Itzik Ben-Gan asks for a more powerful QUALIFY() option to allow filtering on the same kind of query elements that you can currently achieve with ROW_NUMBER(). This one already has over 80 votes!
Chris Howarth points out even more problems with the custom connection coloring feature in SSMS (all the more reason to use Mladen's SSMSToolsPack).
#533667 : SSMS Connection Colouring Not Implemented Sensibly
MauriD asks for the ability to include a NOEXPAND hint for CTEs.
And last but not least, user "7gartner" asks for the ability to store tempdb on local storage in a cluster.
#532759 : Support local disk location for TempDB in failover cluster installation
When I read the title of this item, I thought, "oh, he must expect that someone with an active batch that is using a #temp table, might be able to continue working in the event of a failover." Which doesn't make sense because their connection would be severed anyway. But when I investigated the body, the want is much more simple than that: allow a system to avoid having to use shared storage for TempDB. This means not using valuable SAN space and using local hard disks, possibly SSDs. A light bulb went on when I saw that, because I know that outfitting SAN-based SSDs at reasonable capacity can get quite expensive, but an SSD dumped into a server – at a capacity to handle the typical sizing requirements of TempDB disks – would be a much more affordable option. (Paul Nielsen just wrote about using tempdb in RAM, and the implication on using this in a cluster resonates again.)
Hey Chris,
Some days have been hectic (like today, I drove down to Seattle and am now back in Vancouver), but as I find time on quieter, non-event days, I will probably try to squeeze a bit of time on here…
Aaron,
Thought you were too busy at the Olympics to blog? Come on Canada
Chris (in Edmonton, Alberta, Canada)