Description
Microsoft Press Microsoft SQL Server 2005 Applied Techniques Step by Step 2006 Edition by Solid Quality Learning
Learn more-advanced skills to design, build, test, deploy, and maintain SQL Server databases-one step at a time. Ideal for developers who understand database essentials, this learn-by-doing tutorial offers practical guidance, code samples, and a collection of techniques to help you solve real-world business problems. Discover how to:Manage data access with server logins and user and server roles Implement a disaster recovery strategy Use aggregate functions to compute totals and complex statistical values Optimize query performance by managing IO statistics and designing indexesWork with remote data sources-including third-party databases Provide remote access through the Internet or a middle-tier service interface Manage transactions, implement error handlers, and define isolation levels Go further and work with SQL Server Reporting Services and Notification Services Includes a CD featuring:All practice exercises Code samples For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook. Table of contents : - Part 1 - How to create a SQL Server Database to store your application data 1 - Choosing which Application Data to store in your Database 2 - Basic Database Security Principles 3 - Disaster Recovery Techniques to protect your Database 4 - Transferrinfyour Database to other systems Part 2 - How to Query Data from SQL Server 5 - Computing Aggregates 6 - Improving Query Performance 7 - Building Queries Dynamically 8 - Working with Data from Remote Data Sources 9 - Reading SQL Server Data from the Internet Part 3 - How to Modify Data in SQL Server 10 - Using Transactions to provide Safe Database Concurrency 11 - Keeping History Data 12 - Introduction to Reporting Services 13 - Introduction to Notification Services Index