|
About the Book
Take your database skills to the next level with this hands-on, step-by-step guide.
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 indexes •Work 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
Related Books
Inside Microsoft® SQL Server® 2008: T-SQL Programming
Inside Microsoft® SQL Server® 2008: T-SQL Querying
Microsoft® SQL Server® 2008 Analysis Services Step by Step
Customer Rating
Number of Ratings: 8
| Average Rating: |
|
|