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 emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
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 slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.