A Developer's Guide to Data Modeling for SQL Server

Ebook Details

Authors

Eric Johnson , Joshua Jones

Year 2008
Pages 304
Publisher Addison-Wesley Professional
Language en
ISBN 9780321497642
File Size 2.16 MB
File Format PDF
Download Counter 1,647

Ebook Description

Model SQL Server Databases That Work Better, Do More, and Evolve More Smoothly Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you’re modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn’t enough: models that don’t reflect SQL Server’s unique real-world strengths and weaknesses often lead to disastrous performance. A Developer’s Guide to Data Modeling for SQL Server is a practical, SQL Server-specific guide to data modeling for every developer, architect, and administrator. This book offers you invaluable start-to-finish guidance for designing new databases, redesigning existing SQL Server data models, and migrating databases from other platforms. You’ll begin with a concise, practical overview of the core data modeling techniques. Next, you’ll walk through requirements gathering and discover how to convert requirements into effective SQL Server logical models. Finally, you’ll systematically transform those logical models into physical models that make the most of SQL Server’s extended functionality. All of this book’s many examples are available for download from a companion Web site.

SitemapModern Leatherwork for Makers: Traditional Craft Techniques Meet CNC and 3D Printing | Get It Free無料ガイドライン | Women's Composure Episode 93