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
Software Development Methodologies for the Database World Best
Practices for Database Programming Testing Database Routines Errors
and Exceptions Privilege and Authorization Encryption SQLCLR:
Architecture and Design Considerations Dynamic T-SQL Designing
Systems for Application Concurrency Working with Spatial Data
Working with Temporal Data Trees, Hierarchies, and Graphs
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!