At work, I've been getting more involved with hosting and database stuff. I currently do some very minor admin work with my limited SQL knowledge from college 11 years ago, but I'd like to expand my abilities in this area. It's all Microsoft SQL Server, so apparently it's Transact-SQL.
As someone who went to school for programming, but never ended up working as a programmer, what books or web sites would you recommend for me to get acquainted with T-SQL? I'm looking for more of an introductory-level resource, which can prepare me for something more advanced once I'm comfortable. To give you an idea of my current knowledge and understanding, I struggle with understanding JOINs, and wouldn't be able to write my own stored procedure.
Thanks very much.