Also really excited about doing my first ever MVP TV set up by the Microsoft MVP program.  Hope to see you there!  We have an extra thirty minutes at the end so be sure to bring your questions.

MVP TV: Real World TFS: Tips for a Successful Team System Implementation

Wednesday, July 15^th, 2009 | 9:00am – 10:30am (PDT, Redmond time) or 12:00pm – 1:30pm (EDT, New York City time)

Targeted: This Product Group Interaction is open to  all Developer MVPs in all Technical Expertise and  public audience.

So you’ve decided that Visual Studio Team System & Team Foundation Server is going to bring your organization added value (because it will :)) but what do you do now?  Please join Ed Blankenship as he covers the 2.5 years of successful implementation of VSTS and the experience of that journey at Infragistics, the world’s leading maker of software development tools.  The session intends to cover each phase of the implementation of all affected areas for a smooth adoption:  Version Control, Builds, Work Item Tracking, global deployment, moving multiple teams, training, automated testing, migration from legacy systems, and integration with other systems and TFS.  The goal will be to go through at a high-level of what it takes to make you successful by learning from the challenges and obstacles overcome.  We’ll also look in the future with VSTS 2010 and see how strategic planning will help make a successful adoption of the new features in the upcoming 2010 release.  The session is led by a Microsoft MVP (Team System) & Champ who has been in the trenches during the whole implementation.

Prerequisites:  A healthy attitude in learning from other peoples challenges and a strong desire to make real change within your organization!

About Ed Blankenship: Ed is a Microsoft MVP, Microsoft Certified Application Developer, and works as the Release Engineering Manager at Infragistics, makers of the world's leading presentation layer tools and components. His expertise consists of Microsoft Visual Studio Team System and Team Foundation Server. He is also a technical evangelist for Rich Client applications (primarily Windows Forms & Windows Presentation Foundation.) He has been a technical editor for several Silverlight books, an article author, and has spoken at various user groups, events, and conferences.

PJ Forgione has invited you to attend an online meeting using Live Meeting.
Join the meeting. (Link: https://www.livemeeting.com/cc/mvp/join?id=NP5FQZ&role=attend&pw=A49410Y0D )
Audio Information
Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
Telephone conferencing
Use the information below to connect:
Toll-free: +1 (866) 500-6738
Toll: +1 (203) 480-8000
Participant code: 5460396

Ed Blankenship

While I’m up in New Jersey working at the Infragistics headquarters office, I’m going to have the privilege of speaking at the New York City VSTS User Group on July 28, 2009 at 6:30 PM.  Come see me if you’re in the area!  Because of security concerns at the building, you do need to register ahead of time if you’re planning to attend.

Real World TFS: Tips for a Successful Team System Implementation

Description:
So you've decided that Visual Studio Team System & Team Foundation Server is going to bring your organization added value (because it will :)) but what do you do now? Please join Ed Blankenship as he covers the 2.5 years of successful implementation of VSTS and the experience of that journey at Infragistics, the world's leading maker of software development tools. The session intends to cover each phase of the implementation of all affected areas for a smooth adoption: Version Control, Builds, Work Item Tracking, global deployment, moving multiple teams, training, automated testing, migration from legacy systems, and integration with other systems and TFS. The goal will be to go through at a high-level of what it takes to make you successful by learning from the challenges and obstacles overcome. We'll also look in the future with VSTS 2010 and see how strategic planning will help make a successful adoption of the new features in the upcoming 2010 release. The session is led by a Microsoft MVP (Team System) & Champ who has been in the trenches during the whole implementation.

Presenter: Ed Blankenship

Bio:
Ed is a Microsoft MVP, Microsoft Certified Application Developer, and works as the Release Engineering Manager at Infragistics, makers of the world's leading presentation layer tools and components. His expertise includes Microsoft Visual Studio Team System and Team Foundation Server. He is also a technical evangelist for Rich Client applications (primarily Windows Forms & Windows Presentation Foundation.) He has been a technical editor for several Silverlight books, an article author, and has spoken at various user groups, events, radio shows, and conferences.

Date/Time:  07-28-2009 6:30 - 8:00 PM

Location: Microsoft Offices in NYC at 1290 Avenue of Americas, 6th Floor

Click here to Register

Ed Blankenship

Dear Reader,

I have decided to accept a Senior ALM Consultant position with the premier Australian consulting company, Readify.

It’s always a tough decision to move on from a company you’ve really enjoyed being at.  I’ve really enjoyed the work that I have had the opportunity to do at Infragistics.  There are so many really great people at Infragistics that I truly will miss working with and hope to see in the future.  Some of my really good personal friends have been fellow colleagues at Infragistics which just shows you the type of culture that we have.  I’ve had an amazing team that I’ve worked with as the Release Engineering Manager and they have been truly able to make a positive change for the organization.  They’ve always been there to help make miracles and put in those really really long hours at release crunch time.  So really, I need to tip my hat to each of them for just being awesome:  Brian, Geoff, Kareen, and Jason.

I’m really excited about this new opportunity.  I never would have thought in my wildest dreams that I’d be living abroad but the idea grew more and more on me as this opportunity came up.  I hear Australia is a beautiful country with an amazing culture.  I’m not currently planning for this to be a permanent move whatsoever but everyone I talk to about it says that I’m not going to want to come back! :) 

I’ve heard about Readify for several years now as a Visual Studio Team System professional any time I hear about Australia & TFS/VSTS/ALM.  I’m really looking forward being able to visit multiple customer sites again and coming up with solutions to their ALM problems.  It’s been a while since I’ve been an ALM consultant so I’m looking forward to the variety.  Even more, as an MVP I’m looking forward to a whole new set of venues to get involved with the community on a new continent.  I think I’m going to have a busy schedule!

There are tons of different things for me to solve as an American citizen living abroad.  It’s interesting that Grant Holliday just made the opposite move almost a year ago and I plan on doing the same thing as he has and try to write about the differences between the two countries.  Hopefully you’ll find it as interesting as I did with Grant’s story.

I’m planning a really simple move:  packing up a few suitcases of clothes and jumping on a plane.  Hoping that works out well for me! :)

I have decided to continue working with Infragistics until the beginning of August to wrap things up and hopefully train my replacement.  I guess the cat is out of the bag with the official job opening announcement on our website listed under Research & Development.  That position is listed to be the back-fill headcount for my current position.  Finally – I’d like to ask you to help us out:  If you’ve heard about our TFS instance and VSTS implementation from some of my user group talks or the Radio TFS episode and are interested (or know someone awesome who might be) in continuing this exciting work, please let me know!  You can send me a quick note to ed at infragistics dot com or use any of the contact links from my blog website.

Take care!

Ed Blankenship

I’m up really early this morning.  I’m about to head to the airport to spend my Independence Day weekend in the Carolinas for some much needed beach vacation and visit with friends.  Thankfully, I didn’t miss Martin Woodward letting me know that the latest Radio TFS episode was made available just a few moments ago that includes my interview about our use of TFS and Visual Studio Team System at Infragistics.  It’s a longer episode than normal so it’s perfect if you’re going to be spending some time at the beach like me and listen to a fun talk.  We both really enjoyed chatting for this episode so we hope you enjoy it as well!

Using TFS with Ed Blankenship

In this episode we sit down and chat with Ed Blankenship about the use of Team Foundation Server at Infragistics. Ed has had some interesting challenges and experiences in running their TFS instance.  Additionally they have done some fairly advanced integration work which we discuss in detail.  This is a double-length show, so hopefully plenty of stuff to enjoy if you are sunning yourself on a beach somewhere.

Ed is the Release Engineering Manager at Infragistics, makers of the world's leading presentation layer tools and components.  He is also a Microsoft MVP in Visual Studio Team System.

     Play Now: Using TFS with Ed Blankenship

As the Release Engineering Manager, he leads the Release Engineering Department which is responsible for automated builds, creating product installers, packaging source code for customers, source configuration management/version control, metrics, release management, work item tracking, licensing enforcement, and development of internal productivity tools.  The department also is responsible for TFS Operations & Maintenance.

Ed has been a technical editor for the Wrox Silverlight 1.0, Silverlight 2 Developer's Guide, and Silverlight 2 Bible books, author of numerous articles, and has spoken at various user groups, events, and conferences.

Links from the show:

• Ed's Blog
• Microsoft Process Template
• Martin's Blog Post on Check-in Policies
• How to turn on Activity Logging with TFS 2005

As usual send any feedback to radiotfs@gmail.com.

Feel free to let me know if you have any questions based on the Radio TFS chat.  I’m more than happy to get them answered for you!

Take care,

Ed B.

Come join!  Here’s the website and the details.

Website:  http://www.tsug-ve.com/

JUNE EMEA Meeting
Meeting Date: Thursday, June 18th, 2009
Time: 10:00AM PDT/SLT (18:00 UTC)
Location:  Microsoft Island in Second Life

Real World TFS:  Tips for a Successful Team System Implementation

OK, you’ve decided that Visual Studio Team System & Team Foundation Server is going to bring your organization added value (because it will :)) but what do you do now?  This session will cover the 2.5 year successful implementation of VSTS and the experience of that journey at Infragistics, the world’s leading maker of software development tools.  The session intends to cover over each phase of the implementation over all of the affected areas for a smooth adoption:  Version Control, Builds, Work Item Tracking, global deployment, moving multiple teams, training, automated testing, migration from legacy systems, and integration with other systems and TFS.  The goal will be to go through at a high-level what it takes to make you successful by learning from the challenges and obstacles overcome.  We’ll also look to the future with VSTS 2010 and see how strategic planning will help make a successful adoption of the new features in the upcoming 2010 release.  The session is led by a Team System MVP & Champ who has been in the trenches during the whole implementation.

Prerequisites:  A healthy attitude from learning from other’s challenges and a strong desire to make real change at your organization!

Take care,

Ed B.

I’ll have to admit, the Easy Assist feature is not very discoverable if you have a Live Meeting account but it’s really really really useful!  So imagine you have a coworker or a mother who needs help but they’re not where you’re at.  There are a lot of different ways for people to do remote assistance support but if you have a Live Meeting account there’s another way that I’ve been using:  Easy Assist.  It’s the same app that lots of support professionals at Microsoft Product Support & Services use to help customers remotely.

BTW:  If you’re an MVP, you have received a complimentary Live Meeting account as part of your benefits!

Downloads for End-users who need support

• Download the Microsoft Easy Assist support console for joining an Easy Assist session
• Download the Microsoft Easy Assist Safe Mode Client for troubleshooting within Windows Safe Mode

Downloads for Support Agent

• Download the Easy Assist Launchpad for setting up Easy Assist sessions
• Download the Microsoft Easy Assist support console for joining an Easy Assist session

Easy Assist Launchpad

So the first thing you should do to help create support sessions quickly as a “support agent” is get the Easy Assist Launchpad installed so it sits in your tray and waits for you.  When you launch it for the first time, it’ll ask you to put in your Live Meeting credentials.  These are the same that you would use when you setup & configure the Live Meeting client. 

After you have finished that, the Launchpad will sit in your system tray and has a few options available for you:

I’ve went ahead and chosen “Create Session” and I’m just going to put in something to let my Mom (and I) know this is for her session.

After, creating the session you’ll have the option to join the session yourself and also send the invite by e-mail (using your default e-mail application) to the person you’re trying to support.  Look at the URL… you’ll notice it’s very similar to a Live Meeting invite but instead it has the “joinEA?” inside of it.  This is important because this is what makes the end user experience better for the support agent and the person being supported because it will fire off the Easy Assist client instead of the full Live Meeting client.

Support Agent Features

Once you’ve fired off the Easy Assist support agent client, you’ll be able to see the other support agents that are attending as well as the person(s) you are trying to support.  You can request that they reboot, share their screen, share your screen, request to control their session, send files, and more.  Support agent screens:

All the end user sees is a small window that’s out of view.  After the session, it even asks the end user if they would like to uninstall the Easy Assist client since it’s not needed anymore!  How nice?!  It even works if the customer has booted in safe mode.  Very handy at times.

You can see how it’s super easy to escalate a support call from a family member, an IM/e-mail from a co-worker, or even setting up a session for you to get help from a support agent who doesn’t have remote assistance provided by their employer.  Hope this is helpful to you!

Ed B.

This has been out for a little while but wanted to make sure that you knew about it as well!

Our Director of Product Development here at Infragistics, Joe Croney, has been working on a personal side project of creating an iPhone app that will connect to Team Foundation Server.  He’s got a BETA posted in the Apple iTunes store now.  At the moment it only supports checking on Builds but I know he’s starting a backlog.

More screenshots and an FAQ are available at the website:  http://www.tfstogo.com/

Joe is looking for some feedback and any bugs so if you find some feel free to report them at support@tfstogo.com.  Congrats Joe!

FYI:  We’ve found that if you connect over VPN in the iPhone that sometimes a local DNS name isn’t resolved correctly.  You can correct this by putting in the hard-coded IP address of the TFS server instead.

Have fun and enjoy!

Ed B.

It’s been pretty quiet around this blog for quite some time now.  Just been busy traveling to TechEd North America and back to our office in New Jersey.  Lots going on!  However, no one ever has enough time to get everything done :)

I’m going to be a little more demanding on myself to get through my blog topic backlog that I’ve been keeping for a while.  I think I’m up to 19 at the moment so I need to get it flushed out!  I keep a list alongside my To-Do list in OneNote about different topics that I come across that I blog about.  Usually they are from problems that I see day to day that other people probably will want to solve at some point (I always archive the screenshots so I can use them in my blog posts later.)  Other topics that end up on the list are in response to something I’ve done while traveling.  For example, Martin Woodward and I had the chance to record a Radio TFS episode (not yet aired) where we talked about our implementation of Team Foundation Server and Visual Studio Team System at Infragistics.  I think it was a great session and definitely looking forward to it getting out in the wild.  There were a few topics that we talked of stumbles we’ve encountered over the last two years and how we ended up solving them.  The goal for us was to get those out in the public since others may be experiencing the same hurdles and looking for resources on how to solve them.  It’s more along the lines of “hey, here’s our story so you can learn from our mistakes.”  I hope you find them useful.  On this blog, I’ll start talking about some of those points that we brought up in more detail since the radio show has to be reduced to a reasonable amount of time :)  Some of the stuff we talked about was just down-right cool!  More details to come…

So, dear reader, I am pledging to you to get through my current blog topic backlog by the end of June.  Let me know if you would like me to write about anything in particular!

Take care,

Ed B.

P.S.  I cross-post between my Infragistics Blog and my personal blog.  Some posts don’t end up on my Infragistics Blog site so be sure to check http://www.edsquared.com/ from time to time where my long-time colleague Ed Kisinger and I blog.  If you’d like to subscribe to that feed, the RSS address is:  RSS for Posts

I had a really good time last night speaking to the Dallas VSTS User Group about the Microsoft Process Template.  If you want more information, I wrote a blog post shortly after the public release of the MPT.  I was really sick last month when I was supposed to speak so I’m really glad I got the opportunity to make it up.

One of the things I really enjoy about the group was the open session time after the scheduled talk to discuss problems people were facing with Team System and the group attempts to come up with possible solutions.  That’s really a great use of time for a specialized user group like this one.

As a fun extra, thankfully the Demo Gods were okay with me and saved this Blue Screen of Death (BSOD) until after I was finished using the VPC during my talk :)  Everyone insisted that I take a screenshot and share with the rest of the world so enjoy!

Ed B.

P.S. As a side note, the experience whenever your evaluation license runs out in Windows Server 2008 has definitely improved.  It no longer gives you a BSOD.  I was using TFS 2008 SP1 installed in a Windows Server 2003 VPC for my demos.

In December, I had the privilege to be the “MVP in Residence” with the Team System product group.  Chuck blogged about the experience at the beginning and end of the week.  I felt really good about the accomplishments at the end of the week.  The main project I worked on was packaging up the Microsoft Process Template (MPT) so that it could used by the public community.  I’m happy to announce that it is live on CodePlex now so feel free to download and use it!

Description

The Microsoft Process Template (MPT) is a Microsoft internal, end-to-end project management solution that maps to the Microsoft product development cycle and works with Visual Studio Team System 2008 (VSTS). The MPT offers an out-of-the-box solution and includes all the work item types (forms), queries, documentation, engineering best practices, and reports required for Microsoft development teams to get up and running on Visual Studio Team System. The Engineering Excellence* and Visual Studio Development teams worked together closely over the last year to create this template by compiling the lessons learned from other teams that have implemented similar templates, incorporating engineering best practices, widely socializing the concepts, and finally piloting this template with several product groups.
*The engineering excellence team is a Microsoft business unit that provides Microsoft business group employees with high-quality technical education, best practices and guidance.

Be sure to check out the Introduction and the Getting Started guides to dive in and get the background information for the process template.  One of the main things that people will notice is that the MPT simulates work item hierarchy through the the use of some daemon services.  There are several ways to simulate hierarchy in TFS 2008 so if you’re looking for a solution the MPT has the services source code and reports created for them.

Here is a sample report that uses the hierarchy to rollup the progress by Feature:

There are a few known issues with the process template which are listed in the Getting Started guide.  I’ll be sure to keep the guide updated if I hear of any other known issues.

Other MPT Resources

Gregg Boer, Principal Program Manager on the TFS product group, wrote an excellent series of blog posts of how Microsoft uses the MPT internally along with an overview of the process around tracking progress throughout the release.

· How Microsoft/DevDiv uses TFS - Chapter 1 (Our Process)

· How Microsoft/DevDiv uses TFS - Chapter 2 (Feature Crews)

· How Microsoft/DevDiv uses TFS - Chapter 3 (Implementing the Process)

· How Microsoft/DevDiv uses TFS - Chapter 3 (Addendum)

· How Microsoft/DevDiv uses TFS - Chapter 4

· How Microsoft/DevDiv uses TFS - Chapter 5 (Tracking Progress)

· How Microsoft/DevDiv uses TFS - Chapter 6 (Tracking multiple projects)

· How Microsoft/DevDiv uses TFS - Chapter 6 (Addendum)

· How Microsoft/DevDiv uses TFS-Chapter 7 (Tracking Risk)

· How Microsoft/DevDiv uses TFS-Chapter 8 (Tracking Quality Gates)

· How Microsoft/Dev Div uses TFS - Chapter 9 (Transparency in Reporting)

Jeff Beehler and Brian Keller also put together a video of how Jeff uses the MPT & TFS to monitor progress of the release cycle. Take a look on Channel 9: http://channel9.msdn.com/posts/briankel/Better-Project-Management-with-Team-Foundation-Server/

I really want to thank you to everyone that helped getting it packaged up for the public!  Also, thanks to Chuck for organizing the week, working logistics, and of course giving me a place to stay!

Ed B.

I just found out about this group from an MSDN Flash. Check them out; there is a meeting tonight.

Azure User Group Website

The website is home for many Azure User Groups from around the world.

Ed K.

Download here

Overview

The Azure Services Training Kit includes a comprehensive set of technical content including hands-on labs, presentations, and demos that are designed to help you learn how to use the Azure Services Platform. The February release includes the following updates:

• 19 demo scripts that walkthrough several of the services
• 10 presentations covering the entire Azure Services Platform
• 3 additional hands-on labs for Live Services

This technical content covers services including: Windows Azure, .NET Services, SQL Services, and Live Services.

Ed K.

Grant Holliday, former Team System MVP, is now working on the VSTS product group on various things but most importantly helping keep the internal Microsoft TFS servers in tip-top shape.  They have the largest known TFS instances in the world so you could imagine it’s got to be tough keeping it up and running well.  Brian Harry posts their usage metrics regularly if you’d like to get an idea of how HUGE it is.

Keeping the performance manageable requires lots of monitoring and looking over the data that gets stored in the activity logging.  Grant has packaged up some of the reports they use internally and provided them to the world.  The download package is available on his blog post.

Personally, I’m really glad that the product group is investing in dogfooding the early builds of the version of TFS that they are working on.  By putting the product under real use and under the load that only Microsoft can generate, we end up with a better product by the time it RTMs.

Thanks again for making this available to the world!

Ed B.

Here are some links to get you started learning and developing on the Azure platform.

Azure Services Platform

Azure SDK downloads

Azure training Kit

PDC recorded sessions

Azure sample application (IssueTracker)

MSDN Azure blog

Ed K.

Well, I have hit my one year mark of not using tobacco products!! Its been extremely hard but well worth the sacrifice. I will not lie to anyone thinking about quitting....I still have cravings but they are not as bad and they do not last as long. The main thing that got me through the first 6 months was "hard candy" by the truck loads (weight gain was present) and family support. After 6 months I was able to manage cravings with exercise and avoiding stressful situations.

Ed K.

From those of you that use the Workgroup edition of Team Foundation Server you might have notice that you cannot use the Build Notification Power Tool since you cannot authenticate to TFS.

Here is what I have done to work around the noted limitation:

"RunAs" to the rescue:

C:\Windows\System32>runas.exe /user:ROSCOE\jbm /netonly "C:\Program Files\Microsoft Team Foundation Server 2008 Power Tools\BuildNotification.exe"

To automate, create yourself a little batch file for startup. Here is a VBS script to automate the entry of the password for RunAs:

dim WshShell,FSO

set WshShell = CreateObject("WScript.Shell")
set WshEnv = WshShell.Environment("Process")

set FSO = CreateObject("Scripting.FileSystemObject")

WshShell.Run("C:\Windows\System32\runas.exe /user:ROSCOE\jbm /netonly" & " {YourInstallPath}\BuildNotification.exe")

Wscript.Sleep 300 ' Wait for window to open

WshShell.AppActivate("C:\Windows\System32\runas.exe")
WshShell.SendKeys "{YourUserPassword}"
WshShell.SendKeys VBCRLF

set WshShell=Nothing
set WshEnv=Nothing
set FSO=Nothing

wscript.quit

[UPDATE]
You can "Connect As" from the GUI; Unfortunately, you will have to do this each time you restart.

Ed K.

I’ve been in the middle of a lot lately and completely forgot to mention Tulsa TechFest 2008!  This will be my third year speaking and interestingly I have the only Team System talk this year.  If you’re around the area be sure to come by to learn more about automating your build & packaging process using Team System.  I’m going to do my Team Build talk that I did earlier this year at the Dallas VSTS User Group but we won’t go into as much depth since we only have 1.5 hours.  Looks like another great year with almost.  Infragistics has been a proud & regular sponsor of this event and I’m honored to have been invited again!

[Update]

Wanted to be sure I posted my slides and then also made the link to the awesome build lifecycle poster done by our friends in South Africa.  Thanks for keeping me honest!

Ed B.

I didn't get to read my RSS feeds yet today but I got a hint to go read them and I discovered that Chuck wrote a nice blog post about volunteer work and me.  I guess the cat's out of the bag now :)  Thanks Chuck for the kudos - I really appreciate it.  I'm looking forward to making a really good use of that time.

There are so many people in the development community that spend countless hours of their volunteer time.  Especially in the VSTS community.  People are working volunteering time:

• developing and supporting open-source projects & tools,
• speaking at events and conferences (this takes a considerable amount of time to prepare for,)
• leading local user groups,
• writing blog posts, technical articles, & books,
• answering community questions in the MSDN Forums,
• giving feedback, enhancement requests, & reporting problems of Microsoft products to improve them, and
• all of the other ways people volunteer time that I can't even begin to think of.

I personally know several people (and more) who really focus on trying to make the entire development community better off with these time & knowledge contributions.  (Infragistics as a company has been really supportive in all of our efforts to help the community.) I hope you get as much out of it as I do from learning from everyone.  Microsoft has done a great job in recognizing those individuals by creating the Most Valuable Professional (MVP) award.  I'm honored to have been awarded this award earlier this year.

I've really not been able to blog as much as I have liked to or participating in the MSDN Forums answering people's questions.  I have focused the volunteer time that I have had in other areas.  I had a really great time at the MVP Summit earlier this year and came back with so many different ideas.  I really love the VSTS MVP & Champs group - truly a great group of professionals!  This brings me to my idea for this year.

I feel like I haven't had time this year to really provide anything meaningful to the community.  So, I want to dedicate a work week and do something meaningful for the VSTS community.  There are plenty of places that we could all use help so I think that would be something meaningful and useful.  I'm planning on doing this time locally in Redmond so that if I need background information on a project, I can get it quickly.  I need to meet with some people about Infragistics stuff and really take some vacation time in that area (since it is so beautiful) so I think it's beneficial to be local during that week.

What should I work on?

Chuck mentioned a few ideas that we have so far but the one I personally love is being able to release the gigantic amount of work that Microsoft has done with their internal process templates & reports.  Have you seen them?  They are awesome!  Reports are so tricky to do and take a good chunk of time to be done correctly.  The Microsoft internal reports need to be scrubbed for external consumption which is my initial idea for volunteer work.

Or should I work on a productivity tool?

Don't let me taint your opinions though.  What do you want/need that would be valuable for VSTS?  Go to Chuck's blog post and give us suggestions about what you would like to see me work on.  No car washing or details though :) unless it's for a good charity organization then I'll consider it.

Ed B.

So, I came across something pretty interesting when I was making a work item query today that I've wondered for a while.  I can't believe I just came across it today.

OK - Just for some background on what I was trying to do:  I wanted to get a team query made that returned all of the bugs for my team.  The only problem is that our department supports all of our products for mainly builds & installers (among other things) and it causes the Area Paths that we look at to be pretty much all over our TFS server.  Usually you would just want all the bugs for a particular product and you can use the UNDER operator for the Area Path field.  I need to use multiple condition clauses using the UNDER operator.  I knew that the Work Item Query Language (WIQL) had a way for putting parenthesis around the conditionals in the WHERE clause.  (The WIQL syntax is very similar to T-SQL if you haven't ever seen it before.)  For example, here's part of a sample WIQL query that I was going after....

SELECT [System.Id], (Other Fields) FROM WorkItems WHERE [System.WorkItemType] = 'Bug'  AND  [System.State] <> 'Closed'  AND  ([System.AreaPath] UNDER 'NetAdvantage\.NET\Installers'  OR  [System.AreaPath] UNDER 'NetAdvantage\.NET\ASP.NET\Builds'  OR  [System.AreaPath] UNDER 'NetAdvantage\.NET\WinForms\Builds'  OR  [System.AreaPath] UNDER 'NetAdvantage\WPF\Builds'  OR  [System.AreaPath] UNDER 'NetAdvantage\WPF\Installers'  OR  [System.AreaPath] UNDER 'TestAdvantage\QTP\WinForms\Builds'  OR  [System.AreaPath] UNDER 'TestAdvantage\QTP\WinForms\Installers'  OR  [System.AreaPath] UNDER 'TestAdvantage\RFT\WinForms\Builds'  OR  [System.AreaPath] UNDER 'TestAdvantage\RFT\WinForms\Installers')

My problem was - how do I put parenthesis in the query using the Work Item Query Editor? (UI in Visual Studio)

However, I remember reading Brian's post yesterday about the new Alerts Editor (which by the way is totally awesome and immediately adds value to the product without waiting for the next major release) and thought, I wonder how they did that in the UI with the alerts XPath queries because I know you can't get very good alerts without the ability to group the XPath query conditionals.  Let me steal an image from Brian's post with a little editing showing off a grouping of condition clauses:

I thought to myself, hmmmm... that grid looks pretty similar to WIQ Editor grid that exists today in Team Explorer 2008 and started searching everywhere for the "group" tool button (since there is not a toolbar above the grid.)  I found it.  It's in the context menu whenever you select multiple rows.  Seriously, I can't believe I haven't ever seen it before.  I guess I don't usually write very complex work item queries :)

Have fun writing some useful queries for yourself and your team now!

Ed B.

Speaking of Team System, I found out last week that I have been officially inducted into the Team System MVP group.  Earlier this year, I was awarded as an MVP in the Client Application Development competency.  Don't get me wrong, I still love WPF & Silverlight development and will continue to be involved in that community in the future.  I'm even working on finishing up the technical editing of a Silverlight 2 book right this minute. Or actually I'm procrastinating writing blog posts :)

Being part of the Team System MVP group, I'm really joining one of the most awesome groups ever.  I spent all of my time earlier this year at the MVP Summit at all of the Team System sessions and they truly are one of the best product teams at Microsoft.  They truly value our feedback and the Team System MVPs really love and care for the product just as much and want to see it grow by leaps and bounds.  And when I say love and care for the product, you don't even understand! :) This is definitely a good fit and I'm honored to officially join the group.  So when do I get to learn the "secret handshake?"

Ed B.