| | 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 |