Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

idrismotiwala
Microsoft Employee
‎09-25-2024 05:30 AM

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.

https://www.youtube.com/watch?v=F9WCz46Os0U&feature=youtu.be
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.

0