Red-gate has some decent and current t-sql programming books and mssql dev books available for free.

http://www.red-gate.com/community/books/