Extended Properties: The Metadata Layer Your Analysts Will Thank You For

This session shows how to turn SQL Server’s extended properties into a practical, analyst‑friendly metadata layer. You’ll see how to document tables, columns, relationships, data sources, and refresh cycles directly inside the database, and how to surface that information through a simple SSRS report that analysts can actually use. Its a clear, repeatable approach for building documentation that stays accurate, lives with the data, and reduces the constant “what does this table do” questions

By the end of this session, attendees will understand; The advantages to using extended properties to document tables and their columns. How this method can reduce the back and forth between engineering and analysis teams. How this can be baked into table development processes.