Microsoft SQL Server 2005: Applied Techniques Step by Step


book cover
Microsoft® SQL Server™ 2005: Applied Techniques Step by Step
By  Solid Quality Learning 
...............................................
Publisher: Microsoft Press
Pub Date: April 19, 2006
Print ISBN-10: 0-7356-2316-3
Print ISBN-13: 978-0-7356-2316-3
Pages: 496
 

Table of Contents  | Index
overview

A skill-building, learn-by-doing tutorial to help developers and database administrators with basic product knowledge begin to master SQL Server 2005.



book cover
Microsoft® SQL Server™ 2005: Applied Techniques Step by Step
By  Solid Quality Learning 
...............................................
Publisher: Microsoft Press
Pub Date: April 19, 2006
Print ISBN-10: 0-7356-2316-3
Print ISBN-13: 978-0-7356-2316-3
Pages: 496
 

Table of Contents  | Index

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