Episode 261: The Data Lakehouse

Episode 261: The Data Lakehouse

It would appear Microsoft has run out of words to use for new features/products, so they are just going to recycle existing words for a bit of fun at our expense. In this episode we explore the Azure Data Lakehouse—which is not a data lake, nor a traditional data warehouse and Books Online (BOL) refers to it as Databricks Lakehouse. Luke Moloney walks us through how combining the flexibility of data lake storage with some ACID transaction and data governance gives organizations looking to analyze their data a new option. The hope is the cost to build, store, and analyze data will be easier and more approachable for organizations who don't want to go with the traditional data warehouse model. This still feels like an Enterprise feature to me but let me know if your organization would be interested in this approach. As always, special thanks to Luke and the folks at Microsoft for making themselves available to us.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2023/03/01/episode-261-the-data-lakehouse. Have fun on the SQL Trail!

Jaksot(287)

Episode 247: Pushing the Boundaries or Pushing Your Luck

Episode 247: Pushing the Boundaries or Pushing Your Luck

IT workers will generally claim they like learning new technology—it is almost a required attribute.  Why then is bringing in new technology so hard?  In this episode, we explore how new technologies ...

15 Kesä 202235min

Episode 246: Microsoft Build 2022 Announcements

Episode 246: Microsoft Build 2022 Announcements

While we continue to review the new features of the CTP preview of SQL Server 2022, we turn our attention to the recent Microsoft Build conference and talk about some of the announcements made. We tr...

8 Kesä 202229min

Episode 245: Tooling Updates

Episode 245: Tooling Updates

SQL Server Management Studio (SSMS) version 18 was introduced to support SQL Server 2019 and in this episode of the podcast, we discuss some of the new updates available in SSMS and Azure Data Studio....

20 Huhti 202239min

Episode 244: Extended Events vs SQL Server Audit

Episode 244: Extended Events vs SQL Server Audit

Who made that change?  It is one of those questions that can send chills down the spine of those responsible for databases.  In this episode, Josephine Bush talks with us about how we can use a combin...

30 Maalis 20221h 6min

Episode 243: Choosing What Content To Focus On

Episode 243: Choosing What Content To Focus On

Conferences are on the uptick as COVID restrictions lift and we are excited for the upcoming year. After Eugene's return from SQLBits my thoughts revolved around what I wanted to learn this year at co...

16 Maalis 202242min

Episode 242: Upgrading Your SQL Server

Episode 242: Upgrading Your SQL Server

SQL Server 2012 is end of life later this year. I feel too young for this to be happening—it seems like only last year SQL Server 2005 came out. In this episode of the podcast, we talk about upgradi...

2 Helmi 202250min

Episode 241: Replicating Data with Azure SQL Data Sync

Episode 241: Replicating Data with Azure SQL Data Sync

Do you find you need to keep SQL Server tables in sync across multiple systems?  After several projects involving syncing data, we return to the topic of Azure SQL Data Sync with some real world examp...

20 Tammi 202238min

Episode 240: Azure Synapse Link

Episode 240: Azure Synapse Link

Azure Synapse Link is a feature coming to SQL Server in the next release. While there are few details on what the new feature will look like, we discuss how this same service is implemented in other A...

5 Tammi 202234min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
voi-hyvin-meditaatiot-2
psykopodiaa-podcast
rss-narsisti
adhd-podi
rss-rahamania
kesken
rss-liian-kuuma-peruna
psykologia
rss-duodecim-lehti
rss-eron-alkemiaa
rss-arkea-ja-aurinkoa-podcast-espanjasta
rss-niinku-asia-on
rss-tietoinen-yhteys-podcast-2
rss-vapaudu-voimaasi
rss-finnish-daily-dialogues
rahapuhetta
rss-valo-minussa-2
rss-luonnollinen-synnytys-podcast
rss-helppoa-suomea-learn-finnish-through-comprehensible-input