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 – Fun Post – Connecting Same SQL Server using Different Methods
Five ways to connect to the same SQL Server on your local box: 127.0.0.1, a single dot, (local), localhost and the computer name. Can you name more?
SQL SERVER – FIX ERROR – Cannot connect to . Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)
Error 18452 said my login was from an untrusted domain while I connected from my own machine to 127.0.0.1. Here is the small change that caused it.
VECTOR_SEARCH in SQL Server 2025: Finding Similar Rows With a Vector Index
VECTOR_SEARCH returns the rows whose vectors sit closest to a vector you give it, and a vector index makes that search approximate and fast. This post builds a six-row test with hand-made numbers on SQL Server 2025, with no AI model, and lists the limits the test showed.
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.