Table of Contents

Copyright

Brief Table of Contents

Table of Contents

List of Figures

List of Tables

List of Listings

MVP contributors and their chapters

Preface

Acknowledgments

About War Child

About this Book

About SQL Server MVPs

1. Database design and architecture

Chapter 1. Louis and Paul’s 10 key relational database design ideas

1. Denormalization is for wimps

2. Keys are key

3. Generalize, man!

4. Class <> table

5. Data drives design

6. Sets good, cursors bad

7. Properly type data

8. Extensibility through encapsulation

9. Spaghetti is food, not code

10. NOLOCK = no consistency

Summary

About the authors

Chapter 2. SQL Server tools for maintaining data integrity

Protection tools

Data types

NULL specification

Uniqueness constraints ...

Get SQL Server MVP Deep Dives now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial