In this interactive session, we will explore the system catalog views that tell us about the schema and structure of your database. Navigating the views via their logical relationships, we will examine representative queries and their utility for learning about your db design.
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.