Monday, 20 July 2015

The case of the disappearing TFS task board

So after wondering where all our tasks had disappeared to, it turns out that someone had changed the default Area path, and ticked it in the _admin/_areas section of the portal.

This has the knock on affect of removing any items from the task board that are not under ticked area paths, hence the stuff that was in our task board disappeared, even though the items were all still there in TFS and accessible via team explorer.

Wednesday, 15 July 2015

Work Item finding with advanced search criteria in Visual Studio 2013

Hi guys

Something that's proving very useful to me now is the fact that you can use advanced search functionality in the quick search box in Visual Studio 2013 to find tickets that you're after.

Example 1,

1. Hit Ctrl+# to enter the team explorer search box

2. Drop down the arrow, and click the assigned to

3. Hit enter

This will then find all the work items assigned to you by default, although you can change the name to someone else to see what they're working on e.g.


Example 2 ,

1. Hit Ctrl+# to enter the team explorer search box

2. Type "Stack Rank":3.75

3. Hit Enter

You'll then get back all items where the stack rank is equal to 3.75


Other search examples as follows:

For all work items that have been changed on a given date

"Changed Date":2015-07-14

For all work items authorized by someone

"Authorized As":"Name Here"

For all bugs changed today

T:"Bug" "Changed Date":2015-01-14

For all items that you uploaded to TFS today

"Authorized As":"@Me" "Changed Date":2015-07-14

That last one is particularly useful, if you've just forgotten the task number you checked in and closed


Wednesday, 8 July 2015

SQL Management Studio short cuts

Hi guys

Not sure how many of you already knew this, but stumbled across a couple of SQL management studio shortcuts today that I was previously unaware of, and hit quite by accident.

Subsequently discovered that you can pre-configure your own as well, in  Tools, Options,  Keyboard….


More here

How to Fix a Humax HDR FOX T2 PVR that will not stay powered on

Issue When you attempt to power on your Humax the standby orange light goes blue for a moment, and then powers off automatically again. ...