Australasia's Biggest Online Store

We won't be beaten by anyone. Guaranteed

Expert SQL Server 2008 Development
By

Rating
New or Used: 22 copies from $48.91
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 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
Product Details

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

About the Author

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.

Look for similar items by category
People also searched for
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Expert SQL Server 2008 Development on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Back to top