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
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to email@example.com.
Microsoft® SQL Server™ 2005: Applied Techniques Step by Step
The mentors at Solid Quality Learning combine deep technical expertise and real-world implementation experience to provide advanced solutions and training for the Microsoft SQL Server database platform.