Just found a blog post by the Microsoft SQL Server Development Customer Advisory Team entitled How can SQL Server 2005 help me evaluate and manage indexes?. This post goes over 5 ways to analyze your index usage in SQL 2005. There looks to be some good technical information on this blog, worthy of any DBA in training.
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.