Microsoft Fabric provides the ability to use many different elements, including T-SQL to provide abilities for developers to leverage skills they already possess combined with new tools. In this session, you learn how to create T-SQL notebooks for pipelines and write T-SQL with Python to directly update lakehouses and warehouses in Microsoft Fabric.

The session demonstrates practical development techniques including reusable code templates, integrated charting, notebook automation possibilities, and hybrid workflows that combine Python and T-SQL together in the same Fabric environment.

Whether you are modernizing SQL development practices, documenting analytical workflows, or building repeatable Fabric data solutions, T-SQL notebooks provide a modern approach to SQL development inside Microsoft Fabric. Attendees leave with practical guidance, real-world use cases, and a strong understanding of where T-SQL notebooks fit into the broader Fabric analytics ecosystem.

You will learn:

• How to create, configure, and execute T-SQL notebooks within Microsoft Fabric for pipelines.
• How to combine T-SQL code, in pyspark to improve collaboration and workflow documentation.
• Practical use cases for T-SQL notebooks including query development, data exploration, automation workflows, and integrated analytics solutions within Microsoft Fabric.