Wednesday, July 31, 2013

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.

Tuesday, June 11, 2013

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.