Book description
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.
Table of contents
- Cover Page
- Title Page
- Copyright
- Dear Reader
- Dedication
- Acknowledgments
- About the Authors
- Contents at a Glance
- Contents
- Introduction
- Chapter 1: Overview of Microsoft SQL Server 2008
- Chapter 2: Understanding SQL Server Architecture
- Chapter 3: Databases, Files, and Resource Management
- Chapter 4: Tables and CRUD Operations
- Chapter 5: Procedural Programming
- Chapter 6: Managing Data Integrity
- Chapter 7: SQL Server and XML
- Chapter 8: Managing User Security
- Chapter 9: Data Recovery
- Chapter 10: Monitoring SQL Server Activity
- Chapter 11: Using the SQL Server Agent Service
- Chapter 12: Data Availability and Distribution
- Chapter 13: SQL Server Data Security
- Chapter 14: Indexing Strategies for Query Optimization
- Chapter 15: Transactions and Locking
- Chapter 16: Using the Resource Governor and Policy-Based Management
- Chapter 17: SQL Server and the .NET Client
- Chapter 18: SQL Server and the Common Language Runtime
- Chapter 19: Using Spatial Data
- Chapter 20: Service-Oriented Architecture and the Service Broker
- Chapter 21: Full-Text Search Services
- Appendices
-
Appendix A: The Bottom Line
- Chapter 1: Overview of Microsoft SQL Server 2008
- Chapter 2: Understanding SQL Server Architecture
- Chapter 3: Databases, Files, and Resource Management
- Chapter 4: Tables and CRUD Operations
- Chapter 5: Procedural Programming
- Chapter 6: Managing Data Integrity
- Chapter 7: SQL Server and XML
- Chapter 8: Managing User Security
- Chapter 9: Data Recovery
- Chapter 10: Monitoring SQL Server Activity
- Chapter 11: Using the SQL Server Agent Service
- Chapter 12: Data Availability and Distribution
- Chapter 13: SQL Server Data Security
- Chapter 14: Indexing Strategies for Query Optimization
- Chapter 15: Transactions and Locking
- Chapter 16: Using the Resource Governor and Policy-Based Management
- Chapter 17: SQL Server and the .NET Client
- Chapter 18: SQL Server and the Common Language Runtime
- Chapter 19: Using Spatial Data
- Chapter 20: Service-Oriented Architecture and the Service Broker
- Chapter 21: Full-Text Search Services
- Appendix B: SQL Server Analysis Services Overview
- Appendix C: SQL Server 2008 Reporting Services
- Index
Product information
- Title: Mastering SQL Server® 2008
- Author(s):
- Release date: January 2009
- Publisher(s): Sybex
- ISBN: 9780470289044
You might also like
book
Microsoft® SQL Server® 2008 For Dummies®
If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get …
book
Beginning, Microsoft® SQL Server® 2008 Administration
SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will …
book
Professional Microsoft® SQL Server® 2008 Administration
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, …
book
Microsoft® SQL Server™ 2008 Reporting Services Unleashed
Microsoft® SQL Server™ 2008 Reporting Services Unleashed Michael Lisin Jim Joseph Amit Goyal The authoritative, example-rich …