Topic:
A good database design goes deeper than the rules that Codd gave us. We need to leverage SQL Server to help enforce the Codd’s. In this class we’ll look at some common questions like: I have foreign keys, why do I need foreign key constraints too? Why are smart keys not so smart? If I use an identity field, do I still need to declare it as a primary key? The wrong answers to these questions can slow your queries down over time and even create bad data. Join me in my session as we look at demos to understand how silent killers can begin to lurk in your schema.
Speaker:
Mickey Stuewe, Sr. Database Developer Quick Bridge Funding
Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design.
She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQL Saturdays, User Groups and other events.
When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often…just ask her children.