Episode 282: OneLake - A Deep Dive

Episode 282: OneLake - A Deep Dive

In Episode 281, we introduced Microsoft OneLake with a high-level overview. Now we're going deeper with a discussion on the Parquet format, why Microsoft went with the Delta Lake variation, and what Delta Lake format brings to the table (no pun intended). We'll also examine some "behind the scenes" aspects of file management, and why you'll still be using the GUI to create most of your objects.

Onelake is Microsoft's solution to the demand for centralizing all data in one location, eliminating the need to transfer it across multiple systems. We expect this to play out further however, when we consider scenarios like data sovereignty, geographical data distribution, separation of subsidiary data, and even departmental budgets that may necessitate multiple instances of OneLake.

We round out our OneLake deep dive with a conversation on the Direct Lake Mode option for importing data into Power BI and Eugene shares his perspective on why everyone may not be rushing to jump on the bandwagon just yet.

We hope you enjoyed this deep dive into Microsoft OneLake! If you have questions or comments, please send them our way. We would love to answer your questions on a future episode. Leave us a comment and some love ❤️ on LinkedIn, X, Facebook, or Instagram.

The show notes for today's episode can be found at Episode 282: OneLake - A Deep Dive. Have fun on the SQL Trail!

Avsnitt(286)

Episode 213: New Goals for 2021

Episode 213: New Goals for 2021

We open this year with a few updates on the podcast, a change to SQL Trail, and we invite you to give us some feedback on writing a book for 2021. The show notes for today's episode can be found at https://sqldatapartners.com/2021/01/13/episode-213-new-goals-for-2021/. Have fun on the SQL Trail!

13 Jan 202132min

Episode 212: 10 Things You Need to Know About Data Security

Episode 212: 10 Things You Need to Know About Data Security

20 years ago, the objection to implementing security on the basis of performance had validity—especially for smaller organizations. Security was a pain in the neck; however, how many of us are still hanging on to some of those old biases. Even worse, some of us IT pros seem to put up objections to doing the most basic security procedures—sending usernames and passwords in unencrypted emails for example. In this episode we hear from Karen Lopez, a long time speaker on data architecture and security about 10 things she thinks those of us with data stewardship responsibilities should consider. The show notes for today's episode can be found at https://sqldatapartners.com/2020/12/31/episode-212-10-things-you-need-to-know-about-data-security/. Have fun on the SQL Trail!

31 Dec 202059min

Episode 211: Solorigate

Episode 211: Solorigate

Microsoft released a lengthy white paper on the SolarWinds hack affecting thousands of computers. This is scary stuff, and the details continue to come out slowly and you wonder how it all will play out. Many IT pros rely on SolarWinds for monitoring and in this episode, we discuss the exploit, how mere mortals like us might feel a bit overwhelmed at the prospect, and what our due diligence is in a scenario like this. The show notes for today's episode can be found at https://sqldatapartners.com/2020/12/23/episode-211-solorigate/. Have fun on the SQL Trail!

23 Dec 202046min

Episode 210: The Elephant in the Room

Episode 210: The Elephant in the Room

It was sad news to hear PASS plans to dissolve in January of 2021. So much good has come of the community and it is sad to see it go. In this episode, we explore the why behind the collapse and what we think may emerge in the aftermath. The show notes for today's episode can be found at https://sqldatapartners.com/2020/12/18/episode-210-the-elephant-in-the-room/. Have fun on the SQL Trail!

18 Dec 202052min

Episode 209: Career Ready: Advice to New Graduates

Episode 209: Career Ready: Advice to New Graduates

Finding your first full time job is incredibly difficult—and that was before we were in a worldwide pandemic. In this episode, we discuss some strategies and share some experiences about how we got our first jobs and hopefully give you some inspiration as you try to find your first experience. The show notes for today's episode can be found at https://sqldatapartners.com/2020/12/14/episode-209-career-ready-advice-to-new-graduates/. Have fun on the SQL Trail!

14 Dec 202050min

Episode 208: SQL Server and Graph Data

Episode 208: SQL Server and Graph Data

There is a growing list of formats to store data and Graph is one of the newer trends. It is becoming so popular SQL Server has created ways to implement graph structures. Mala Mahadevan joins us in this episode, and we revisit some of the origins of Graph, what it is good at, and why you may not want to rush to move all your data to Graph storage. The show notes for today's episode can be found at https://sqldatapartners.com/2020/10/28/episode-208-sql-server-and-graph-data/. Have fun on the SQL Trail!

28 Okt 202032min

Episode 207: SQL Trail 2020 Retrospective

Episode 207: SQL Trail 2020 Retrospective

SQL Trail 2020 was a success! There was a time I was unconvinced this would be the case. This is not to say we didn't have issues; however, talking with others helped us avoid some common pitfalls and make our event unique. Although we were virtual, I sent all the attendees a conference t-shirt, some swag, and cookies! I wanted everyone to feel some excitement and a connection that I was not sure would be possible in a virtual setting. The show notes for today's episode can be found at https://sqldatapartners.com/2020/10/15/episode-207-sql-trail-2020-retrospective/. Have fun on the SQL Trail!

15 Okt 202025min

Episode 206: .NET Core Interactions with SQL Server

Episode 206: .NET Core Interactions with SQL Server

There are many programming languages available to the modern developer and there are even more options for connecting to the database. In this episode, we talk with Taurius Litvinavicius about his Manning course on connecting .NET Core to SQL Server. The show notes for today's episode can be found at https://sqldatapartners.com/2020/09/16/episode-206-net-core-interactions-with-sql-server. Have fun on the SQL Trail!

17 Sep 202038min

Populärt inom Utbildning

bygga-at-idioter
historiepodden-se
det-skaver
rss-bara-en-till-om-missbruk-medberoende-2
alska-oss
nu-blir-det-historia
svd-ledarredaktionen
harrisons-dramatiska-historia
allt-du-velat-veta
johannes-hansen-podcast
not-fanny-anymore
roda-vita-rosen
rikatillsammans-om-privatekonomi-rikedom-i-livet
rss-max-tant-med-max-villman
sektledare
sa-in-i-sjalen
i-vantan-pa-katastrofen
rss-sjalsligt-avkladd
jagaren
rss-npf-podden