Dotmad.net

The “Fixed in ver” field for a VSTS bug is a combo box containing a range of values, retrieved from builds you run.
What if you did many tests and you don’t want them to appear in the selection?
These steps will allow you to edit this list:

1. Use the glexport.exe tool in C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to export all global lists to an xml file (”glexport /f lists.xml /t vstsmain”).
2. Edit the xml file - remove all xml nodes (but not the xml root!) other than the one with the name starting with “Builds - ” and ending with the project you wish to edit (so you don’t modify another list by mistake).
3. Edit the list of the builds.
4. Use the glimport.exe tool (same folder) to import the edited list from the modified xml file (”glimport /f lists.xml /t vstsmain”).

Update: Jason Prickett published a post detailing the removal of the builds from work item tracking.

Each table column has a ‘description’ field, which is an extended property.
This is a way to retrieve extended properties for a database:

SELECT t.name AS [Table Name], c.name AS [Column Name], value AS [Extended Property]
FROM sys.extended_properties AS ep
INNER JOIN sys.tables AS t ON ep.major_id = t.object_id
INNER JOIN sys.columns AS c ON ep.major_id = c.object_id AND ep.minor_id = c.column_id
WHERE class = 1

A very impressive event. According to Yosi’s blog 2300 people conquered the Cinema city complex. But I do have some comments.

The bad:

• As it turns out, the parking lot can’t house so many cars. Here is where I had to park my car:

• Since you couldn’t specify a list of presentations on registration, there were many occasions of 500 people trying to enter a theatre containing 150 seats, causing some people to miss the presentation. As Yosi wrote, they did add more presentations because of the demand, but it wasn’t enough. You had to be standing near the door 10 minutes early to make sure you got in. I hope to catch those I missed here.
• The “Studential lunch” was a bit of a turn-down, after last year’s convention in David Intercontinental hotel.

The good:

• The Microsoft team did an impressive marketing job for the convention. They created several ‘Trailers’ for the event, featuring many MVPs, and they re-models the complex, replacing all normal movie posters with posters for these ‘movies’:
  

• Ron Jacob’s presentation was great. It covered mostly the basics, but most people tend to ignore those basics. I think many developers are now sealing security holes. He also did some ARCasts I intend to download. Here is Tal’s review on Udi Dahan’s and Ohad Israeli’s talks. (You can also download Udi’s talk here)
• This event is a great way for meeting people from the industry, I had a great time talking to peers, both old (people I used to work with) and new.
• No marketing presentations.