Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

Buy
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.

This book enables you to
  • Understand your data model’s physical elements, from storage to referential integrity
  • Provide programmability via stored procedures, user-defined functions, triggers, and .NET CLR integration
  • Normalize data models, one step at a time
  • Gather and interpret requirements more effectively
  • Learn an effective methodology for creating logical models
  • Overcome modeling problems related to entities, attribute, data types, storage overhead, performance, and relationships
  • Create physical models—from establishing naming guidelines through implementing business rules and constraints
  • Use SQL Server’s unique indexing capabilities, and overcome their limitations
  • Create abstraction layers that enhance security, extensibility, and flexibility
About the Author

Eric Johnson
(Microsoft SQL MVP)is the co-founder of Consortio Services and the primary database technologies consultant. His background in information technology is diverse, ranging from operating systems and hardware to specialized applications and development. He has even done his fair share of work on networks. Because IT is a way to support business processes, Eric has also acquired an MBA. All in all, he has ten years of experience with IT, much of it working with Microsoft SQL Server. Eric has managed and designed databases of all shapes and sizes. He has delivered numerous SQL Server training classes and Webcasts as well as presentations at national technology conferences. Most recently, he presented at TechMentor on SQL Server 2005 replication, reporting services, and integration services. In addition, he is active in the local SQL Server community, serving as the president of the Colorado Springs SQL Server Users Group. He is also the co-host of CS Techcast, a weekly podcast for IT professionals at www.cstechcast.com. You can find Eric’s blog at www.consortioservices.com/blog.

Joshua Jones
(MCTS, SQL Server 2005; MCITP, Database Administrator) is operating systems and database systems consultant with Consortio Services in Colorado Springs. There he provides training, administration, analysis, and design support for customers using SQL Server 2000 and 2005. In his seven years as an IT professional, he has worked in many areas of information technology, including Windows desktop support, Windows 2000 and 2003 server infrastructure design and support (AD, DNS, MS Exchange), telephony switch support, and network support. Josh has spoken at various PASS sponsored events about SQL Server topics such as 64-bit SQL Server implementation, reporting services administration, and performance tuning. He is also a co-host of CS Techcast, a weekly podcast for IT professionals at www.cstechcast.com.
(HTML tags aren't allowed.)

Deploying Rails Applications: A Step-by-Step Guide (Facets of Ruby)
Deploying Rails Applications: A Step-by-Step Guide (Facets of Ruby)
First you'll learn how to build out your shared, virtual, or dedicated host. Then, you'll see how to build your applications for production and deploy them with one step, every time. Deploying Rails Applications will take you from a simple shared host through a highly scalable clustered and balanced setup with Nginx.

See how to tell whether...

Semantic Web for the Working Ontologist, Second Edition: Effective Modeling in RDFS and OWL
Semantic Web for the Working Ontologist, Second Edition: Effective Modeling in RDFS and OWL

Since the first edition of Semantic Web for the Working Ontologist came out in June 2008, we have been encouraged by the reception the book has received. Practitioners from a wide variety of industries— health care, energy, environmental science, life sciences, national intelligence, and publishing, to name a few—have told...

LPIC 1 Certification Bible
LPIC 1 Certification Bible
Every other teenager and tens of thousands of university students have installed Linux and configured it for this job or that. That doesn't mean they're qualified to run Linux servers for a company that relies on them, regardless of what they may claim on their résumés. Your claim to real professional Linux competence will be...

Smarty PHP Template Programming And Applications
Smarty PHP Template Programming And Applications
A step-by-step guide to building PHP web sites and applications using the Smarty templating engine
- Bring the benefits of Smarty to your PHP programming
-Give your designers the power to modify content and layout without PHP programming
-Produce code that is easier to debug, maintain, and modify
-Useful for both Smarty
...
Facilities Management Handbook, Fourth Edition
Facilities Management Handbook, Fourth Edition
Comprehensive, authoritative up to date coverage of all aspects of facilities management

Now in this fourth edition, the Facilities Management Handbook has been fully updated from the acclaimed previous editions, continuing its status as an invaluable resource to those working in facilities
...
Nutrient-Gene Interactions in Cancer
Nutrient-Gene Interactions in Cancer

The complete mapping of the human genome, along with the development of sophisticated molecular technologies, has accelerated research on the relationship between nutrients and genes. This has led to compelling evidence garnered from epidemiological and experimental observations supporting the idea that the interaction between nutrients and...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy