From SQL Server to Microsoft Fabric

Many organizations migrating to Microsoft Fabric bring long-standing SQL Server data modeling practices with them. While these foundations remain valuable, applying traditional warehouse modeling approaches directly to a Lakehouse environment often results in performance issues, duplicated logic, and limited scalability.
This session explores how data modeling must evolve when moving from SQL Server to Microsoft Fabric. We will discuss which modeling principles still apply, which need to change, and how Lakehouse and warehouse patterns influence design decisions. Topics include star schemas versus wide tables, where transformations should live, how semantic models shift business logic placement, and how Direct Lake impacts performance and modeling choices.