SOUNDEX and DIFFERENCE can surface duplicate customers, and they can also flag people who only sound alike. Here is how I keep the review honest.
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.
How to Evaluate a New Database Without Fooling Yourself
Use realistic data and workload tests to evaluate a database, checking correctness, latency, recovery, compatibility, and the full operating cost.
SQL Server Architecture Terminology: A Beginner’s Guide by Anil Kumar
SQL Server architecture terminology is easier to follow when each term can be seen in a running instance. This guest introduction by Anil Kumar covers instances, storage, memory, the transaction log and SQLOS, with tested queries on SQL Server 2025.
SQL SERVER – A Brief Note on SET TEXTSIZE
Is there any difference between the LEFT function and SET TEXTSIZE? A quick script shows how each one trims a long VARCHAR(MAX) value in the results.
What to Collect When SQL Server Is Slow
Collect SQL Server diagnostic data in a useful order: waits, active requests, blockers, execution plans, and file IO during the slow period.