Content by jovanpop-msft (5)

jovanpop-msft announces four preview T-SQL enhancements in Microsoft Fabric Data Warehouse—GROUP BY ALL, ORDER BY ALL, QUALIFY, and the FROM ... SELECT query format—aimed at reducing repetitive SQL, simplifying maintenance when projections change, and making analytical query logic easier to read.

jovanpop-msft announces a preview update for Microsoft Fabric Data Warehouse and the SQL analytics endpoint: new and enhanced T-SQL analytical functions for distribution analysis, including exact and approximate median/quantile calculations and expanded percentile aggregate syntax.

jovanpop-msft introduces preview support for calling Fabric User Data Functions from T-SQL in Fabric Data Warehouse. The integration extends warehouse queries with custom Python logic for data enrichment, external API calls, and secret retrieval, with an example that calculates and stores IPv6 network prefixes for downstream analytics.

jovanpop-msft introduces the Bulk Copy API (preview) for Microsoft Fabric Data Warehouse, explaining when client-side bulk ingestion is a better fit than server-side COPY INTO and showing practical patterns for C#, Java, command-line bcp.exe, and orchestration tools like Azure Data Factory and SSIS.

jovanpop-msft introduces preview features in Fabric Data Warehouse that add approximate string-matching functions and modern string operators for T-SQL. The post shows how to use distance and similarity scoring to find misspellings and variants (like “Hongkong” vs “Hong Kong”), plus new concatenation and Unicode helpers for clearer SQL.