Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible . Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.
I know, I know, we're up to SQL Server 2012 now and I'm reviewing a book on SQL Server 2008, but I'm sure Paul Nielsen has updated his book for the latest version of SQL Server, so on that basis, buy whatever the latest version is that you need.
This is, without doubt, the best one-stop-shop I've ever seen for learning about SQL Server. It starts with a bit of database theory, takes you into installation, how to write SQL queries, then into every aspects of database administration you could want to know - security, speeding things up, SQL Server Analysis, manipulation in Excel, you name it.
What makes it all work is Nielsen's unabashed enthusiasm for SQL Server and what it can do. Definitely not a book anyone is going to read cover-to-cover (I skimmed most of it), but definitely one that you'll be able to use as a starting point for most things you want to know.