Book description
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
- Copyright
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Preface
- 1. Software Development Methodologies for the Database World
-
2. Best Practices for Database Programming
- 2.1. Defensive Programming
- 2.2. Best Practice SQL Programming Techniques
- 2.3. Creating a Healthy Development Environment
- 2.4. Summary
- 3. Testing Database Routines
-
4. Errors and Exceptions
- 4.1. Exceptions vs. Errors
-
4.2. How Exceptions Work in SQL Server
- 4.2.1. Statement-Level Exceptions
- 4.2.2. Batch-Level Exceptions
- 4.2.3. Parsing and Scope-Resolution Exceptions
- 4.2.4. Connection and Server-Level Exceptions
- 4.2.5. The XACT_ABORT Setting
- 4.2.6. Dissecting an Error Message
- 4.2.7. SQL Server's RAISERROR Function
- 4.2.8. Monitoring Exception Events with Traces
- 4.3. Exception Handling
- 4.4. Transactions and Exceptions
- 4.5. Summary
- 5. Privilege and Authorization
-
6. Encryption
- 6.1. Do You Really Need Encryption?
- 6.2. SQL Server 2008 Encryption Key Hierarchy
- 6.3. Data Protection and Encryption Methods
- 6.4. Balancing Performance and Security
- 6.5. Implications of Encryption on Query Design
- 6.6. Summary
-
7. SQLCLR: Architecture and Design Considerations
- 7.1. Bridging the SQL/CLR Gap: The SqlTypes Library
- 7.2. Wrapping Code to Promote Cross-Tier Reuse
- 7.3. SQLCLR Security and Reliability Features
- 7.4. Performance Comparison: SQLCLR vs. TSQL
- 7.5. Enhancing Service Broker Scale-Out with SQLCLR
- 7.6. Summary
- 8. Dynamic T-SQL
-
9. Designing Systems for Application Concurrency
- 9.1. The Business Side: What Should Happen When Processes Collide?
- 9.2. Isolation Levels and Transactional Behavior
- 9.3. Preparing for the Worst: Pessimistic Concurrency
- 9.4. Hoping for the Best: Optimistic Concurrency
- 9.5. Embracing Conflict: Multivalue Concurrency Control
- 9.6. Sharing Resources Between Concurrent Users
- 9.7. Summary
- 10. Working with Spatial Data
- 11. Working with Temporal Data
- 12. Trees, Hierarchies, and Graphs
Product information
- Title: Expert SQL Server 2008 Development
- Author(s):
- Release date: January 2010
- Publisher(s): Apress
- ISBN: 9781430272137
You might also like
book
Microsoft® SQL Server 2008 R2 Unleashed
This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. …
book
Inside Microsoft® SQL Server™ 2005
A comprehensive, hands-on reference for database developers and administrators, this book focuses on advanced language features …
book
Programming Microsoft® SQL Server™ 2008
Extend your programming skills with a comprehensive study of the key features of SQL Server 2008. …
book
Inside Microsoft® SQL Server® 2008: T-SQL Programming
Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database …