Posted in

SQL Database in Microsoft Fabric

πŸ”Ή 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

Microsoft Certified Trainer, Office 365, AWS, Azure and Cloud Expert-Architect. In the IT world for over than 20 years.

Apart from the main area of Microsoft Azure expert in the field of infrastructure servers Windows Server 2003-2019, Microsoft Active Directory, Hyper-V Private Cloud, IIS, System Center, SQL.

Private Cloud, System Center, Hyper-V, Open Stack Expert and all Microsoft products Expert. Linux Server administrator.

My Azure community projects:

https://mazeball.azurewebsites.net/
https://github.com/MariuszFerdyn?tab=repositories

More