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
image

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.

image

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

clip_image006

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

image

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….

clip_image002

More here

https://msdn.microsoft.com/en-us/library/ms174205.aspx

How to find the last interactive logons in Windows using PowerShell

Use the following powershell script to find the last users to login to a box since a given date, in this case the 21st April 2022 at 12pm un...