Expert SQL Server 2008 Development

By Adam Machanic

Focuses on sound development and architectural practices that will help you become a better developer, capable of designing high-performance, robust, maintainable database applications.

Full Description

  • ISBN13: 978-1-4302-7213-7
  • User Level: Intermediate to Advanced
  • Publication Date: January 5, 2010
  • Available eBook Formats: EPUB, MOBI, PDF
  • Print Book Price: $54.99
  • eBook Price: $38.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full 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

What you’ll learn

  • How to productively handle errors and exceptions.
  • How to exploit features for managing spatial and temporal data.
  • How to manage tree-structured data using the new, hierarchid type.
  • How to write code that easily survives high concurrency.
  • How to program defensively.
  • How to create proper and reusable test environments for your code.
  • How to secure code and data through encryption and proper application of privilege.

Who this book is for

SQL Server developers and administrators.

Table of Contents

Table of Contents

  1. Software Development Methodologies for the Database World
  2. Best Practices for Database Programming
  3. Testing Database Routines
  4. Errors and Exceptions
  5. Privilege and Authorization
  6. Encryption
  7. SQLCLR: Architecture and Design Considerations
  8. Dynamic T-SQL
  9. Designing Systems for Application Concurrency
  10. Working with Spatial Data
  11. Working with Temporal Data
  12. Trees, Hierarchies, and Graphs
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

No errata are currently published