Expert SQL Server 2008 Development

Authors: Aitchison, Alastair, Machanic, Adam

Download source code
  • Productively handle errors and exceptions
  • Exploit features for managing spatial and temporal data
  • Managing tree-structured data using the new, hierarchid type
  • Write code that easily survives high concurrency
  • Programming defensively
  • Create proper and reusable test environments for your code
  • Secure code and data through encryption and proper application of privilege
see more benefits

Buy this book

eBook $39.99
price for USA
  • ISBN 978-1-4302-7212-0
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $54.99
price for USA
  • ISBN 978-1-4302-7213-7
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

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

About the authors

Alastair Aitchison has more than eight years of experience as a management information consultant, specializing in the design and deployment of online reporting systems. For the last three years, he has been employed as a reporting and analysis manager at Aviva, the world's fifth largest insurance group. In this role, he has championed the use of spatial data in corporate applications including the geographic analysis of risk patterns, plotting the success of regional marketing campaigns, and understanding the impact of major weather incidents. Alastair is a Microsoft Office Specialist Master Instructor and has delivered numerous training courses to individuals and small groups on a range of software packages.

Table of contents (12 chapters)

  • Software Development Methodologies for the Database World

    Aitchison, Alastair (et al.)

    Pages 1-22

  • Best Practices for Database Programming

    Aitchison, Alastair (et al.)

    Pages 23-48

  • Testing Database Routines

    Aitchison, Alastair (et al.)

    Pages 49-70

  • Errors and Exceptions

    Aitchison, Alastair (et al.)

    Pages 71-100

  • Privilege and Authorization

    Aitchison, Alastair (et al.)

    Pages 101-119

Buy this book

eBook $39.99
price for USA
  • ISBN 978-1-4302-7212-0
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $54.99
price for USA
  • ISBN 978-1-4302-7213-7
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Expert SQL Server 2008 Development
Authors
Copyright
2009
Publisher
Apress
Copyright Holder
Alastair Aitchison and Adam Machanic
eBook ISBN
978-1-4302-7212-0
DOI
10.1007/978-1-4302-7212-0
Softcover ISBN
978-1-4302-7213-7
Edition Number
1
Number of Pages
430
Topics