Post reply

Data Dictionary ideas

  • June 12, 2012 at 4:50 pm

    #259243

    Hi,

    We have a Data Warehouse which is on a SQL Server 2008 R2 server.

    There are a few Tables now on this server and no one knows how the tables are created i.e. maybe a derived table or created via an ssis package.

    Has anyone created a Data Dictionary before? If so what information did you add that helped you understand your tables better?

    I was thinking of querying the msdb to get a list of all the tables and fields then exporting this to a excel document, I want to then write what this table does and what each field relates and where it is getting its source information from; also how this table gets populated i.e. ssis package andwhat the Job Name is on the Job Activity Monitor,

    Any ideas?

    Thanks

  • June 12, 2012 at 7:14 pm

    #1500118

    Have a look at Brad McGehee's latest article on server documentation. It is fantastic and has a lot more than what your current needs are

    http://www.sqlservercentral.com/blogs/aloha_dba/2012/06/05/do-you-document-your-sql-server-instances/

  • October 7, 2015 at 10:53 am

    #1832071

    Have a look at those samples

    HTML[/url]

    PDF

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply