Mastering SQL server 2008
Saved in:
Main Authors: | |
---|---|
Group Author: | |
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. |