There are a whole lot of resources out there.

www.jumpstarttv.com - short (3-5 minute), specific how-to videos

http://channel9.msdn.com/Tags/ - videos on just about everything microsoft. Over 200 on SQL Server 2008 alone.

www.sqlpass.org - the Official Professional Association of SQL Server web site. It has some resources which include Virtual Chapter user groups that meet monthly and more are constantly being added. Check out the upcoming 24 hours of PASS[/url].

Quest Software Webcasts - free webcasts on SQL Server and some on Quest products but many general SQL Server ones. Check out Quest Connect

SQLServerPedia - has video podcasts as well.

This site has some videos as well.

I'm sure there are others as well. Good luck.