Mastering SQL Server 2008
As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.
1014273996
Mastering SQL Server 2008
As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.
59.99 In Stock
Mastering SQL Server 2008

Mastering SQL Server 2008

Mastering SQL Server 2008

Mastering SQL Server 2008

Overview

As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.

Product Details

ISBN-13: 9780470289044
Publisher: Wiley
Publication date: 01/20/2009
Series: Serious Skills
Pages: 792
Product dimensions: 7.30(w) x 9.20(h) x 1.90(d)

About the Author

Michael Lee, MCT, MCITP, MCPD, SCJP, has been teaching SQL Server since 1995. Over the last 13 years, Michael has provided trainingand consulting services in SQL Server and Enterprise Data Architecture to companies across the U.S. and Europe. Gentry Bieker, MCT, MCITP, MCDBA, MCSE, has been a consultant, mentor, and trainer since 1998. He has been architecting, developing, and administering SQL Server databases since version 6.0.

Read an Excerpt

Click to read or download

Table of Contents

1. Overview of Microsoft SQL Server 2008.

2. Understanding SQL Server Architecture.

3. Databases, Files, and Resource Management.

4. Tables and CRUD Operations.

5. Procedural programming.

6. Managing Data Integrity.

7. SQL Server and XML.

8. Managing User Security.

9. Data Recovery.

10. Monitoring SQL Server Activity.

11. Using the SQL Server Agent Service.

12. Data Availability and Distribution.

13. SQL Server Data Security.

14. Indexing Strategies for Query Optimization.

15. Transactions and Locking Strategies.

16. Using Resource Governor and Policy-Based Management.

17. SQL Server and the .NET Client.

18. Leveraging the SQL Server .NET CLR.

19. Using Spatial Data.

20. Service Oriented Architecture and the Service Broker.

21. Full Text Search Services.

From the B&N Reads Blog
Page 1 of

Related Subjects

Computers
Database Management
Applications & Languages - Databases
SQL Server
SQL Server 2008
Computers
Database Management
Applications & Languages - Databases
SQL Server
SQL Server 2008

Customer Reviews