We are building a new data platform with Microsoft Fabric and we’re using the warehouse for our “gold layer”. We don’t have real-time ingestion or analytic requirements, but we have a use case where we want to send an alert if a certain threshold is reached. Ideally, the alert is sent when a SQL query returns a result set.
2026-10-21
In part 4 of this series, we look at using CROSS APPLY to filter in a function.
2026-10-19
1,692 reads
How to build an app through an LLM: switching from CoPilot to Claude, a directional term-lookup feature
2026-10-19
This article shows two scenarios, tested independently, with the full scripts and the real numbers from each run.
2026-10-16
2,042 reads
I eventually found an explanation for this error message that, while not completely satisfactory, did lead me to diagnose wider-reaching I/O issues on the affected instance and led me to a better understanding of latching in general.
2026-10-16
A SQL Server upgrade left a log shipping secondary unable to accept transaction logs. Re-seeding it without touching the primary or its mirror is straightforward in principle — drop, restore full + diff + log with NORECOVERY, hand back to the job — but three undocumented traps will stop you along the way. Here's what they are and how to get past them.
2026-10-14
1,066 reads
Should SQL Server databases enforce foreign key constraints? A veteran DBA breaks down the real arguments
2026-10-14
Learn how to normalize values in Power BI to allow you to compare disparate different data.
2026-10-12
1,095 reads
Since the transition from DTS to SSIS, I have found myself looking for alternative ways to do simple tasks such as exporting data from SQL Server into text files. SSIS is a far more powerful tool than DTS, but I generally try to stay away from it for simple operations. With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.
2026-10-12
See how security in SSAS tabular models might not work as you expect, and how you could easily fail an audit.
2026-10-09
954 reads
This post shows you how to install containerd as the container runtime for Kubernetes...
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
By Steve Jones
This month I want to look at a few of the things I’ve seen...
Comments posted to this topic are about the item SQL Server Vector Support II
Comments posted to this topic are about the item Great Things
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers