Pro SQL Server 2008 Relational Database Design and Implementation

1. Front Matter

   Pages i-xxvi

   PDF

2. Introduction to Database Concepts

   Pages 1-32

3. The Language of Data Modeling

   Pages 33-70

4. Conceptual Data Modeling

   Pages 71-115

5. The Normalization Process

   Pages 117-175

6. Implementing the Base Table Structures

   Pages 177-271

7. Protecting the Integrity of Your Data

   Pages 273-338

8. Patterns and Query Techniques

   Pages 339-384

9. Securing Access to the Data

   Pages 385-445

10. Table Structures and Indexing

    Pages 447-497

11. Coding for Concurrency

    Pages 499-553

12. Considering Data Access Strategies

    Pages 555-594

13. Back Matter

    Pages 595-650

    PDF

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data.

• Solid foundation in best practices and relational theory
• Maximize SQL Server features to enhance security, performance, scalability
• Thorough treatment from conceptual design to an effective, physical implementation

• Microsoft SQL Server
• RDBMS
• SQL
• SQL Server 2008
• data model
• database design
• relational database

Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology (Compass.net) in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.

Policies and ethics