MS Learn Docs<\/a><\/p>\n<\/blockquote>\nHere you provision a job agent, define the schedule, and run your stored procedures. That’s it. Once in place, the flow is predictable and your refresh procedures update cache tables. sp_GetProduct reads only local data or partly local data, depending on your final solution.<\/p>\n
Your basic refresh logic does not change. Only the trigger changes.<\/p>\n
EXEC dbo.sp_RefreshProductInventoryCache @productId = 42;\nEXEC dbo.sp_RefreshProductRecommendationsCache @productId = 42, @userId = 1001;\nGO\n<\/code><\/pre>\nNow, our recommendation data is a good thought experiment. Inventory scales linearly with product count, so recommendations are multiplied by user count. That can grow fast. At 10,000 products and 100,000 users, refreshing every combination is not realistic. Narrow the surface area to what actually drives value or consider caching a little of this and a little of that.<\/p>\n
Conclusion<\/h2>\n
Federation does not require linked servers. With Data API Builder and sp_invoke_external_rest_endpoint<\/code>, SQL can compose across databases, engines, and environments. You can do this synchronously<\/strong> and keep everything fresh but couple latency and failure to the request, or asynchronously<\/strong> with Elastic Jobs that isolate variability and keep your request path fast. But which path and how much of either is going to be your call.<\/p>\nIn either case, SQL stays the composition layer. Data API builder is your bridge. Remember that DAB can target one data source or many. The diagram may show multiple API servers, but one DAB instance can federate several backends as long as authentication aligns.<\/p>\n
\nData API builder does not execute cross database JOINs inside the engine. It lets you query across databases. The difference is where the JOIN happens.<\/p>\n<\/blockquote>\n
Federated data is enriched data, and enriched data makes your app better. Check it out!<\/p>\n","protected":false},"excerpt":{"rendered":"
For decades, DBAs relied on linked servers to stitch data together. If you needed data from two places, you wired them up and moved on. It worked. It was straightforward. It felt native to SQL. But what if linked servers are not an option? What if policy blocks them? What if one of the systems […]<\/p>\n","protected":false},"author":96788,"featured_media":6471,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,597,576],"tags":[409,560,713,317],"class_list":["post-6465","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","category-data-api-builder-2","category-rest","tag-api","tag-data-api-builder","tag-federation","tag-linked-server"],"acf":[],"blog_post_summary":"
For decades, DBAs relied on linked servers to stitch data together. If you needed data from two places, you wired them up and moved on. It worked. It was straightforward. It felt native to SQL. But what if linked servers are not an option? What if policy blocks them? What if one of the systems […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/6465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/users\/96788"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=6465"}],"version-history":[{"count":1,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/6465\/revisions"}],"predecessor-version":[{"id":6507,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/6465\/revisions\/6507"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/6471"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=6465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=6465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=6465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Diagram](\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/linked-servers-dab.drawio.svg\")
<\/a><\/p>\n