Press "Enter" to skip to content

Day: July 8, 2025

Writing Back to a Fabric Data Warehouse via UDF

Jon Vöge continues a series on write-back options into Microsoft Fabric:

In that article, we took advantage of some of the built-in sample code from the User Data Function editor, as well as some great code examples from Sujata: Example User data functions for Translytical task flows · GitHub

The problem? All of these samples use SQL Databases in Fabric as the backend item.

Jon switches this from a SQL database into a Fabric Data Warehouse, and notes some of the challenges along the way.

Leave a Comment

k Nearest Neighbors Search in Elasticsearch

Govind Singh Rawat looks for nearby documents:

Businesses are increasingly relying on intelligent search capabilities to enhance customer experience, automate insights, and unlock the potential of unstructured information. Elasticsearch, a leading distributed search and analytics engine, is at the heart of many such systems. One of its powerful and lesser-known capabilities is support for k-nearest neighbors (k-NN) search, a method particularly useful for similarity-based retrieval in domains such as semantic search, recommendation engines, and image recognition.

This article delves into what Elasticsearch and k-NN search are, how the two are integrated, and how to configure and optimize k-NN in Elasticsearch for real-world applications.

Click through for a high-level primer on the topic, as well as a few links to additional resources.

Leave a Comment

Event Streaming in Microsoft Fabric

Rayis Imayev streams some data:

In my post last week (https://datanrg.blogspot.com/2025/06/salesforce-cdc-data-integration.html), I talked about Salesforce Change Data Capture (CDC) event data streaming, where the initial event destination was file storage in Azure. But what if we anticipate a higher volume of incoming Salesforce source data or the addition of a new data feed? This could create the need for an alternative method of managing incoming events.

Read on to learn more.

Leave a Comment

Troubleshooting Network-Related or Instance-Specific Error

Aaron Bertrand has started a new series:

This is the first in a series of articles meant to provide practical solutions to common issues. In this post, we’ll talk about one of the most pervasive error messages out there:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

Read on to see what a variety of potential solutions to this problem. I was going to joke “It’s always DNS” but Aaron actually has a section on DNS in there.

Leave a Comment