Take over Ownership in Microsoft Fabric
When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a pipeline …), you are also the owner of the item. There has been an...
2025-02-05 (first published: 2025-01-29)
475 reads
Blog Posts
T-SQL Tuesday #183 Invite: Tracking Permissions
It’s time for T-SQL Tuesday again and this month I’m hosting. I realized that I didn’t host in 2024 and since I run the thing, I ought to be...
2025-02-04
121 reads
Declaring a Complex PK in a CREATE TABLE: #SQLNewBlogger
Recently I was talking with someone who had not named any of the primary keys (PKs) in their database. They used system generated names and when they ran comparisons,...
2025-02-03
89 reads
Monday Monitor Tips: Using the PowerShell API
Redgate Monitor has grown tremendously from its early days and I find many customers using this to monitor lots of servers, like thousands. In those cases, some of tasks...
2025-02-03 (first published: 2025-01-20)
314 reads
Using OneLake for Excel Files in Microsoft Fabric
Hey data friends! This blog is to discuss an edge case I’ve run into in Microsoft Fabric. I won’t go into all the context, but the goal was to...
2025-02-03 (first published: 2025-01-21)
2,092 reads
Advice I Like: Why am I doing this?
You are never too young to wonder “Why am I still doing this?” You need to have an excellent answer – from Excellent Advice for Living I’d say that...
2025-01-31
11 reads
Another AI Faux Pax
I was experimenting with a local model (article) and as a part of this, I pulled down a web interface for my model in a container. I ran it...
2025-01-31 (first published: 2025-01-20)
407 reads
Common Issues When Using Change Tracking for Data Warehouse Incremental Loads
I have a few clients that incrementally load tables from a SQL Server source into their data warehouse or lakehouse by using change tracking. Lately, they encountered some issues...
2025-01-31
15 reads
Common Issues When Using Change Tracking for Data Warehouse Incremental Loads
I have a few clients that incrementally load tables from a SQL Server source into their data warehouse or lakehouse by using change tracking. Lately, they encountered some issues...
2025-01-31
129 reads
Common Issues When Using Change Tracking for Data Warehouse Incremental Loads
I have a few clients that incrementally load tables from a SQL Server source into their data warehouse or lakehouse by using change tracking. Lately, they encountered some issues...
2025-01-31
6 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers