Mastering SQL server 2008 [electronic resource] / Michael Lee, Gentry Bieker.
Series: Serious skills | Sybex mastering seriesc2009Description: 1 online resource (xxvi, 766 p.) : illOther title:- Mastering Microsoft SQL server 2008
- SQL server 2008

Description based on print version record.
"Install, configure and manage SQL server 2008. Optimize, troubleshoot, and secure your database"--Cover.
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.
Includes index.