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?
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.
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.
Anniversary of SQL Wait Stats Book: Memories From the First Year
A year ago I published my second book, SQL Wait Stats. On this first anniversary of SQL Wait Stats book, here are some memories from that journey: the blog series behind it, the work with my co-author, and why September 1st is a special day for me.
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.
Insert Multiple Rows in SQL Server: SQL in Sixty Seconds #024
To insert multiple rows in SQL Server, use separate INSERT statements, UNION ALL or one VALUES list. The tests here compare all three on SQL Server 2025, including failures, the 1,000 row limit and the time for 1,000 rows.










