Which part of SQL Server are you after, server administration, database administration, or T-SQL coding. If the latter, I like two books,
Transact-SQL Programming
Kline, Gould & Zanevsky
O'Reilly
and
SQL Queries for Mere Mortals
Viescas & Hernandez
Addison Wesley