Wonderfully excellent advice already posted here. I'll add one more. Check out Jason Strate's Monthly DBA Checklist[/url]. It's a pretty good starting point for ensuring you have the basics in place.
"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