Mastering SQL server 2008 [[Book] /]
Michael Lee, Gentry Bieker.
- Indianapolis, Ind. : Wiley Pub., c2009.
- xxvi, 766 p. : ill. ; 24 cm.
- Serious skills .
- Serious skills. .
Includes index.
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.