SQL Server Magazine - The Smart Guide to Building World-Class Applications
I had the good fortune of reading a few introductory issues a few years back. Among other articles, there was one I read about joins by Itzk Ben Gann to do really complex querying which enlightened me. Since that day, my outlook towards T-Sql has changed. I recently acquired Itzk's Advanced T-SQL Book. Go get it!!