The First Release Candidate of Redis 4.0 is Out — The superfast data structure server is close to another big step forward. 4.0 includes support for custom modules, a new replication system, and more.

A Beginner's Guide to the True Order of SQL Operations — “The SQL language is very intuitive. Until it isn’t.” A thorough tour of how the order of operations in SQL matters.

Google BigQuery, and Why Big Data is About to Have its GMail Moment — “the petabyte-scale of event-based customer interaction records means that it’s easier, cheaper and far less work to hand this sort of workload off to Google”

Building OHLC (open, high, low, close) Data in PostgreSQL — This article illustrates the power of PostgreSQL's aggregate and date functions to analyze financial data, and shows you how to display the results in a web browser using TechanJS.

7 Things Learned About Aurora at AWS re:Invent 2016 — Some of Brent Ozar’s favorite takeaways about Amazon Aurora, Amazon’s homegrown relational database with MySQL compatibility.

Record Query: A Tool for Doing Record Analysis and Transformation — Fills a similar niche to tools like awk or sed, but works with structured (record) data instead of text.

30x Faster Elasticsearch Queries — “we achieved a 30x performance improvement in Elasticsearch queries by switching from millisecond timestamps to seconds”

PostGraphQL: PostgreSQL Meets GraphQL — GraphQL is a data query language originally built at Facebook. PostGraphQL is a library that maps Postgres schemas to GraphQL ones that can then be queried against.

Graph Query Engine Claims Performance Record — Cambridge Semantics claimed a record this week with a load and query of 1 trillion ‘triples’ on the Google Cloud Platform in under 2 hours.

The Wide World of Data Science with Jessica Kirkpatrick — The Analyst is a new podcast about how to use data to solve problems, in business and beyond.