noviembre 18, 2025 por Adam Saxton 76.262 Vistas
The November 2025 Fabric release introduces several major updates, including the general availability of SQL database, Cosmos DB, and enhanced mirroring support for key data sources such as SQL Server, Cosmos DB, and PostgreSQL. This month also brings new AI-driven features like Copilot sidecar chat tools and real-time data exploration, as well as crucial platform …
The OPENROWSET function that can read JSONL format empowers you to easily read and ingest JSONL files – for example log files, social media streams, machine learning datasets, configuration files, and other semi-structured sources. With the versatile OPENROWSET T-SQL function, you can reference and query JSONL files as if they were tables, eliminating the need …
The introduction of data sources and relative paths in the OPENROWSET function unlocks a new level of simplicity and flexibility for querying files in your Lakehouse and beyond. By leveraging external data sources, you can write cleaner, more maintainable SQL queries and easily access data wherever it resides — making data engineering and analytics more …
End Write Amplification and Automate Your Table Maintenance Compaction is one the most necessary but also challenging aspects of managing a Lakehouse architecture. Similar to file systems and even relational databases, unless closely managed, data will get fragmented over time, and can lead to excessive compute costs. The OPTIMIZE command exists to solve for this …
Continue reading “Introducing Optimized Compaction in Fabric Spark”
Fabric Spark connector for SQL databases (Azure SQL databases, Azure SQL Managed Instances, Fabric SQL databases and SQL Server in Azure VM) in the Fabric Spark runtime is now available. This connector enables Spark developers and data scientists to access and work with data from SQL database engines using a simplified Spark API. The connector …
Continue reading “Spark Connector for SQL databases (Preview)”
Microsoft Fabric continues to evolve as a unified platform for data professionals, and the latest update to Semantic Link introduces Service Principal support—a key enhancement for teams looking to automate and scale their data workflows securely. Semantic Link enables seamless integration between notebooks and semantic models, allowing users to query and analyze data directly from …
Continue reading “Service Principal Support in Semantic Link: Enabling Scalable, Secure Automation”
