A review of SQL Server 2012 Data Quality Services with Melissa Data from the Azure Datamarket, used to clean name and address records from an Excel sheet.
SQL SERVER – Why Do We Need Data Quality Services – Importance and Significance of Data Quality Services (DQS)
Computers miss what people notice, like an age of 300 or P. Dave versus Pinal Dave. I explain the importance and significance of Data Quality Services (DQS).
SQL SERVER – Configuring Interactive Cleansing Suggestion Min Score for Suggestions in Data Quality Services (DQS) – Sensitivity of Suggestion
Why does DQS give poor cleansing suggestions? A reader asked, and the answer is the interactive cleansing Min Score for Suggestions setting.
SQL SERVER – Unable to DELETE Project in Data Quality Projects (DQS)
A reader followed my DQS guide, made his own projects and then was unable to delete a project in Data Quality Projects. Here is his email and my answer.
SQL SERVER – Step by Step Guide to Beginning Data Quality Services in SQL Server 2012 – Introduction to DQS
A step by step introduction to Data Quality Services in SQL Server 2012 for beginners: build a Knowledge Base from an Excel file and use it to spot bad data.
SQL SERVER – DQS Error – Cannot connect to server – A .NET Framework error occurred during execution
Opening the DQS client, I hit a long .NET Framework error from SetDataQualitySessions and could not connect. Here is that DQS Error and how I worked through it.
SQL SERVER – Installing Data Quality Services (DQS) on SQL Server 2012
Installing Data Quality Services on SQL Server 2012? The DQS client has its own installer, and it needs Master Data Services and IIS first.