Login to TFS Server or Other Server Automatically with out providing credentials daily

This is very interesting and useful.

Please follow below steps.

1. Go to Control Panel  , Go to UserAccounts 
2. Click on Credentials Manager
3. You will find "Windows Credentials" section.
4. Click on "Add a Windows credential" link.
5. Enter the valid IP address and credentials and click on OK.
6. From next time , you will login by default and need not enter credentials.

SQL Tips and Tricks

1. Use Keyboard shortcuts in Tools->options for generating regular results sets like sp_helptext and sp_help.
2. When you see ant procedure breaking the If condition logic even the business logic is fine , the best and foremost thing you need to do is to verify the DataType of the variable used in If condition.Remember if you mistakenly used bit for variable x and doing the comparison of integer say x>5 it always go to else condition.The reason the Bit contains 1 values in true case and 0 value in false case.