Connect Digest : 2011-03-12


Last year, I came to a very tough decision that I would cease publicizing Connect items in an attempt to drive up votes and get important issues fixed. This was almost entirely due to a couple of MVPs criticizing me for raising awareness of certain Connect items instead of letting them be found "naturally." I wasn't sure what world they were living in, where droves of everyday end users just happened to stumble upon Connect items without any prompting. I suppose it could be said that the more users that come across a bug, the higher the vote count will be – however history has shown that it is much more likely that there will just be more copies of the same bug, since folks will report the bug on their own after a half-hearted search for a previously existing submission. All this does is dilute the votes and make it harder for Microsoft to assess the community's opinion about the bug.

Suggestions are a different beast altogether. It is quite often the case that I see and up-vote suggestions that I would have never thought up on my own, but once I read the submitter's point of view, am swayed to vote with them (or against them, in some cases). Is this the same experience for a lot of people? I doubt it is extremely common – I'm a Connect power user and actively monitor the RSS feeds for both new feedback and recently modified feedback for SQL Server. It is my belief that, without a little nudge from folks like me, suggestions and bugs would go unreported in the first place, or would wither away due to little Connect activity. Most people have better things to do with their time than trawl Connect to stumble upon new items they agree or disagree with.

At the MVP Summit last week, I was encouraged by several of my esteemed peers to resume my Connect Digests, and to not listen to folks who think they're a bad idea. The overall benefit – getting Microsoft to see the community support behind a particular idea – far outweighs any negative they could envision.

In addition to this, over the last few days, I've had several of my suggestions dismissed as "won't fix" by the product team. Each closure invites me to re-open if I disagree; however – as a few other MVPs pointed out (since this also happened to them recently) – the submitter can't re-open suggestions, only bugs. And if you submit a new suggestion in an effort to gain new visibility for your idea, unfortunately you lose all the votes from the closed item (except your own, of course). This made me feel that in order to help prevent suggestions from being summarily dismissed, they could use some more community attention… though I confess there were 20 or more votes on several of the items I've watched being closed. Still, more votes can't hurt.

So, I am going to ignore the cries of foul play from a few noisy individuals, and resume publicizing some Connect issues where and when I see fit. If you don't like it, I'd love to hear your reasoning, but I have my suspicions about the underlying motivation, so I'll take it with a grain of salt.

So please vote…

This past week, there were two really important issues brought up on the Connect site, and I hope that Microsoft can be convinced to properly investigate both.

#650569 : SSMS 2008 R2 is losing Intellisense after installing Visual Studio 2010 SP1

Daniel Schmitz reported something that many users are complaining about: Visual Studio 2010 SP1, released earlier this week, is breaking their IntelliSense in various ways. I've seen reports about both SSMS 2008 and SSMS 2008 R2, and I've seen hints that the bug's manifestation may or may not occur on Windows 7 or Windows 2008 R2 if you have installed Service Pack 1 *for the O/S* first. If you can (or can't!) reproduce this problem, please post to the Connect item (or comment here) with your operating system, whether or not you have SP1 enabled if it is Win7/2008 R2, the exact SSMS version (help | about), and your actual observed symptoms. Right now the information is a bit of a hodge-podge, and in order to get the issue resolved, it will likely take a much larger sample of complete information.

#648351 : Extended Events Action to collect actual execution plan

Fellow MVP Jonathan Kehayias recently suggested that Extended Events could include actual execution plans as part of the collection process, to greatly enhance performance troubleshooting efforts. As most of us know, when we collect showplan information in a trace, it is great to see the plans but we can't figure out what statement or object is associated with the plan. Why? Because TextData is always empty in the trace. You have to also be collecting statement information in your trace, and then you must manually correlate the statements with their plan counterparts. As you can guess, rigging Extended Events the way Jonathan suggests will be much tidier.

…and comment!

In a lot of cases, Microsoft doesn't just want to see vote count; they want to see your opinions about WHY you are up-voting. They need more than just a raw number to show their bosses, and for them to even be behind the idea in the first place, they may need more business/use case behind the need for the change. The original item may not have been descriptive enough for them to justify the work required for the change, and you may have some insight that will win them over.

And if you are down-voting an item, please consider telling the author why. I've had down-votes against issues where there was a typo in Books Online – I don't know who would vote against fixing incorrect documentation; maybe my complaints gave them a change of heart, or maybe it was an honest mistake, but they did correct their vote. If you include a comment with qualitative information, at least Microsoft, the submitter, and the rest of the community have some insight into your decision.


In future installments, I'll try to stick to a theme and a certain number of Connect items (say, 5). What do you think? Suggestions?


Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

14 Responses

  1. Eric Wisdahl says:

    Here I just thought you were caught up with other items and had fallen behind on the connect issue digests.  Please, keep them coming!

  2. Bill Graziano says:

    Aaron, great to see you doing this again!

  3. kendra little says:

    I always enjoyed your connect bug posts– I had assumed you got tired of doing them.
    I like the bugs that you spot and tend to agree with you, so it's a great service to have you post about bugs! Thanks for restarting.

  4. Chris Wood says:

    This is an excellent service that you provide. I just about get sued to Coonect and then Microsoft change it again. Your service helps to bring the real purpose of Connect to the masses, pointing out real every day problems and suggested improvements to the product, SQL Server.

  5. jonmcrawford says:

    This is exactly the kind of value that MVP's should be extending to the rest of the community, definitely glad you're doing this again. To those who feel this is wrong, consider that us non-MVP's might be as much or more interested in the *why* behind the suggestion of voting for Connect items, which may not have occurred to us as we might not know the product as well. Without insight from those such as Aaron, we might skip it entirely though we would agree if we understood.

  6. Alejandro Mesa says:

    I am glad you decided to resume with this kind of post. You are educating us about the importance of voting and to expand the vote with real cases to support the action.
    Thanks for taking the time to gather the connect entries, and expand about the problems or ideas behind them.


  7. Lara Rubbelke says:

    Excellent!  Thanks Aaron!

  8. cinahcaM madA says:

    I'm going to go out on a limb and say that whoever told you to stop is a complete moron. I'm glad you've started this up again. It's a great service to the community.

  9. jamiet says:

    Now how do I feel. I'll read properly next time!! 🙂

  10. AaronBertrand says:

    Thanks Jamie, I did… see the two links in the second paragraph. 🙂
    PS the links return errors if you use http instead of https.

  11. jamiet says:

    Hi Aaron,
    Good to see it return. Can I make a suggestion for the future? Could you make people aware of the RSS feed for new submissions?
    Its at:*/
    P.S. The RSS feed occasionally returns an error page but trust me, it does work.

  12. Michael Codanti says:

    I think you should continue making connect items more visible. And you aren't the only one that does it Itzik Ben-Gan has written articles in SQL Server Magazine to do the same thing, and I appreciate it.

  13. AaronBertrand says:

    Thanks Robert, I appreciate it.

  14. Robert L Davis says:

    I vote for continuing it!! I think it's important to bring attention to items.