You are previewing Mastering SQL Server® 2008.
O'Reilly logo
Mastering SQL Server® 2008

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

  1. Cover Page
  2. Title Page
  3. Copyright
  4. Dear Reader
  5. Dedication
  6. Acknowledgments
  7. About the Authors
  8. Contents at a Glance
  9. Contents
  10. Introduction
    1. Who Should Read This Book
    2. The Mastering Series
    3. What Is Covered in This Book
    4. How to Contact the Authors
  11. Chapter 1: Overview of Microsoft SQL Server 2008
    1. SQL Server in the Enterprise World
    2. Installing SQL Server 2008
    3. The SQL Server Tool Set
    4. The Bottom Line
  12. Chapter 2: Understanding SQL Server Architecture
    1. Essential Internals
    2. The SQL Server System Catalog
    3. Datatyping
    4. The Bottom Line
  13. Chapter 3: Databases, Files, and Resource Management
    1. Planning a Database
    2. Creating Databases
    3. Managing Databases, Files, and Filegroups
    4. The Bottom Line
  14. Chapter 4: Tables and CRUD Operations
    1. Designing Data Storage
    2. Creating and Dropping SQL Server Tables
    3. Selecting Data from a Table
    4. Modifying Data
    5. The Bottom Line
  15. Chapter 5: Procedural Programming
    1. Procedural Structures
    2. Stored Procedures
    3. Views
    4. User-Defined Functions
    5. Using Synonyms
    6. The Bottom Line
  16. Chapter 6: Managing Data Integrity
    1. Understanding Data Integrity Controls
    2. Working with Constraints
    3. Working with DML Triggers
    4. Rule and Default Objects
    5. The Bottom Line
  17. Chapter 7: SQL Server and XML
    1. Returning XML from SQL Server Using FOR XML
    2. The xml Datatype
    3. Validating XML with Schemas
    4. Implementing XQuery
    5. XML Indexes
    6. The Bottom Line
  18. Chapter 8: Managing User Security
    1. The SQL Server Security Infrastructure
    2. Implementing SQL Server Principals and Authentication
    3. Implementing Permissions in SQL Server
    4. The Bottom Line
  19. Chapter 9: Data Recovery
    1. Transaction Architecture
    2. Backup and Restore Strategies
    3. Performing Backups
    4. Performing Restores
    5. Other Issues
    6. The Bottom Line
  20. Chapter 10: Monitoring SQL Server Activity
    1. Using System Monitor
    2. Using SQL Profiler & Trace
    3. DDL Triggers
    4. Event Notifications
    5. The Bottom Line
  21. Chapter 11: Using the SQL Server Agent Service
    1. SQL Agent and Automation
    2. Creating Jobs
    3. Creating Alerts
    4. Creating Operators
    5. Scripting the SQL Agent
    6. The Bottom Line
  22. Chapter 12: Data Availability and Distribution
    1. Overview of SQL Server Availability and Distribution Options
    2. Database Log Shipping
    3. Database Mirroring
    4. Replication
    5. The Bottom Line
  23. Chapter 13: SQL Server Data Security
    1. Understanding the SQL Server Key Infrastructure
    2. Using Transparent Data Encryption
    3. Encrypting Data Using SQL Server
    4. Module Signing
    5. The Bottom Line
  24. Chapter 14: Indexing Strategies for Query Optimization
    1. Index Architecture
    2. Creating and Managing Indexes
    3. Special Index Considerations
    4. The Bottom Line
  25. Chapter 15: Transactions and Locking
    1. The SQL Server Locking Architecture
    2. Transaction Management
    3. Distributed Transactions
    4. Getting Transaction and Locking Information
    5. The Bottom Line
  26. Chapter 16: Using the Resource Governor and Policy-Based Management
    1. The Resource Governor
    2. Understanding Policy-Based Management
    3. The Bottom Line
  27. Chapter 17: SQL Server and the .NET Client
    1. Understanding ADO.NET
    2. Special Operations in ADO.NET
    3. Introducing Language Integrated Query (LINQ)
    4. LINQ and the Entity Framework
    5. The Bottom Line
  28. Chapter 18: SQL Server and the Common Language Runtime
    1. CLR Concepts
    2. Creating Managed Objects in SQL Server
    3. Deploying Managed Objects in SQL Server
    4. Managing CLR Security
    5. Security Considerations
    6. The Bottom Line
  29. Chapter 19: Using Spatial Data
    1. Spatial Data Concepts
    2. Implementing the Geometry Type
    3. Implementing the Geography Type
    4. Spatial Indexes
    5. The Bottom Line
  30. Chapter 20: Service-Oriented Architecture and the Service Broker
    1. The Essentials of Service-Oriented Architecture
    2. Understanding the Service Broker
    3. Implementing Service Broker
    4. The Bottom Line
  31. Chapter 21: Full-Text Search Services
    1. Full-Text Architecture
    2. Creating Full-Text Indexes
    3. Writing Full-Text Queries
    4. The Bottom Line
  32. Appendices
  33. Appendix A: The Bottom Line
    1. Chapter 1: Overview of Microsoft SQL Server 2008
    2. Chapter 2: Understanding SQL Server Architecture
    3. Chapter 3: Databases, Files, and Resource Management
    4. Chapter 4: Tables and CRUD Operations
    5. Chapter 5: Procedural Programming
    6. Chapter 6: Managing Data Integrity
    7. Chapter 7: SQL Server and XML
    8. Chapter 8: Managing User Security
    9. Chapter 9: Data Recovery
    10. Chapter 10: Monitoring SQL Server Activity
    11. Chapter 11: Using the SQL Server Agent Service
    12. Chapter 12: Data Availability and Distribution
    13. Chapter 13: SQL Server Data Security
    14. Chapter 14: Indexing Strategies for Query Optimization
    15. Chapter 15: Transactions and Locking
    16. Chapter 16: Using the Resource Governor and Policy-Based Management
    17. Chapter 17: SQL Server and the .NET Client
    18. Chapter 18: SQL Server and the Common Language Runtime
    19. Chapter 19: Using Spatial Data
    20. Chapter 20: Service-Oriented Architecture and the Service Broker
    21. Chapter 21: Full-Text Search Services
  34. Appendix B: SQL Server Analysis Services Overview
    1. Designing the Data Warehouse
    2. Understanding Analysis Services
  35. Appendix C: SQL Server 2008 Reporting Services
    1. Configuring Reporting Services
    2. Creating a Simple Report
    3. Deploying the Report
  36. Index