One way is to find a couple of good SQL Server programing blogs and just read them.

Also the SQL for smarties books are a good source even though they are not SQL Server specific.