https://blog.moertel.com/posts/2024-08-23-sampling-with-sql.html Sampling with SQLTom MoertelAugust 23, 2024 “Sampling is one of the most powerful tools you can wield to extract meaning from large datasets…. If you know how to take
What I Read: SQL order
https://lukianovihor.medium.com/sql-order-of-query-execution-8c7cd926400 SQL — order of query executionIhor LukianovSep 24, 2023 “To maximize your query’s speed on any SQL engine, it’s essential to have an understanding of the SQL execution order.”
What I Read: Database Disassembly
https://materializedview.io/p/databases-are-falling-apart Databases Are Falling Apart: Database Disassembly and Its ImplicationsChris RiccominiJan 29, 2024 “Why are engineers taking databases apart and putting them back together, again?”
What I Learn: SQL, Malloy
https://carlineng.com/?postid=sql-renaissance#blog SQL, Malloy, and the Art of the RenaissanceCarlin Eng02.05.2023 “By allowing sub-tables within resultsets, Malloy results are able to faithfully represent the true dimensionality of the underlying data.”