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

What I Read: Data Engineering 2023 Predictions

By Andrew Fairless on February 20, 2023December 16, 2022

https://www.montecarlodata.com/blog-13-data-engineering-trends-for-2023/ What’s Next for Data Engineering in 2023? 13 PredictionsBarr MosesCEO and Co-founder, Monte Carlo. Proponent of data reliability and action movies.Updated November 29, 2022 “…let’s dive into Tomasz’s predictionsContinue readingWhat I Read: Data Engineering 2023 Predictions

What I Read: Data Pipeline Smoke Tests

By Andrew Fairless on January 4, 2023November 5, 2022

https://dagster.io/blog/smoke-test-data-pipeline The Unreasonable Effectiveness of Data Pipeline Smoke TestsSandy RyzaOctober 19, 2022 “Data practitioners waste time writing unit tests to catch bugs they could have caught with smoke tests.”

What I Read: Key-Value Databases

By Andrew Fairless on December 5, 2022October 20, 2022

https://www.kdnuggets.com/2021/04/nosql-explained-understanding-key-value-databases.html Key-Value Databases, ExplainedBy Alex Williams, Hosting Data UK on October 4, 2022 in SQL “Among the four big NoSQL database types, key-value stores are probably the most popular onesContinue readingWhat I Read: Key-Value Databases

What I Read: Data Engineers, What’s the profession about

By Andrew Fairless on December 1, 2022October 20, 2022

https://www.kdnuggets.com/2022/10/11-questions-data-engineers-profession-heading.html 11 Questions About Data Engineers: What’s the profession about, and where’s it heading?I hope my answers will be useful to novice data engineers and anyone interested in data engineering.ByContinue readingWhat I Read: Data Engineers, What’s the profession about

What I Read: SQLite

By Andrew Fairless on November 22, 2022September 27, 2022

SQLite: Past, Present, and Future SQLite: Past, Present, and FutureSaturday, September 24, 2022 “Being designed as an OLTP database, SQLite employs row-oriented execution… However, there is a growing need forContinue readingWhat I Read: SQLite

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

Tag: SQL