Category Archives: Table Variable TSQL

Merry Christmas Data Classification, Feature Engineering , Data Governance. ‘How to’ do it and some code take a look

Posted on November 30, 2021 by irawarrenwhiteside

Therefore I decided, to update some of the techniques and code patterns, I’ve used in the past regarding the information value chain and or record linkage , and we are going to make the results available with associated business and code examples initially with SQL Server and data bricks plus python Continue reading →

Posted in agile, Awarement, Big Data, blocking index, Data Governance, data profiling, data quality, data quality mart, Dimensional Model, Download Complete Data Profiling Kit - TSQL, ETL, extreme scoping, Extreme Scoping Agile SCRUM, Fuzzy Matching, Guerilla MDM, Guerilla MDS, Ira Whiteside, Machine Learning, Master Relationship Management, Mdm, Metadata Mart, MRM, Self Service Semantic BI, serverless, SQL Saturday, SQL Server Central, SSIS, stroke, Table Variable TSQL, Uncategorized | Tagged , , , , , , , | Leave a comment

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

Posted on December 30, 2013 by irawarrenwhiteside

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 , , , , , , , , | 1 Comment