• Code
  1. Move constants out.
  2. Move SQL queries to DAL.
• Database
  1. Reference tables should not be conglomerated.
• Thinking
  1. 1 hour policy

if (conditions)
{
    statement1;
}
else
{
    statement1;
}
 

statement1;

if (conditions)
{
}
else
{
}

        Deployment Procedure
        sequence number to script execution