In the intricate world of business, where precision and efficiency are paramount, managing database dependencies can often feel like navigating…
Browsing: SQL
I had a customer recently that was asking about Linked Servers and some development advice. I was going to show…
Another KDA case: Digitown’s utility bills suddenly doubled for no good reason. With the election coming up, I got pulled…
I had a customer recently ask about a change in one of their constraints on production, where a new option…
In the blog post Call a Fabric REST API from Azure Data Factory I explained how you can call a…
I’ve been using the SSMS preview for v21. This is the next evolution of SSMS, where the VS shell is…
I’m excited to announce that on June 17 – 18, 2025, I’ll be running a special Online Live Training event…
I’ll walk through the KDA UI and tackle the first challenge before diving into the real cases.The UI layoutThis is…
I was chatting with a customer recently and they wanted to know which host was sending in queries that were…
I heard someone say recently that you can’t change a primary key value in a row. That’s not the case,…