Angi opplysningene dine for å abonnere på Microsoft Fabric-bloggen.

Takk for at du abonnerer på Microsoft Fabric-bloggen. Du mottar e-postvarslinger når vi publiserer nye innlegg.

Microsoft Fabric Updates Blog

  1. Oppdateringer
  2. september 2024

Mirroring Azure SQLDB – new features and what’s coming up?

Overview

This blog will walk thru the new capabilities in Mirroring Azure SQLDB in Fabric since our public preview announcement earlier in March 2024. Today, we also announced general availability of Mirroring for Snowflake in Microsoft Fabric.

To recap, the 3 key benefits of Mirroring are:

  1. Reduced total cost of ownership with zero compute to replicate along with generous amounts (terabytes) of storage based on the capacity size.
  2. Zero code with zero ETL.
  3. Faster time to operational data, information to derive insights.

Over the past few months, we’ve removed limitations to seamlessly support more data definition language (DDL) when Mirroring is actively running. These DDL’s are:

  1. Alter Table … Alter Column to change one datatype to another
  2. Drop Table
  3. Rename Table
  4. Rename Column

The following demo video below will walk thru how Mirroring in Azure SQL Database works with the new features mentioned above.

Mirroring Azure SQL Database in Fabric with Schema changes

Use Cases

Below are some of the key use cases that leverages Mirroring:

  1. Data is replicated into One Lake and kept up to date in near real-time.
  2. Mirroring protects operational databases from analytical workloads.
  3. Raw data available in Fabric Lakehouse as a bronze layer to enable Medallion architecture.
  4. Leverage Direct Lake mode in Power BI instead of Direct Query or import mode.

What’s coming up in future milestone release for Mirroring Azure SQLDB

We’ve heard your feedback loud and clear and are heads down working on some of your key asks. The features below are coming soon in an upcoming milestone release:

  • Allow connectivity to SQL Databases behind firewall or private endpoints using Vnets
  • Ability to setup and manage Mirroring using programmatic APIs
  • Support for schema hierarchy and column mapping in data warehouse and lakehouse experiences
  • Mirror tables with no defined primary keys
  • Security improvements to connect SQLDB with lower level/reduced SQL permissions
  • Mirror additional data types (sql_variant, geography, geometry etc) to Fabric OneLake
  • Support for DDL: Truncate Table

Summary

Mirroring Azure SQL Database in Fabric plays a crucial role in enabling analytics and driving insights from data by providing:

  1. Timeliness of Insights: Ensuring the most recent data is available for analysis. This allows businesses to make decisions based on the most current situation, rather than relying on outdated information.
  2. Improved Accuracy: The risk of discrepancies between the source and the replicated data is significantly reduced leading to more accurate analytics and reliable insights.
  3. Predictive Analytics and AI: Essential for data science, machine learning and AI models that require the most recent data to make accurate predictions for data based decisions.

Learn more about Mirroring 

We hope you enjoy using Mirroring Azure SQL Database in Fabric and we look forward to hearing your feedback and questions.

Relaterte blogginnlegg

Mirroring Azure SQLDB – new features and what’s coming up?

Bloggens aktuelle bilde

Announcing public preview of VARCHAR(MAX) and VARBINARY(MAX) types in Fabric Data Warehouse
oktober 31, 2024 av Jovan Popovic

Fabric Data Warehouse is a modern data warehouse optimized for analytical data models, primarily focused on the smaller numeric, datetime, and string types that are suitable for analytics. For the textual data, Fabric DW supports the VARCHAR type that can store up to 8KB of text, which is suitable for most of the textual values … Continue reading “Announcing public preview of VARCHAR(MAX) and VARBINARY(MAX) types in Fabric Data Warehouse”

Les mer
Bloggens aktuelle bilde

APIs for Managed Private Endpoint are now available
oktober 29, 2024 av Dandan Zhang

Managed private endpoints allow Fabric experiences to securely access data sources without exposing them to the public network or requiring complex network configurations. We announced General Availability for Managed Private Endpoint in Fabric in May of this year. Learn more here: Announcing General Availability of Fabric Private Links, Trusted Workspace Access, and Managed Private Endpoints. … Continue reading “APIs for Managed Private Endpoint are now available”

Les mer