作者:Adam Machanic , Hugo Kornelis , Lara Rubbelke
出版日期:May 2007
出版社:Apress
页数:472
ISBN:ISBN10: 1-59059-729-X 978-1-59059-729-3
文件格式:PDF
While building on the skills you already have, Expert SQL Server 2005 Developmentwill help you become an even better developer by focusing on bestpractices and demonstrating how to design high–performance,maintainable database applications.
This book starts by reintroducing the database as a integral part ofthe software development ecosystem. You’ll learn how to think about SQLServer development as you would any other software development. Forexample, there’s no reason you can’t architect and test databaseroutines just as you would architect and test application code. Andnothing should stop you from implementing the types of exceptionhandling and security rules that are considered so important in othertiers, even if they are usually ignored in the database.
You’ll learn how to apply development methodologies like these toproduce high–quality encryption and SQLCLR solutions. Furthermore,you’ll discover how to exploit a variety of tools that SQL Serveroffers in order to properly use dynamic SQL and to improve concurrencyin your applications. Finally, you’ll become well versed inimplementing spatial and temporal database designs, as well asapproaching graph and hierarchy problems.