Microsoft Fabric & Power BI Meetup #9 | Wien

# MICROSOFT FABRIC USER GROUP AUSTRIA
Neuntes Meetup | 20. August 2026 | ab 18:00 Uhr (vor Ort)

📍 Cegeka Austria GmbH, Millennium Tower, Handelskai 94-96/44. OG, 1200 Wien
🍴 Snacks & Drinks
🖥️ Nur vor Ort

Wir freuen uns, euch zum nächsten Meetup der Microsoft Fabric User Group Austria einzuladen. Unsere Community trifft sich monatlich und rotiert dabei zwischen Wien, Graz und Linz.

Diesmal sind wir bei Cegeka Austria in Wien zu Gast.

AGENDA

18:00 – Ankommen · Leute kennenlernen · Snacks & Drinks genießen
18:45 – Begrüßung · Community Update
19:00 – From SQL Server to Microsoft Fabric: Choosing the Right Integration Pattern | Torsten Strauß (MVP)
20:00 – Offene Runde · Fragen, Austausch & gemütlicher Ausklang

Abstract:

From SQL Server to Microsoft Fabric: Choosing the Right Integration Pattern

This session explores the architectural options for making SQL Server and Azure SQL data available in Microsoft Fabric - from low-latency mirroring and CDC-based event ingestion to controlled batch processing and custom incremental loading patterns.

You will learn how to evaluate Mirroring, Copy Jobs, Data Pipelines, Dataflow Gen2, and CETAS exports, based on latency requirements, data volume, source-system capabilities, network constraints, transformation needs, operational complexity, and long-term maintainability.

Covering both on-premises SQL Server and Azure SQL Database, we will examine the differences between CDC-based mirroring for earlier SQL Server versions and the SQL Server 2025 Change Feed architecture.

For scenarios requiring greater control, the session demonstrates how metadata-driven pipelines, Copy Jobs, Dataflow Gen2, and CETAS-based exports can complement or replace mirroring.

Key topics include:

• Fabric Mirroring: Architecture and integration patterns for SQL Server and Azure SQL Database

• Replication Evolution: SQL Server 2025 Change Feed versus CDC-based approaches

• Data Pipelines: Full, incremental, and metadata-driven loading patterns

• Copy Jobs: Simplified bulk, incremental, and CDC-based data movement

• Dataflow Gen2: Low-code extraction and transformation using Power Query

• Change Capture: CDC, Change Tracking, and Temporal Tables

• Controlled Data Export: CETAS-based patterns for scalable data movement

• Day-2 Operations: Schema evolution, reseeding, monitoring, and troubleshooting

• Security and Infrastructure: Managed identities, the On-premises Data Gateway, Azure Arc, and network considerations

• Architectural Trade-offs: Balancing latency, cost, complexity, flexibility, and operational control

Practical demonstrations will show selected patterns for replicating, exporting, and ingesting SQL data into Microsoft Fabric. You will see how data becomes available in OneLake and how it can be consumed through Spark, T-SQL, and Power BI semantic models using Direct Lake mode.

Join this session to gain a field-tested, architecture-focused blueprint for SQL-to-Fabric integration - from straightforward batch ingestion to low-latency operational analytics.