5+ Database Design Blunders and How to Avoid Them

What’s going on in your physical data model? How many people can or will update it to match the reality of what’s going on in your databases? Who actually decides what goes into the database design?  How do you choose your primary keys? How do you implement them? Are your datatypes the right ones for the data?

In this presentation we discuss five physical data modeling mistakes that cost you dearly: performance snags, development delays, bugs, and professional respect.  Includes a slightly irreverent look the state of database design in the data profession as well as a look at how to spot them and avoid them.

Audience members will also be able to contribute their war stories of design fails, WTHs and D'ohs.
Presented by Karen Lopez at SQLBits X
  • Downloads
  • SpeakerBIO
    Karen Lopez is a Sr. Project Manager and Architect at InfoAdvisors. As a Microsoft MVP, she specializes in the practical application of data management principles.  Her speaking style is interactive and engaging. An active blogger, speaker and social networker as @datachick, she hopes to influence attendees to love their data.

    She is a chronic volunteer, Advisor to the Data Management Association's International Board, a frequent speaker on diversity in technology, data policy, open data and emerging technologies and a sometimes runner.  She's also known for her enthusiasm for all things space-related.
    http://blog.infoadvisors.com http://blog.infoadvisors.com/index.php/feed/
  • Video