Depending on what you're trying to do, you may want to use a different account for production and non-production environments in order to prevent any chance of a non-production environment accessing production inappropriately. Other than that, I'd follow the advice of the previous post.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning