DHarmon1
2 years agoNew Member
Status:
New
Allow connections from Data Factory to Azure SQL DB read scale-out replicas
https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql As part of High Availability architecture, each single database or elastic pool database in the Premium and Business Critical service tier is automatically provisioned with a primary read-write replica and one or more secondary read-only replicas. The secondary replicas are provisioned with the same compute size as the primary replica. The read scale-out feature allows you to offload read-only workloads using the compute capacity of one of the read-only replicas, instead of running them on the read-write replica. This way, some read-only workloads can be isolated from the read-write workloads, and don't affect their performance. The feature is intended for the applications that include logically separated read-only workloads, such as analytics. In the Premium and Business Critical service tiers, applications could gain performance benefits using this additional capacity at no extra cost. I would like to use the Azure Data Factory in Microsoft Fabric to copy over large tables from our production databases for the initial load of a data warehouse. Since this is a copy operation, I would like to use the read scale out instance so that I do not impact the production database. However, the ADF Connector for an Azure SQL Database does not provide the functionality to set ApplicationIntent=ReadOnly in the connection string so that I can connect to the read scale out. The ask is to provide a check box in the Azure SQL Database connector that will add the configuration option "ApplicationIntent=ReadOnly" to the connection string so that I can connect to the read scale out instance and not impact my production databases.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Not found value "Available gateway clusters"
Hi, Currently the machine (A) hosting power BI on-prime gateway standard. Machine (B) also want to host this server with machine (A). Gateway on (A) and (B) is using the same tenant as admin user. I...Thas_Michael5 hours agoHelper INew3Views0likes0CommentsFabric Deployment Pipeline Should Automatically Preserve or Upgrade Semantic Model Compatibility
Category: Microsoft Fabric — Deployment Pipelines | Semantic Models | Direct Lake The Problem When deploying a Direct Lake semantic model containing calculated columns or calculated tables throug...Murtaza_Ghafoor7 hours agoSuper UserNew2Views0likes0CommentsNative Page-Level Security (PLS) or Dynamic Page Visibility based on RLS Roles
Description: Currently, Power BI provides robust Row-Level Security (RLS) to restrict data rows, but it lacks a native mechanism to restrict or hide entire report pages based on user roles or USERPRI...Erick1818 hours agoNew MemberNew5Views0likes0CommentsAdd standard ADBC search paths for ADBC drivers in Power BI
Considering the benefits of using ADBC drivers for data intensive operations, it would be nice to allow ADBC drivers to be used that are not necessarily packaged with Power BI installations. To mitig...hsadlier-pdx19 hours agoNew MemberNew5Views0likes0CommentsPower BI Subscriptions: Suppress OOO Replies and Improve Sender & Management Options
With the recent changes to Power BI subscription email delivery, Out of Office and other automatic replies can be returned to the individual subscription owner. For automated subscriptions sent to l...svcrowell20 hours agoNew MemberNew18Views2likes0Comments