{"id":70,"date":"2026-02-15T16:06:29","date_gmt":"2026-02-15T21:06:29","guid":{"rendered":"https:\/\/metadatagarage.com\/?page_id=70"},"modified":"2026-06-08T16:25:08","modified_gmt":"2026-06-08T20:25:08","slug":"shop-catalog","status":"publish","type":"page","link":"https:\/\/metadatagarage.com\/?page_id=70","title":{"rendered":"Shop Catalog"},"content":{"rendered":"\n<hr class=\"wp-block-separator has-text-color has-contrast-color has-alpha-channel-opacity has-contrast-background-color has-background is-style-default\" style=\"margin-top:var(--wp--preset--spacing--40);margin-bottom:var(--wp--preset--spacing--40)\"\/>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\">Here&#8217;s what you will have access to as a <strong>Subscriber<\/strong>:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-contrast-color has-alpha-channel-opacity has-contrast-background-color has-background is-style-default\" style=\"margin-top:var(--wp--preset--spacing--40);margin-bottom:var(--wp--preset--spacing--40)\"\/>\n\n\n\n<p class=\"has-accent-6-background-color has-background wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">The Mechanics Blog <\/span><\/strong>&#8211; Words of wisdom from the original &#8220;Information Sherpa&#8221; himself with an occasional gem from his sidekick, the &#8220;Metadata Mechanic&#8221;.<\/p>\n\n\n\n<p class=\"has-accent-6-background-color has-background wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">Shop Manuals <\/span><\/strong>&#8211; Texts and Diagrams sharing wisdom derived from experienced , &#8220;busted knuckle , data wrench wrangling&#8221; authors.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A<strong>bstracts<\/strong><\/li>\n\n\n\n<li><strong>&#8220;How To&#8221; Guides<\/strong><\/li>\n\n\n\n<li><strong>White Papers<\/strong><\/li>\n\n\n\n<li><strong>Books<\/strong><\/li>\n<\/ul>\n\n\n\n<p class=\"has-accent-6-background-color has-background wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">Blueprints<\/span><\/strong> &#8211; Standards, precision diagrams and code to help you build your data repository \u201cchassis\u201d to make sure your structure can perform at speed.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Modeling Standards<\/strong> &#8211; To help you make those data storage &#8220;racks&#8221; reliable, scalable, and high performing.&nbsp;\n<ul class=\"wp-block-list\">\n<li>Naming Standards in general<\/li>\n\n\n\n<li>Class Words and Data Types<\/li>\n\n\n\n<li>Abbreviations<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Data Models<\/strong> &#8211; Precision blueprints for your data repository \u201cchassis\u201d to ensuring your structure can perform at speed\n<ul class=\"wp-block-list\">\n<li>Logical Models &#8211; readable Entity &amp; Attribute names<\/li>\n\n\n\n<li>Physical Models &#8211; standardized \/ abbreviated Table &amp; Column names<\/li>\n\n\n\n<li>Data Dictionaries &#8211; Entity \/ Table and Attribute \/ Column descriptive definitions<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>DDL Scripts<\/strong> &#8211; SQL Server Data Definition Language code to create the database objects shown in the Data Models section supporting:\n<ul class=\"wp-block-list\">\n<li>a Metadata Repository<\/li>\n\n\n\n<li>Data Lineage Tracking with ETL Logic for\n<ul class=\"wp-block-list\">\n<li>Transformation Rules<\/li>\n\n\n\n<li>Validation Rules<\/li>\n\n\n\n<li>Disposition Rules<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Data Profiling<\/li>\n\n\n\n<li>Data Quality Scoring<\/li>\n\n\n\n<li>Multi-Source Discrepancy Tracking<\/li>\n\n\n\n<li>Reference Data<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Load Scripts for Reference Data<\/strong> for\n<ul class=\"wp-block-list\">\n<li>Geography<\/li>\n\n\n\n<li>Healthcare Code Sets<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-accent-6-background-color has-background wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">The Tool Box<\/span><\/strong> &#8211; Discount priced, downloadable technical data \u201cwrenches\u201d as ready to execute code.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Excel Templates<\/strong>\n<ul class=\"wp-block-list\">\n<li>Data Requirements Gathering &#8211; with non-compliance identification against your naming standards<\/li>\n\n\n\n<li>Data Quality Scoring &#8211; with configurable rules to calculate file summary and individual field scores, highlighting problem values<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>SQL Functions<\/strong>\n<ul class=\"wp-block-list\">\n<li>Data Pattern &#8211; to generate a generic alpha-numeric pattern representation of actual data values<\/li>\n\n\n\n<li>Clean String &#8211; to &#8220;strip out&#8221; unwanted characters &#8211; you specify &#8220;What-to-Keep&#8221; with a Regular Expression<\/li>\n\n\n\n<li>MD5 HASH &#8211; to generate a HASH value for the contents of the columns you choose &#8211; BINARY , VARBINARY and IMAGE data type columns are <em>not<\/em> supported<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>SQL Stored Procedures<\/strong>\n<ul class=\"wp-block-list\">\n<li>Data Profiling &#8211; Table Statistics<\/li>\n\n\n\n<li>Data Profiling &#8211; Column Statistics<\/li>\n\n\n\n<li>Data Profiling &#8211; Domain Statistics<\/li>\n\n\n\n<li>Data Profiling &#8211; Column Statistics Enhancements<\/li>\n\n\n\n<li>Data Profiling Suite &#8211; all 4 of the above<\/li>\n\n\n\n<li>Data Profiling &#8211; Data Quality Scoring Add-on<\/li>\n\n\n\n<li>Multi-Source Data Discrepancy Reconciliation<\/li>\n\n\n\n<li><strong>AI Custom Language Model<\/strong> &#8211; Metadata Narrative Generation from your Data Profiling statistics, prepping high-octane fuel from your raw \u201ccrude oil\u201d data so your AI models perform reliably &#8220;on the track&#8221;.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Parameter Controlled Scripts<\/strong>\n<ul class=\"wp-block-list\">\n<li>T-SQL\n<ul class=\"wp-block-list\">\n<li>Data Profiling &#8211; calls the Stored Procs with parameter values to gather and store the profiling statistics<\/li>\n\n\n\n<li>Data Quality Scoring &#8211; calls the Stored Procs with parameter values to calculate the DQ Scores<\/li>\n\n\n\n<li>Discrepancy Tracking &#8211; calls the Stored Procs with parameter values to log new or update existing discrepancies in values from any two sources<\/li>\n\n\n\n<li>Metadata Narrative Generation \u2013 creates a textual narrative from your Data Profiling statistics<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>PowerShell\n<ul class=\"wp-block-list\">\n<li>Metadata Narrative Splitter &#8211; breaks your Metadata textual narrative (a.k.a. \u201cChilton Manual\u201d \u00a0into Chapters that your AI engine can consume<br><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-center has-accent-6-background-color has-background wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">Subscriber&#8217;s Posts<\/span><\/strong> &#8211; A page where you get to share your                       *** <em>constructive<\/em> *** Suggestions \/ Questions \/ Complaints<\/p>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\"> <\/p>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\">&#8212; REMEMBER &#8212; <\/p>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\">&#8220;In a world where you can be anything, choose to be kind&#8221;<br><br><\/p>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\" style=\"border-width:10px;padding-top:var(--wp--preset--spacing--50);padding-bottom:var(--wp--preset--spacing--50)\">  <strong><span style=\"text-decoration: underline;\">How to Subscribe<\/span><\/strong><br><br>Put on your coveralls and <br>step inside the Metadata Garage <br>where two veterans with eighty plus years of <br>\u201c<em>grease under their data wrangling fingernails<\/em>\u201d <br>have gathered instructions, diagrams and code <br>while overhauling misfiring enterprise data engines.<br><br>Click the button below.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-nowrap is-layout-flex wp-container-core-buttons-is-layout-6addbbcc wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\">Subscribe<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s what you will have access to as a Subscriber: The Mechanics Blog &#8211; Words of wisdom from the original &#8220;Information Sherpa&#8221; himself with an occasional gem from his sidekick, the &#8220;Metadata Mechanic&#8221;. Shop Manuals &#8211; Texts and Diagrams sharing wisdom derived from experienced , &#8220;busted knuckle , data wrench wrangling&#8221; authors. Blueprints &#8211; Standards, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-70","page","type-page","status-publish","hentry"],"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"The Metadata Garage","distributor_original_site_url":"https:\/\/metadatagarage.com","push-errors":false,"_links":{"self":[{"href":"https:\/\/metadatagarage.com\/index.php?rest_route=\/wp\/v2\/pages\/70","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/metadatagarage.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/metadatagarage.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/metadatagarage.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/metadatagarage.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=70"}],"version-history":[{"count":30,"href":"https:\/\/metadatagarage.com\/index.php?rest_route=\/wp\/v2\/pages\/70\/revisions"}],"predecessor-version":[{"id":271,"href":"https:\/\/metadatagarage.com\/index.php?rest_route=\/wp\/v2\/pages\/70\/revisions\/271"}],"wp:attachment":[{"href":"https:\/\/metadatagarage.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}