How do you group data from multiple columns into one comma separated string per row, grouped by another column? Here is a sample dataset and the query.
SQL SERVER – Get Date and Time From Current DateTime – SQL in Sixty Seconds #025 – Video
How do you get date and time separately from the current datetime? This sixty second video answers three common beginner questions with simple CONVERT scripts.
Fuzzy Name Matching With SOUNDEX and DIFFERENCE
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.
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 – 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 – Three Methods to Insert Multiple Rows into Single Table – SQL in Sixty Seconds #024 – Video
Tired of writing one INSERT per row? This SQL in Sixty Seconds video shows three methods to insert multiple rows into a single table.