SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

A Really Simple Data Dictionary

Last month I sat down with Blain Barton and TechNet Edge in an interview (Blain Barton Interviews Raymond James Chad Miller on PowerShell) and described a PowerShell-based solution for providing a classic centralized data dictionary of various data sources to our IT users. I’m pleased to announce I’ve started a CodePlex project called Really Simple Data Dictionary or RSDD which demonstrates the coding techniques used to develop the solution.

What is RSDD?

RSDD is a meta data collector for SQL Server and Oracle.  RSDD imports meta data into a central SQL Server repository from INFORMATION_SCHEMA or equivalent supported systems views. RSDD is packaged as PowerShell module, to get started you’ll need PowerShell 2.0 and SQL Server instance to host the repository. Check out the documentation for setup instructions. Once you’ve collected the meta data, the data can easily be exposed via reports or PowerPivot (see screenshots).

Next Steps

Interested in Working on RSDD?

Contact me if you’re interested in contributing to RSDD

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. Chad is the Project Coordinator/Developer of the Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is a frequent speaker at users groups, SQL Saturdays and Code Camps.


No comments.

Leave a Comment

Please register or log in to leave a comment.