A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 (Addison-Wesley Microsoft Technology Series) free ebook download.

application developers tend to ignore. The writing style is conversational and accessible to both database design novices and seasoned pros alike. Readers who are responsible for designing, implementing, and managing databases will benefit greatlyfrom Joshua’s and Eric’s expertise.”—Anil Desai, Consultant, Anil Desai, Inc.“Almost every IT project involves data storage of some kind, and for most that means a relational database management system (RDBMS). This bookis written for a database-centric audience (database modelers, architects, designers, developers, etc.). The authors do a great job of showing us how to take a project from its initial stages of requirements gathering all the way through toimplementation. Along the way we learn how to handle some of the real-world design issues that typically surface as we go through the process.“The bottom line here is simple. This is the book you want to have just finished reading when yourboss says ‘We have a new project I would like your help with.’”—Ronald Landers, Technical Consultant, IT Professionals, Inc.“The Data Model is the foundation of the application. I’m pleased to see additional books beingwritten to address this critical phase. This book presents a balanced and pragmatic view with the right priorities to get your SQL server project off to a great start and a long life.”—Paul Nielsen, SQL Server MVP,SQLServerBible.com“This is a truly excellent introduction to the database design methodology that will work for both novices and advanced designers. The authors do a good job at explaining the basics of relational database modeling and howthey fit into modern business architecture. This book teaches us how to identify the business problems that have to be satisfied by a database and then proceeds to explain how to build a solid solution from scratch.”—Alexzander N.Nepomnjashiy, Microsoft SQL Server DBA, NeoSystems North-West, Inc.“A Developer’s Guide to Data Modeling for SQL Server explains the concepts and practice of data modeling with a clarity that makes the technologyaccessible to anyone building databases and data-driven applications.“Eric Johnson and Joshua Jones combine a deep understanding of the science of data modeling with the art that comes with years of experience. If you’re new to datamodeling, or find the need to brush up on its concepts, this book is for you.”—Peter Varhol, Executive Editor, Redmond MagazineModel SQL Server Databases That Work Better, Do More, and Evolve More SmoothlyEffective 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, theoreticalor 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 SQLServer 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 datamodels, 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 intoeffective 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 froma companion Web site. This book enables you toUnderstand your data model’s physical elements, from storage to referential integrityProvide programmability via stored procedures, user-defined functions, triggers, and.NET CLR integrationNormalize data models, one step at a timeGather and interpret requirements more effectivelyLearn an effective methodology for creating logical modelsOvercome modeling problems related toentities, attribute, data types, storage overhead, performance, and relationships Create physical models—from establishing naming guidelines through implementing business rules and constraintsUse SQL Server’s unique indexingcapabilities, and overcome their limitationsCreate abstraction layers that enhance security, extensibility, and flexibility

ISBN: 0321497643, Author: Eric Johnson, Publisher: Addison-Wesley Professional, Pages: 304, Publication Date: 2008-07-04