SQL Saturday #30, Richmond Virginia, April 10, 2010

Thanks to all who attended my presentations at SQL Saturday on April 10.  Here are the materials from my two presentations:

The Business End of Data Modeling (2.5m powerpoint presentation)

Normalize Metadata For Data Integration Analysis (5.5m full version, zip including presentation and code samples)

Normalize Metadata For Data Integration Analysis (small) (2m reduced size version, graphics removed from ppt file)

Here are some quick notes for those looking to run the Metadata prototype:

The prototype metadata database includes SQL Server 2008 data definition language and data manipulation language (DDL and DML) needed to create the database and populate it with tables and columns from Microsoft’s AdventureWorksDW sample database. It also includes a sample requirements spreadsheet and source-to-target map, and SSIS jobs to load the spreadsheets to corresponding metadata tables. These define fictional requirements and mappings to populate the AdventureWorksDW FACTInternetSales table from tables in the AdventureWorks sample database.

AdventureWorks and AdventureWorksDW are available here: http://msftdbprodsamples.codeplex.com/Wikipage (accessed 4/14/2010)

3 thoughts on “SQL Saturday #30, Richmond Virginia, April 10, 2010

  1. Jake Eshler

    One of the links did not work from “SQL Saturday #30, Richmond Virginia, April 10, 2010
    Thanks to all who attended my presentations at SQL Saturday on April 10. Here are the materials from my two presentations:
    – Normalize Metadata For Data Integration Analysis (small) (2m reduced size version, graphics removed from ppt file)

  2. Pingback: Blueprint for Do-it-Yourself Metadata « Enterprise Information Management

Leave a Reply

Your email address will not be published. Required fields are marked *