Microsoft Fabric Updates Blog

Introducing Migration assistant for SQL database in Fabric (Preview)

Modern organizations are at a crossroads. Legacy SQL Server workloads need modernization, but migration complexity often stands in the way. What if you could bring your SQL databases into a unified analytics platform—without the hassle of manual schema conversion, complex ETL pipelines, or costly re-architecture? That’s exactly what the new Migration Assistant for SQL database … Continue reading “Introducing Migration assistant for SQL database in Fabric (Preview)”

Use ANY_VALUE() for simpler grouping of results in Fabric Data Warehouse (Generally Available)

Fabric Data Warehouse now supports the ANY_VALUE() aggregate, making it easier to write readable, efficient T-SQL when you want to group by a key but still return descriptive columns that are functionally the same for every row in the group. What is ANY_VALUE()? ANY_VALUE() is an aggregate or analytic function that returns an arbitrary value … Continue reading “Use ANY_VALUE() for simpler grouping of results in Fabric Data Warehouse (Generally Available)”

Working with unstructured text in Fabric Data Warehouse with built-in AI functions (Preview)

Data warehouses traditionally focus on structured and semi-structured data. Free-form text such as notes, logs, or comments was difficult to process in data warehousing scenarios without external components. Microsoft Fabric Data Warehouse is opening new scenarios in modern data warehousing by enabling you to work with unstructured text using new AI capabilities. We are introducing … Continue reading “Working with unstructured text in Fabric Data Warehouse with built-in AI functions (Preview)”