Why your SQL costs more than you think | Saturdata
Saturdata7 Mars

Why your SQL costs more than you think | Saturdata

Think you know SQL? Sam and Shifra break down what separates a query writer from a true data thinker, from basic selects all the way to distributed systems, query plans, and the four pillars of production-ready code. Plus: why your data provider's incentives are working against you, how a 1,400-line monolith hid millions in overstated revenue, and the one approach that will save you from silent, soul-crushing data failures.

🌊 Check out the deep dive here: https://youtu.be/ayNKmcIELEo

We talk about:

- Three levels of SQL (and a secret fourth)

- What they don't teach you in school: data fluency, granularity, and audit patterns

- Why SELECT DISTINCT and ORDER BY are secretly expensive

- WORM vs. WARO: taking cost at write time vs. read time

- Idempotency, query plans, and writing SQL like a query engine

Follow Saturdata, your favorite weekend data podcast:

Spotify: https://open.spotify.com/show/5QolhKm1jDZzVuHO0S9ZBo?si=910efb23833f4fc1

LinkedIn: https://www.linkedin.com/company/saturdata

Instagram: @SaturdataPod

#Saturdata #SQL #DataEngineering #DataAnalytics #QueryOptimization

Chapters:

0:00 - Intro: Squeal and Sasquatch

2:34 - The three levels of SQL: Basic, intermediate, and advanced

6:47 - When advanced SQL isn't really SQL anymore

9:12 - The 1,400-line monolith horror story

13:00 - The four "ilities": Readability, maintainability, observability, and explainability

15:34 - Write once, read many: Taking the cost at write time vs. read time

18:04 - SQL as analyst vs. SQL as architect

22:52 - Platform-dependent code and why your cloud provider is not your friend

25:31 - What school never taught you: Data fluency, granularity, and knowing your tables

35:09 - Why all of this matters: Defending your query like a lawyer

41:49 - What's holding people back: Select star, distinct, and the monolith trap

46:30 - Idempotency, query plans, and thinking like an engine

Avsnitt(46)

AI regulation isn't just a tech problem, it's a people problem

AI regulation isn't just a tech problem, it's a people problem

It's not all firewalls and technical fixes. Here's why shaping the future of AI comes down to soft skills, cultural awareness, and actually showing up for the conversation. Call your rep, use your voi...

6 Apr 57s

We're making up AI as we go | Saturdata with Joey Yudelson

We're making up AI as we go | Saturdata with Joey Yudelson

What happens when you train an evil AI and it just lies really confidently? Joey Yudelson (https://www.linkedin.com/in/joseph-yudelson/), AI safety researcher at Redwood Research, joins Sam and Shifra...

4 Apr 46min

Stop coding, start directing: the AI shift you can't ignore

Stop coding, start directing: the AI shift you can't ignore

Claude Opus is probably a better coder than you, and Joey isn't sugarcoating it. Instead of writing code line by line, the real move could be writing design docs and letting a fleet of AI agents do th...

3 Apr 55s

Your AI chatbot is basically a very well-trained dog named Jeeves 🐾

Your AI chatbot is basically a very well-trained dog named Jeeves 🐾

Ever wondered how ChatGPT actually works? Joey breaks it down in the most hilarious way possible, and honestly, we'll never think about reinforcement learning the same way again. Train it right and it...

2 Apr 4min

How ChatGPT actually works: a dog explains | Saturdata with Joey Yudelson

How ChatGPT actually works: a dog explains | Saturdata with Joey Yudelson

What if you could explain ChatGPT using only a dog, some audiobooks, and a stick? Joey Yudelson joins Sam and Shifra to break down how large language models actually work, no PhD required. From next-w...

1 Apr 4min

Only 300 people stand between AI and catastrophe?

Only 300 people stand between AI and catastrophe?

"The entire field of AI safety is run by roughly 300 to 400 people worldwide, and that number is wild when you think about how fast AI capabilities are moving. Joey thinks YOU could be one of the peop...

1 Apr 46s

States vs. feds: who's really calling the shots on AI?

States vs. feds: who's really calling the shots on AI?

AI regulation is a tug-of-war right now, with states like California and New York pushing for transparency, deepfake protections, and actual liability for AI companies causing massive harm. Meanwhile,...

30 Mars 57s

Spaghetti code hits different in the data world

Spaghetti code hits different in the data world

Not all spaghetti code is created equal! Sam and Shifra break down how data spaghetti goes beyond bad practices into pipelines that only work once, for one dataset, on one very specific Tuesday. From ...

29 Mars 1min

Populärt inom Business & ekonomi

framgangspodden
varvet
rss-jossan-nina
rss-svart-marknad
rss-borsens-finest
badfluence
avanzapodden
uppgang-och-fall
svd-tech-brief
bathina-en-podcast
fill-or-kill
lastbilspodden
rss-dagen-med-di
rss-kort-lang-analyspodden-fran-di
tabberaset
rss-inga-dumma-fragor-om-pengar
24fragor
kapitalet-en-podd-om-ekonomi
rikatillsammans-om-privatekonomi-rikedom-i-livet
borsmorgon