Unlocking T-SQL Surface Area

Microsoft Fabric offers multiple options for storing and working with data in a relational manner, but not every T-SQL statement will run everywhere. You may write a query only to discover it’s "not supported" — even though the same syntax works in SQL Server or other databases. Why does this happen?

The answer lies in the concept of SQL surface area, which is the specific set of SQL language capabilities supported by a data platform. In this session, we’ll define what surface area means in practice, then explore the architecture of Fabric's various relational data storage engines to understand where T-SQL works and why.

By the end of the session, you’ll know how to:
-Define the architectures of Fabric items that support T-SQL queries
-Identify where certain SQL keywords and features are supported (and where they aren’t)
-Understand the technical reasons behind those limitations
-Make informed design and development choices to maximize the power of T-SQL across Fabric