Duration: 60 minutes
Track: Application & Database Development
Explore the most important topics in database design and discuss examples of where design mistakes can lead to bad data, poor performance, and other headaches that your future self would love to avoid!
Choosing the right data types, normalization, and choosing the right column names can allow for easier database development, make planning for future changes simpler, and avoid the roadblocks often associated with poor design.
Using live demos, we will explore the potential disasters that can occur when poor design decisions are made. We'll then correct the mistakes and bask in the glory of beautiful design.
Database design is about anticipating the future needs of your organization and using that information to make smart decisions. Good decision-making here can reflect positively on everyone you work with, so show off your design skills and feel good about the TSQL you write!
To access the session recording, please login or register first:
Not a PASS member? Click here to register.
Database Administrator, CommerceHub
Ed has over 15 years of experience in database and systems administration, developing a passion for performance optimization, database design, and making things go faster. He has spoken at many SQL... View More