There's some good advice below. I'm not a programmer (vastly different field), but the most important things you can do are to:

• get to know your technical people; their skills, and their personalities

• trust your technical people when they say something is difficult to do.

These two steps will help you get a lot of 'good will' from your team and make them feel like you've got their back.