2026-03-04
3,200 reads
Utsav Verma
Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL
When using only an LSN to track which changes you have processed, you can lose data. This article shows how to avoid this problem.
2025-12-15
2,630 reads
Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions
Learn about the new string similarity functions in Azure SQL Database.
2025-03-28
7,283 reads
Implementing Vector Datatype with Azure SQL Server
This article shows how to insert data into a database, create embeddings, and then use this data to search the data with a natural language interface.
2025-02-14
2,826 reads
Vector DB implementation using FAISS
Searching for relevant information in vast repositories of unstructured text can be a challenge. This article explains a Python-based approach to implementing an efficient document search system using FAISS (Facebook AI Similarity Search) for Vector DB and sentence embeddings, which can be useful in applications like chatbots, document retrieval, and natural language understanding. In this […]
2025-01-17
3,489 reads
Enhancing SQL Server Searches with Elasticsearch and Python
Learn how to get started with Elasticsearch with data in your SQL Server database.
2024-10-14
2,492 reads
2019-12-24 (first published: 2017-08-24)
11,816 reads
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers