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)