Data Warehouse

This category contains 5 posts

Automatically Generating a Data Dictionary Using Extended Properties

“Documentation” The bane of our existence and we all hate creating it, don’t we?! I am always searching for ways to improve documentation through automation. Awhile ago I stumbled upon utilizing the extended properties of sql objects to store change management info. The T-SQL script at the bottom of the page produces a simple data … Continue reading