how to use excel filter

select header row, then data, then filter, then header row has drop down for filter

C# read last line of text file

string sLast = File.ReadLines(@"e:\file.txt").Last();

you need to have

using System.Linq;

also dot net frame work 4

How to do file search on Team foundation server

VS2012 can do wild card search, right click on collection then find.

VS2013, no more wild card search

http://tfssearchcode.codeplex.com/

team foundation server 2012 http 500 error after install dot net frame work 3.5 sp1

After updated the Windows 2008 R2 server with the dotnet framework 3.5 SP1, all of sudden  got TF31001 error below:

TF31001: cannot connect to team foundation server at my_server. The server returned the following error: Please contact your administrator. There was an error contacting at server.

Technical information (for administrator): HTTP code 5000 Internal Server Error

After Google search found the solution below:

Visual studio format short cut keys

Team foundation server - move from SQL express to SQL server

If you do not want SQL express and SQL server is in another box, then note that SQL server authentication has to use active directory domain authentication. there is no provision of using SQL authentication (TFS 2013). Not sure if I can suggest that somewhere.

http://www.codeproject.com/Articles/664027/Migrate-Team-Foundation-Server-s-SQL-Server-to-ano