O'Reilly logo



Start Free Trial

No credit card required

Microsoft® SQL Server™ 2005: Applied Techniques Step by Step

Book Description

SQL Server 2005 is Microsoft’s next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. This book shows readers with fundamental SQL Server skills, as well as new-to-topic but experienced database developers, techniques to design, build, test, deploy, and maintain better SQL Server databases. The format is a hands-on, sequential, developer’s companion, providing beyond-the-basics guidance. This book is not a feature-driven reference manual, but a highly practical learning experience demonstrating how to build database solutions to solve business problems.

Table of Contents

  1. Copyright
  2. Introduction
  3. Acknowledgments
  4. How to Create a SQL Server Database to Store Your Application Data
    1. Choosing Which Application Data to Store in Your Database
      1. Where to Store Application Settings
      2. Where to Store User Settings
      3. Where to Store XML Documents
      4. Where to Store External Application Files
      5. Conclusion
    2. Basic Database Security Principles
      1. Designing Network Security to Secure Your Database System
      2. Managing Access to SQL Server Instances
      3. Managing Access to SQL Server Databases
      4. Managing Access to Schemas
      5. Managing Access to Tables and Columns
      6. Managing Access to Programmable Objects
      7. Conclusion
    3. Disaster Recovery Techniques to Protect Your Database
      1. Using Full Database Backups
      2. Using Differential Backups
      3. Using Transaction Log Backups
      4. Recovering a Database
      5. Scheduling Backups Using the SQL Maintenance Plan Wizard
      6. Conclusion
    4. Transferring Your Database to Other Systems
      1. Using Backup and Restore to Transfer Your Data
      2. Using Detach and Attach to Transfer Your Data
      3. Using Replication to Transfer Your Data
      4. Using SSIS to Transfer Your Data
      5. Automating and Scheduling the Transfer of Your Data
      6. Conclusion
  5. How to Query Data from SQL Server
    1. Computing Aggregates
      1. Counting Rows
      2. Computing Totals and Subtotals
      3. Computing Running Totals
      4. Computing Statistical Values
      5. Designing Your Own User-Defined Aggregates Using the CLR
      6. Conclusion
    2. Improving Query Performance
      1. Understanding Query Plans
      2. Creating Indexes to Provide Faster Query Execution
      3. Tuning Queries Using the Database Engine Tuning Advisor
      4. Conclusion
    3. Building Queries Dynamically
      1. A User Interface for Building Queries
      2. Retrieving Information about the Tables in a Database
      3. Sorting and Filtering Dynamically
      4. Parameters and Security in Dynamic Queries
      5. Conclusion
    4. Working with Data from Remote Data Sources
      1. Reading Data from Remote Sources at the Middle Tier
      2. Reading Data from Remote Sources in SQL Server
      3. Inserting, Updating, or Deleting Data from Remote Sources in SQL Server
      4. Conclusion
    5. Reading SQL Server Data from the Internet
      1. Direct Access to SQL Server
      2. Interoperability with Other Systems through HTTP Endpoints
      3. Access to SQL Server through an Extra Layer
      4. Conclusion
  6. How to Modify Data in SQL Server
    1. Using Transactions to Provide Safe Database Concurrency
      1. Business Transactions and SQL Server Transactions
      2. Defining Transactions in SQL Server
      3. Managing Transaction Isolation
      4. Transactions in ADO.NET
      5. Conclusion
    2. Keeping History Data
      1. Taking a Snapshot of Your Database
      2. Summarizing Data in History Tables
      3. Summarizing Data in Indexed Views
      4. Tracking Changes Using Audit Columns and Audit Tables
      5. Conclusion
    3. Introduction to Reporting Services
      1. Requirements for a Reporting Solution
      2. Design Considerations
      3. Reporting Services Architecture
      4. Creating a Basic Report
      5. Conclusion
    4. Introduction to Notification Services
      1. A Notification Services Scenario
      2. Gathering Requirements
      3. Building the Application
      4. Running the Application
      5. Conclusion
  7. Index