Table of Contents

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