January 15, 2022

SQL is Code, Code Review Manners, High-Impact Habits

• Why Google Treats SQL Like Code (and You Should Too).

• I Think I Know Why You Can’t Hire Engineers Right Now sums up what’s important, right out of the gate. Engaging workplaces provide:

  • Cool stuff to work on.
  • Smart people to work with.
  • Some degree of repeatability in work environment.

• I don’t think we talk about code reviews enough. And so: 7 Code Review Manners we should all adopt.

• There is something for all of us here in this post on the 25 Micro-Habits of High-Impact Managers. For me personally, the “growth opportunities” highlighted that I’d like to focus on this year include:

  • Write down what makes you tick… work styles, expectations of your directs, values and motivations, areas of feedback you are working on and decision-making preferences.
  • Follow up and follow through.
  • Take a beat before delivering feedback.

• Teams talk a lot about replacing traditional (Tableau) dashboards with code. Here’s a walkthrough of exactly what it looks like to build a dashboard with Plotly and Dash.

• At first, I thought, Why, but it doesn’t take long to think of all kinds of interesting use case for dsq, a commandline tool for running SQL queries against JSON, CSV, Excel, Parquet.

• A Linear Algebra Reference Guide with examples in NumPy.

• Who wrote this sh!t?

• “Scrum… is like the Kardashians of the software development management framework world.” Ouch. Don’t Make Data Scientists Do Scrum.

• tplot is a Python package for creating text-based graphs. Like we need encouragement to present from the command line.

• How I Built a Shed is from 2020 and it isn’t about data engineering, but I really enjoyed it.