Configurable Parameters for Optimizing Initial Snapshot in SQL Server Mirroring to Fabric
In SQL Server mirroring to Microsoft Fabric, there are currently no configuration options to control or optimize the initial snapshot (for example, adapting the current table to partitioning or adjusting the batch size for row transfers).
I propose adding configuration parameters that would allow the initial snapshot process to be more tunable and efficient (Example rows per batch, MAXDOP for the operation or similar to backup.. BUFFERCOUNT and control the number of buffers assigned to the operation etc etc).
While there are some documented options to improve ongoing mirroring performance itself (SQL Server mirroring performance in Fabric), nothing exists today for the initial snapshot. This becomes a significant challenge when dealing with very large tables, as it is difficult to optimize the process without such controls.
Recent ideas
Improve support for calculated tables on remote semantic models
When a report is connected to a remote semantic model, Power BI Desktop allows users to create calculated tables and calculated columns based on that remote model. The issue is that this architectur...alaeddinegaaya16 minutes agoNew MemberNew1View0likes0CommentsAllow Bottom-Up Hierarchy Expansion in Power BI Matrix for Financial Statements
Allow Bottom-Up Hierarchy Expansion in Power BI Matrix for Financial Statements Hi, I would like to request an enhancement to the Power BI Matrix visual that allows hierarchies to be expanded from t...Barbarini2 hours agoRegular VisitorNew3Views0likes0CommentsOneLake Catalog full-text and content search
Why is it not possible to search OneLake by item description or even content? So I was thinking about how a user can find a table if they don't know in which lakehouse it is located? Why can't you se...TePe20 hours agoHelper IVPlanned1.1KViews21likes5CommentsAllow External OneLake Data Shares to Be Accepted into Multiple Fabric Item Types
Fabric External Data Sharing provides an excellent zero-copy mechanism for sharing OneLake data across tenants. However, the receiving tenant currently has to accept the share into a Lakehouse. I w...Mourak2 days agoNew MemberNew9Views0likes0CommentsAllow OneLake Shortcut Authentication Mode to Be Changed In Place
OneLake shortcuts support passthrough and delegated authentication, but changing the authentication model currently requires deleting and recreating the shortcut. I would like shortcut authenticatio...Mourak2 days agoNew MemberNew9Views0likes0Comments