Mastering SQL server 2008

Saved in:
Bibliographic Details
Main Authors: Lee Michael, 1966-
Group Author: Bieker Gentry.
Published: Wiley Pub.,
Publisher Address: Indianapolis, Ind.
Publication Dates: c2009.
Literature type: Book
Language: English
Series: Serious skills
Subjects:
Carrier Form: xxvi, 766 p.: ill. ; 24 cm.
ISBN: 9780470289044 (paper/website)
047028904X (paper/website)
Index Number: TP311
CLC: TP311.138
Call Number: TP311.138/L479
Contents: 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.