Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Showing posts with label SQL Database in Fabric. Show all posts
Showing posts with label SQL Database in Fabric. Show all posts

Wednesday, 19 November 2025

What is new for Databases and Fabric at Ignite

There is significant news on the database front. Microsoft is unifying its data platform by deeply integrating its databases with Microsoft Fabric, creating a seamless, AI-powered data estate.













Unified Data Estate with Microsoft Fabric

  • Microsoft Fabric now acts as a unified platform that integrates Microsoft’s operational databases (like Azure Cosmos DB, Azure SQL, and PostgreSQL) with analytics and AI tools.
  • This integration enables real-time insights and governed data sharing across operational and analytical systems without complex ETL pipelines.

Real-Time Analytics with Synapse Real-Time Intelligence

  • The new Synapse Real-Time Intelligence in Fabric allows streaming data from operational databases to be analyzed instantly.
  • This supports use cases like fraud detection, predictive maintenance, and personalized recommendations.

Built-in Governance and Security

  • Microsoft Purview is embedded in Fabric, ensuring data lineage, access control, and compliance across the entire data estate.
  • This helps organizations meet regulatory requirements while maintaining agility.

AI-Ready Data for Copilot and Custom Models

  • With this integration, data from operational systems becomes AI-ready by default, enabling seamless use with Microsoft Copilot and custom AI models.
  • This supports natural language querying, automated insights, and generative AI applications.

Fabric IQ 

Fabric IQ is Microsoft Fabric’s new semantic intelligence layer that transforms raw data into business-aware insights by embedding meaning, relationships, and operational context directly into the data platform. This announcement marks the moment Microsoft Fabric evolves from a unified data platform into a unified intelligence platform. It created a shared, real-time understanding of the business. It is designed to solve a core challenge in enterprise AI: AI agents can read data, but they often lack the business context to interpret it meaningfully. Fabric IQ introduces a semantic layer that maps data to real-world business concepts like customers, flights, or inventory, rather than just tables and columns



Fabric IQ introduces a semantic intelligence layer that gives both people and AI the same deep business context your experts rely on. It connects data, meaning, and action through:
  • Ontology - A shared business model built with no-code visual tools
  • Semantic Model - Trusted BI definitions extended into operations & AI
  • Graph Engine - Multi-hop reasoning across connected business systems
  • Data Agent - Virtual analysts that answer questions using real business semantics
  • Operations Agent - Autonomous agents that monitor, reason, and act in real time



Bi-Directional Data Movement

  • Fabric supports bi-directional data movement between databases and the analytics layer, enabling write-back scenarios like updating customer profiles or triggering workflows.

Microsoft Databases and Microsoft Fabric: Your unified and AI-powered data estate

SQL Database in Microsoft Fabric

SQL Database in Microsoft Fabric is a cloud-native, developer-friendly transactional database built on the same engine as Azure SQL Database, designed to integrate seamlessly with the broader Fabric ecosystem.

SQL database in Fabric is built on 3 important pillars: Simple, Autonomous & Secure, and Optimized for AI. It is now genernally available. 

Announcing SQL database in Fabric (Generally Available)







SQL Server 2025 is Generally Available

There were a lot of database announcements at Microsoft Ignite which continues to broaden the scope and offerings available. 

The general availability of the next version of SQL Server, SQL Server  2025 was announced. This new version continues to offer best in class security and performance. It is built for AI, made for developers and offer cloud agility through Azure. 

SQL Server 2025 is Now Generally Available

The product just continues to grow.  




The platform architecture






















with these editions






















Other database announcements: 

Azure DocumentDB (GA)
Azure DocumentDB offers AI-ready data, open standards, and multi-cloud deployment. It is a fully managed NoSQL service built on open-source tech and designed for hybrid and multicloud flexibility. It supports advanced search and vector embeddings for more accurate results and is compatible with popular open-source MongoDB drivers and tools.

Azure HorizonDB (Preview)
Azure HorizonDB is a new fully managed PostgreSQL database service.  It runs up to three times faster than open-source PostgreSQL and grows to handle demanding storage requirements with up to 15 replicas running on auto-scaling shared storage.

SQL Database in Fabric (GA)
SQL Database in Fabric bridges the gap between transactional and analytical workloads, enabling scenarios, where data is instantly available for both operational use and analytics, without performance trade-offs or complex ETL pipelines.

Database mirroring in Microsoft Fabric (GA)
The General Availability (GA) of mirroring for Azure SQL Database, Azure SQL Managed Instance, and Cosmos DB. Mirroring for SQL Server 2025 (on-premises or on VMs) was announced as being in Preview. 

Fabric November 2025 Feature Summary | Microsoft Fabric Blog | Microsoft Fabric

Microsoft introduced ecosystem interoperability as a cornerstone of its AI and data strategy. It enables organizations to connect and analyze data across platforms without moving or duplicating it, thus preserving governance, reducing cost, and accelerating insights. It unlocks data estates for AI models to train on live ,governed data, provides business users access insights without waiting for ETL pipelines, as well as reducing complexity for enterprises and cost while improving compliance.



The Key Components Explained
Zero-Copy Integrations
These allow data to be accessed and shared across systems without physically copying it. This is crucial for:
  • Security: Data remains in its original location.
  • Efficiency: No duplication means lower storage and compute costs.
  • Governance: Original data lineage and controls are preserved.
SAP BDC (Business Data Cloud)
Microsoft Fabric now supports bi-directional zero-copy sharing with SAP BDC, giving instant access to semantically rich SAP data for analytics and AI.
Salesforce Data Cloud
Microsoft joins Salesforce’s Zero Copy Partner Network, enabling secure, bidirectional zero-copy integration with platforms like Databricks, Snowflake, and now Microsoft Fabric.
Azure Databricks and Snowflake
Expanded support means these platforms can now participate in zero-copy sharing with Microsoft Fabric, enabling unified analytics across cloud ecosystems.
dbt Jobs in Fabric (Preview)
dbt (data build tool) is now integrated into Fabric, allowing teams to run transformation workflows directly within Microsoft’s unified data platform. This streamlines development and governance for analytics engineers.

Azure at Microsoft Ignite 2025: All the intelligent cloud news explained | Microsoft Azure Blog