{"id":78977,"date":"2026-11-10T19:53:16","date_gmt":"2026-11-10T19:53:16","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=78977"},"modified":"2026-11-10T19:57:19","modified_gmt":"2026-11-10T19:57:19","slug":"rewritten-sql-server-5741","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=78977","title":{"rendered":"Data Cleansing with SQL Server: DQS Knowledge Bases and a Modern Alternative"},"content":{"rendered":"<p>The legacy Data Quality Services workflow used a knowledge base to identify acceptable values, detect likely matches, and clean imported records. Modern workflows can preserve those goals without requiring DQS.<\/p>\n<h2>Concept and purpose<\/h2>\n<p>Domain rules identify permissible patterns, mappings, and reference values. The key challenge is deciding which transformations are safe to automate and which should be reviewed by a human.<\/p>\n<h2>Example or practical exercise<\/h2>\n<p>Suppose customer city values contain inconsistent capitalization and whitespace. A staging query can normalize case and trim spaces; a trusted CityReference table can identify approved names; uncertain spellings should be flagged rather than blindly replaced.<\/p>\n<h2>Good practices<\/h2>\n<p>Track original and corrected values, rule versions, approval identity, and validation outcomes. Test false-positive matches and retain a rollback or reprocessing path.<\/p>\n<h2>Version and compatibility notes<\/h2>\n<p>Data Quality Services is removed from SQL Server 2025. Historical DQS server\/client installation tutorials apply to earlier supported releases, not new SQL Server 2025 deployments.<\/p>\n<hr\/>\n<p><strong>AI content disclosure:<\/strong> This article is AI-generated, based on <a href=\"https:\/\/bangla.sitestree.com\/?p=5741\">an existing Open Education article (original post 5741)<\/a>. New explanations and examples may be included; it is not necessarily a transcript of any video linked in the original. You may reuse the generated text with or without attribution to this site. Third-party works and trademarks retain their rights. <strong>AI can make mistakes<\/strong>, so verify the details against official documentation and test before applying to real databases.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The legacy Data Quality Services workflow used a knowledge base to identify acceptable values, detect likely matches, and clean imported records. Modern workflows can preserve those goals without requiring DQS.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[20,182],"tags":[466],"class_list":["post-78977","post","type-post","status-publish","format-standard","hentry","category-information-technology","category---blog","tag-sql-server","item-wrap"],"jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":78963,"url":"http:\/\/bangla.sitestree.com\/?p=78963","url_meta":{"origin":78977,"position":0},"title":"SQL Server Data Quality Services: Knowledge Bases and Cleansing (Legacy)","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"Data Quality Services (DQS) was used to cleanse data through domain knowledge and supervised matching. An older DQS project typically created a knowledge base, applied its rules to source records, and reviewed ambiguous results.","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78966,"url":"http:\/\/bangla.sitestree.com\/?p=78966","url_meta":{"origin":78977,"position":1},"title":"Data Quality Server and Client: SQL Server Legacy Installation Notes","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"Data Quality Server and Data Quality Client belonged to SQL Server's historical DQS feature set, enabling knowledge-driven data profiling, cleansing and review.","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78980,"url":"http:\/\/bangla.sitestree.com\/?p=78980","url_meta":{"origin":78977,"position":2},"title":"Installing SQL Server Data Quality Services: Legacy Server and Client Overview","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"The Data Quality Server and Client in older SQL Server releases supported data profiling, domain knowledge, cleansing and matching projects. This article preserves the concept while clarifying discontinued support.","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78927,"url":"http:\/\/bangla.sitestree.com\/?p=78927","url_meta":{"origin":78977,"position":3},"title":"Data Mining with Excel and SQL Server: Legacy Tools and Modern Alternatives","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"Excel and SQL Server have been used together for extracting, cleaning, exploring, and modelling business data. It is important to distinguish current analytical workflows from historical SQL Server Analysis Services data","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78950,"url":"http:\/\/bangla.sitestree.com\/?p=78950","url_meta":{"origin":78977,"position":4},"title":"Migrating Legacy PHP SQL Server Stored Procedure Code to Supported Drivers","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"Older PHP tutorials used the obsolete mssql_* extension for SQL Server procedure calls. A modern rewrite should preserve the application behaviour while changing the database access layer.","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78964,"url":"http:\/\/bangla.sitestree.com\/?p=78964","url_meta":{"origin":78977,"position":5},"title":"SQL Server Master Data Services: Entities, Models, and Governance (Legacy)","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"Master Data Services (MDS) historically helped organizations manage shared reference entities such as customers, products, and locations. It addressed governance rather than ordinary application transactions.","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78977"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78977\/revisions"}],"predecessor-version":[{"id":79039,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78977\/revisions\/79039"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78977"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}