SQL – Page 3 – Andrew Fairless, Ph.D.

What I Read: Snowflake Query Optimizer

By Andrew Fairless on October 11, 2022September 27, 2022

https://teej.ghost.io/understanding-the-snowflake-query-optimizer/ Understanding the Snowflake Query OptimizerSep 18, 2022 “The job of a query optimizer is to reduce the cost of queries without changing what they do…. Query optimizers aren’t uniqueContinue readingWhat I Read: Snowflake Query Optimizer

What I Read: State of Data Engineering 2022

By Andrew Fairless on August 3, 2022June 27, 2022

https://www.rudderstack.com/blog/the-state-of-data-engineering-in-2022/ The State of Data Engineering in 2022Eric DoddsJanuary 05, 2022 “In this post, we wanted to share our thoughts on the data industry in 2022…”

What I Read: Death of Data Modeling

By Andrew Fairless on July 18, 2022June 27, 2022

https://dataproducts.substack.com/p/the-death-of-data-modeling-pt-1?s=r The Death of Data Modeling – Pt. 1And why it must be resurrected in the Modern Data StackChad Sanderson “The Death of Data Modeling and why it must beContinue readingWhat I Read: Death of Data Modeling

What I Read: Bundling into the Database

By Andrew Fairless on July 5, 2022June 27, 2022

https://www.ethanrosenthal.com/2022/05/10/database-bundling/ Let’s Continue Bundling into the DatabaseEthan RosenthalMay 10, 2022 “Truthfully, I just want to argue that feature stores, metrics layers, and machine learning monitoring tools are all abstraction layersContinue readingWhat I Read: Bundling into the Database

What I Read: Dataset-Centric Visualization

By Andrew Fairless on May 23, 2022April 25, 2022

https://preset.io/blog/dataset-centric-visualization/ DATA ENGINEERINGThe Case for Dataset-Centric VisualizationMaxime BeaucheminMarch 30, 2022 “Different BI tools offer different approaches to building dashboards. On one end of the spectrum, you have tools that prescribeContinue readingWhat I Read: Dataset-Centric Visualization

What I Read: marketplace ranking infrastructure

By Andrew Fairless on March 15, 2022January 20, 2022

https://craft.faire.com/building-faires-new-marketplace-ranking-infrastructure-a53bf938aba0 Building Faire’s new marketplace ranking infrastructureSam KennyNov 3, 2021 “At Faire, all three of these core surfaces are powered by one unified ranking infrastructure that we refer to internallyContinue readingWhat I Read: marketplace ranking infrastructure

What I Read: Against SQL

By Andrew Fairless on September 1, 2021August 17, 2021

https://scattered-thoughts.net/writing/against-sql/ Against SQLJamie BrandonLast updated 2021-07-09 “The core message that I want people to take away is that there is potentially a huge amount of value to be unlocked byContinue readingWhat I Read: Against SQL

What I Read: Understanding Key-Value Databases

By Andrew Fairless on April 29, 2021April 10, 2021

https://www.kdnuggets.com/2021/04/nosql-explained-understanding-key-value-databases.html NoSQL Explained: Understanding Key-Value DatabasesBy Alex Williams, Hosting Data UK “Among the four big NoSQL database types, key-value stores are probably the most popular ones due to their simplicityContinue readingWhat I Read: Understanding Key-Value Databases

What I Read: How Build Production Workflow SQL

By Andrew Fairless on February 22, 2021January 27, 2021

https://shopify.engineering/build-production-grade-workflow-sql-modelling How to Build a Production Grade Workflow with SQL Modellingby Michelle Ark Data Science & EngineeringNov 19, 2020 “We’ll show you how we moved to a SQL modelling workflowContinue readingWhat I Read: How Build Production Workflow SQL

What I Read: Why is dbt important?

By Andrew Fairless on February 12, 2021January 14, 2021

https://stephen.sh/posts/why-is-dbt-so-important Why is dbt so important? “Last summer, we migrated Monzo’s entire analytics infrastructure to dbt from a homegrown solution. This took significant effort, but I’m glad we did it.Continue readingWhat I Read: Why is dbt important?

Tag: SQL