πΉ Feature: SQL Database in Microsoft Fabric
πΉ What It Does: A fully managed, cloud-native SQL engine inside Fabric β built for operational workloads, AI apps, and the data plumbing that powers analytics.
π‘ Where teams actually use it:
Meta-driven pipelines
Power BI writebacks
Reference data store
Operational data store (ODS)
Line of business Power Apps + Translytical
Vector and AI app dev
Event-driven apps
Reverse ETL
π Whatβs New:
β
Migration Experience in Fabric: Move existing SQL workloads into Fabric with a guided in-portal experience β no more manual schema/data juggling.
schema/data juggling.
β
Point-in-Time Restore for Dropped Databases: Accidentally deleted database? Recover it to any point in time within retention β safety net built in.
β
List Deleted Databases by Workspace: Full visibility of what was dropped and when β no more guessing during recovery.
β
Pre/Post Deployment Actions: Hook custom logic into your SQL project deployments β seed data, set permissions, run validations automatically.
β
Custom Table Selection for Mirroring: Pick exactly which tables get mirrored to OneLake β control cost, scope, and refresh patterns per workload.
β
SQL Projects Open in SSMS: Edit and manage Fabric SQL projects directly from SSMS β the tool every DBA already lives in.
π The shift: Fabric SQL is becoming a full database platform β not just a side workload in Fabric. Migration, recovery, deployment automation, and SSMS parity are the production-grade table stakes now delivered.
π https://learn.microsoft.com/en-us/fabric/fundamentals/whats-new