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 responses to “SQL Saturday #30, Richmond Virginia, April 10, 2010”
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)
Jake,
Thanks for reading and reporting the broken link, which I’ve just now fixed.
Bob
[…] article describes a working SQL Server prototype (found here) that shows how a data integration team can build its own custom metadata database based on […]