Expert SQL Server 2008 Development

✍ Scribed by Alastair Aitchison, Adam Machanic (auth.)

• Publisher: Apress
• Year: 2009
• Tongue: English
• Leaves: 448
• Edition: 1
• Category: Library

✦ Synopsis

Expert SQL Server 2008 Development is aimed at SQL Server developers ready to move beyond Books Online. Author and experienced developer Alastair Aitchison shows you how to think about SQL Server development as if it were any other type of development. You'll learn to manage testing in SQL Server and to properly deal with errors and exceptions. The book also covers critical, database-centric topics such as managing concurrency and securing your data and code through proper privileges and authorization.

Alastair places focus on sound development and architectural practices that will help you become a better developer, capable of designing high-performance, robust, maintainable database applications. He shows you how to apply notable features in SQL Server such as encryption and support for hierarchical data. If developing for SQL Server is what puts the bread on your table, you can do no better than to read this book and to assimilate the expert-level practices that it provides.

• Promotes expert-level practices
• Leads to high performance, scalable code
• Improves productivity, getting you home in time for dinner

✦ Table of Contents

Front Matter....Pages i-xix
Software Development Methodologies for the Database World....Pages 1-22
Best Practices for Database Programming....Pages 23-48
Testing Database Routines....Pages 49-70
Errors and Exceptions....Pages 71-100
Privilege and Authorization....Pages 101-119
Encryption....Pages 121-158
SQLCLR: Architecture and Design Considerations....Pages 159-194
Dynamic T-SQL....Pages 195-232
Designing Systems for Application Concurrency....Pages 235-281
Working with Spatial Data....Pages 283-319
Working with Temporal Data....Pages 321-370
Trees, Hierarchies, and Graphs....Pages 371-418
Back Matter....Pages 419-433

✦ Subjects

Programming Techniques