Lee Michael, Bieker Gentry. Mastering Microsoft SQL Server 2008

Sybex, 2009. — 792 p. — ISBN-10: 047028904X, ISBN-13: 978-0-470-28904-4.Install, Configure, and Manage SQL Server 2008. Optimize, Troubleshoot and Secure Your Database.Contents at a Glance.
Overview of Microsoft SQL Server 2008.
Understanding SQL Server Architecture.
Databases, Files, and Resource Management.
Tables and CRUD Operations.
Procedural Programming.
Managing Data Integrity.
SQL Server and XML.
Managing User Security.
Data Recovery.
Monitoring SQL Server Activity.
Using the SQL Server Agent Service.
Data Availability and Distribution.
SQL Server Data Security.
Indexing Strategies for Query Optimization.
Transactions and Locking.
Using the Resource Governor and Policy-Based Management.
SQL Server and the .NET Client.
SQL Server and the Common Language Runtime.
Using Spatial Data.
Service-Oriented Architecture and the Service Broker.
Full-Text Search Services.