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 rolesImplement a disaster recovery strategy Use aggregate functions to compute totals and complex statistical valuesOptimize query ...
Read More
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 rolesImplement a disaster recovery strategy Use aggregate functions to compute totals and complex statistical valuesOptimize query performance by managing IO statistics and designing indexesWork with remote data sources--including third-party databasesProvide remote access through the Internet or a middle-tier service interface Manage transactions, implement error handlers, and define isolation levelsGo further and work with SQL Server Reporting Services and Notification Services Includes a CD featuring: All practice exercisesCode samples For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Read Less