Dr. Estera Kot

Caching in data warehousing

Episode 30 of Fabric Espresso, the Microsoft Fabric video series created by Dr. Estera Kot.

Video thumbnail for Caching in data warehousing. Opens the video on YouTube.

Length 4:03. Published Sep 29, 2023 on the Azure Synapse Analytics YouTube channel. Topic: Warehouse.

Watch on YouTube

About this episode

Text from the YouTube description.

In this video, we dive into the world of caching techniques that can supercharge your SQL query performance, especially when dealing with large datasets. Learn about the power of in-memory caching and SSD caching, two optimization techniques that can dramatically reduce query times by reducing IO latency dramatically. Whether you're a seasoned database administrator or just getting started with data warehousing in Microsoft Fabric, this video has valuable insights to help you understand how Fabric delivers great performance.

Learn more: Caching in Fabric data warehousing - Microsoft Fabric | Microsoft Learn

Meet the Speakers 🚀 🚀 🚀:

Filip Popović: Senior Product Manager at Microsoft, Microsoft Fabric
LinkedIn: Filip Popović | LinkedIn
Twitter: Filip Popović (@FilipPop_MSFT) / X (twitter.com)

Miloš Šuković, Senior Software Enginner, Microsoft Fabric

LinkedIn Miloš Šuković | LinkedIn

Chapters

  1. 0:00 Introduction
  2. 0:23 Query Scan
  3. 0:49 Transcoder
  4. 2:07 SSD Cache
  5. 3:18 Conclusion

All Fabric Espresso episodes