Microsoft Fabric Updates Blog

Fabric Espresso – Episodes about Data Warehousing & Storage Solutions in Microsoft Fabric

For the past 1.5 years, the Microsoft Fabric Product Group Product Managers have been publishing a YouTube series featuring deep dives into Microsoft Fabric’s features. These episodes cover both technical functionalities and real-world scenarios, providing insights into the product roadmap and the people driving innovation. With over 80+ episodes, the series serves as a valuable resource for anyone looking to understand and optimize their use of Microsoft Fabric.

All episodes are available at  https://aka.ms/fabric-espresso making it easy to explore the entire catalog. However, to enhance the learning experience, we are launching a short series of blog posts that will categorize the episodes into thematic groups, providing explanations and key takeaways for each.

Fabric Espresso & Data Warehousing & Storage Solutions

This week, we focus on Data Warehousing & Storage Solutions in Microsoft Fabric. Below is a curated list of episodes that explore various aspects of data warehousing, storage patterns, performance optimizations, and best practices for data management.

Episodes on Data Warehousing & Storage Solutions:

1. T-SQL support in Microsoft Fabric Notebooks

2. Performance best practices

3. Custom schema and multipart naming in Microsoft Fabric Lakehouse

4. Ingesting data into Fabric Warehouse

5. Mirroring

6. Optimize Warehouse costs with capacity pause and resume

7. Automate your interactions with Fabric Warehouse

8. Consume Warehouse data from other services

9. Automated maintenance features in Fabric Warehouse

10. CSV ingestion performance improvements

11. Microsoft Fabric Capacity Smoothing and Data Warehouse Throttling

12. Permissions in Microsoft Fabric Workspace and SQL

13. Row-Level security in Fabric Warehouse & SQL Endpoint

14. Caching in data warehousing

15. Utilization Reporting for Warehouse

16. Getting data into your Microsoft Fabric Lakehouse using Load to Tables

17. Granular Access Control for Warehouse!

18. Learn to Share a Microsoft Fabric Warehouse!

19. Performance at Scale with Microsoft Fabric: Concurrency!

20. Performance at Scale with Microsoft Fabric: Query Optimizations!

21. Performance at Scale with Microsoft Fabric: Query Processing!

22. Fabric Espresso: Table clone in Warehouse within Microsoft Fabric

Related blog posts

Fabric Espresso – Episodes about Data Warehousing & Storage Solutions in Microsoft Fabric

November 4, 2025 by Misha Desai

We’re introducing a set of new enhancements for Data Agent creators — designed to make it easier to debug, improve, and express your agent’s logic. Whether you’re tuning example queries, refining instructions, or validating performance, these updates make it faster to iterate and deliver high-quality experiences to your users. New Debugging Tools View referenced example … Continue reading “Creator Improvements in the Data Agent”

November 3, 2025 by Jovan Popovic

Data ingestion is one of the most important actions in the Data Warehouse solutions. In Microsoft Fabric Data Warehouse, the OPENROWSET function provides a powerful and flexible way to read data from files stored in Fabric OneLake or external Azure Storage accounts. Whether you’re working with Parquet, CSV, TSV, or JSONL files, the OPENROWSET function … Continue reading “Ingest files into your Fabric Data Warehouse using the OPENROWSET function”