Microsoft SQL Server 2005: Applied Techniques Step by Step Book/CD Package (Pro-Step by Step Developer)

by SolidQualityLearning (Author)

• Used

  Paperback
  2006

  $3.24

  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

  For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.