Books & Videos

Table of Contents

  1. Chapter 1 Designing a Data Access Strategy

    1. Before You Begin

    2. Lesson 1: Designing Data Access Technologies

    3. Lesson 2: Designing a Data Access Connection

    4. Lesson 3: Designing a Data Access Object Model

    5. Case Scenario: Selecting a Data Access Strategy

    6. Suggested Practices

    7. References

    8. Chapter Summary

  2. Chapter 2 Designing Database Queries

    1. Before You Begin

    2. Lesson 1: Writing Database Queries

    3. Lesson 2: Improving Query Performance

    4. Lesson 3: Retrieving Data from XML Sources

    5. Case Scenario: Creating a Plan Guide

    6. Suggested Practices

    7. References

    8. Chapter Summary

  3. Chapter 3 Designing a Cursor and Caching Strategy

    1. Before You Begin

    2. Lesson 1: Designing Caching Strategies

    3. Lesson 2: Designing a Cursor Strategy

    4. Lesson 3: Designing Efficient Cursors

    5. Case Scenario: Evaluating Cursor Performance

    6. Suggested Practices

    7. References

    8. Chapter Summary

  4. Chapter 4 Advanced Query Topics

    1. Before You Begin

    2. Lesson 1: Administering a SQL Server Service

    3. Lesson 2: Querying with Multiple Active Result Sets

    4. Lesson 3: Performing Asynchronous Processing

    5. Case Scenario: Automating a Data-Mining Solution

    6. Suggested Practices

    7. References

    8. Chapter Summary

  5. Chapter 5 Data Integrity and Error Handling in SQL Server 2005

    1. Before You Begin

    2. Lesson 1: Validating Data and Permissions

    3. Lesson 2: Detecting and Reacting to Errors

    4. Case Scenario: Validating Data Integrity

    5. Suggested Practices

    6. Reference

    7. Chapter Summary

  6. Chapter 6 Designing Transactions and Transaction Isolation

    1. Before You Begin

    2. Lesson 1: Understanding the Available Transaction Isolation Levels

    3. Lesson 2: Designing Transactions and Optimizing Locking

    4. Case Scenario: Optimizing Locking

    5. Suggested Practices

    6. References

    7. Chapter Summary

  7. Chapter 7 Optimizing SQL Server 2005 Performance

    1. Before You Begin

    2. Lesson 1: Optimizing and Tuning Queries

    3. Lesson 2: Optimizing Index Strategies

    4. Lesson 3: Optimizing Data Storage

    5. Case Scenario: Optimizing Query Performance

    6. Suggested Practices

    7. References

    8. Chapter Summary

  8. Chapter 8 Improving Database Application Performance

    1. Before You Begin

    2. Lesson 1: Scale Database Applications

    3. Lesson 2: Resolving Performance Problems

    4. Case Scenario: Diagnosing a Performance Problem

    5. Suggested Practices

    6. References

    7. Chapter Summary

  1. Appendix Case Scenario Answers

    1. Chapter 1: Selecting a Data Access Strategy

    2. Chapter 2: Creating a Plan Guide

    3. Chapter 3: Evaluating Cursor Performance

    4. Chapter 4: Automating a Data-Mining Solution

    5. Chapter 5: Validating Data Integrity

    6. Chapter 6: Optimizing Locking

    7. Chapter 7: Optimizing Query Performance

    8. Chapter 8: Diagnosing a Performance Problem

  2. Appendix References

    1. Design Appropriate Data Access Technologies

    2. Design an Appropriate Data Access Object Model

    3. Write Queries

    4. Design Caching Strategies

    5. Design a Cursor Strategy

    6. Design Applications that Administer a SQL Server Service

    7. Scale Database Applications

    8. Resolve Performance Problems

    9. Manage Concurrency by Selecting the Appropriate Transaction Isolation Levels

    10. Design Code that Uses Transactions

    11. Optimize and Tune Queries for Performance

    12. Design Code that Validates Input Data and Permissions

  3. Appendix SQL Server 2005 Architecture and Internals

    1. Hardware Trends and Their Effect on SQL Server 2005

    2. SQLOS

    3. Common Language Runtime (CLR) Host

    4. SQL Server 2005 Storage Engine

    5. SQL Server 2005 Query Engine

    6. SQL Server 2005 Index Internals

    7. Database Encryption

  4. Glossary

  5. Appendix Additional SQL Server Resources for Administrators

  6. Appendix Additional SQL Server Resources for Developers

  7. Appendix Additional Resources for Developers: Advanced Topics and Best Practices

  8. Appendix Additional Windows (R2) Resources for Administrators

  9. Appendix System Requirements

    1. Hardware Requirements

    2. Software Requirements