Category Archives: Computers and Internet

Guerilla MDM via Microsoft MDS: Force Model Validation or TSQL Script to force set Validation Status ID ‘s

Posted on December 30, 2013 by

Using Metadata and code generation to programmatically set Validation Stats for all leaf members in an MDS Entity. Continue reading →

Posted in agile, Awarement, Computers and Internet, data profiling, Ira Whiteside, Mdm, MDS, MDS Stored Procedures, Metadata Mart, Table Variable TSQL | Tagged , , , , , , , , | Leave a comment

Microsoft BI Stack Leveraged with Vendor Add – In’s for Data Quality and Data Lineage

Posted on October 24, 2012 by

Lineage as it applies to data in Business Intelligence provides the capability see track back where data came from. Essentially it supports “Metric Decomposition” which is a process for breaking down a metric (business calculation) into separate parts. With this capability you can determine your data’s ancestry or Data DNA. Continue reading →

Posted in Awarement, Computers and Internet, data profiling, Donal Farmer, Extreme Scoping Agile SCRUM, Fuzzy Matching, Ira Whiteside, Kimball ETL (subsystem 1), MelissaData, Metadata Mart, SSIS, Uncategorized | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

SQL Saturday New York #158

Posted on August 11, 2012 by

Last Saturday August 4, 2012 we attended SQL Saturday #158 in New York. We (Tessie, Victoria and Brandon) were there educating folks on SSIS Data Quality for Melissa Data. For Actuality Business Intelligence and Melissa Data the event planning staff … Continue reading →

Posted in Computers and Internet, Ira Whiteside, MelissaData, SQL Saturday, SSIS, Tessie Whiteside, Uncategorized | Leave a comment

Master Data Services – SSIS MDM Load

Posted on January 20, 2010 by

    Master Data Services – SSIS MDM Load   Microsoft recently released Master Data Services in SQL Server 2008 R2 CTP. Without getting into the strategic benefits, definitions etc. of MDM(Master Data Management) this tool will be very helpful … Continue reading →

Posted in Computers and Internet | Leave a comment