I'm a huge fan of the book SQL Server 2008 Bible. Look in to that one if you'd like to learn more about programming in SQL Server.

Someone else mentioned the stairway series on this site. Another good source.

And of course, visit these forums. There are a lot of great people here offering help on a daily basis.

Mark