Vojtěch ŠímaData Bender

SQL Analytics Endpoint

3 posts on SQL Analytics Endpoint: benchmarks, internals and workarounds for the Microsoft data stack.

  1. 03
    Automated Delta Table Maintenance in Fabric Lakehouse (Without PySpark)

    Deep dive into Delta table internals, transaction logs, and storage layout. Master maintenance, VACUUM, and Z-Order using Python (delta-rs) in Microsoft Fabric.

  2. 02
    Programmatically Refresh & Sync SQL Analytics Endpoint Metadata in Microsoft Fabric

    Learn how SQL Analytics Endpoint in Microsoft Fabric works and how to fix metadata lag by calling the Refresh SQL Endpoint Metadata API before Power BI refresh.

  3. 01
    Native write-back in Power BI (Fabric preview)

    Write back to SQL straight from a Power BI report using Fabric User Data Functions and Translytical Task Flows. No Power Apps, no Power Automate.