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,694 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,058 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,067 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,096 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
957 reads
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
This post shows you how to install containerd as the container runtime for Kubernetes...
Jl. Jenderal Sudirman No.14, Muara Dua, Kec. Prabumulih Tim., Kota Prabumulih, Sumatera Selatan 31121
Wa:083849450961 Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141
Wa:083849450961 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers