Main Session: "Detecting and Correcting Database Design Anomalies" by Troy Ketsdever
It's nice when, as database developers, we have a clean slate to work with. Most of the time, however, we inherit and must support existing designs and implementations (or, perhaps even worse - revisit a design we deployed long ago before we "knew the ropes"). To add to the challenge, more often than not documentation of the database doesn't exist or is out-of-date with respect to the production system. In this session, we'll look at some tools, techniques, and scripts that will accelerate your understanding of that beast you're now in charge of supporting and extending, with a focus on identifying and correcting design and implementation anomalies.
Bio: Troy Ketsdever is a data architect with over 15 years of commercial software development experience, and has maintained a love/hate relationship with SQL Server since version 4.2. In addition to his "day job", Troy enjoys writing articles and presenting at user groups on a variety of database design and implementation topics. His main objective and vision is “making the right information available to the right people at the right time”. When not attempting to wrangle logical conundrums (aka, constraint-less dbs), he enjoys empirical testing via field trials of various aspects of fluid dynamics, particularly with respect to gravitational interactions on deformable dynamic structures in gaseous mediums.