DB Weekly Issue 181: November 17, 2017

SQL Operations Studio: A New Data Management Tool from Microsoft — A Windows, macOS and Linux app for working with SQL Server, Azure SQL DB and SQL DW.

Elasticsearch 6.0.0 Released — The popular full-text search-oriented database gains zero downtime upgrades, faster restarts, faster query times, and more. The new version is based on Lucene 7.

Performance Analytics for Amazon Redshift. For Data Engineering Heroes — Amazon Redshift is incredibly powerful, but you can spend a lot of time fighting fires. We fix that. intermix.io gives you the tools you need to analyze your Redshift performance and improve the toolchain of everyone downstream from your cluster.

Building a Microservices Ecosystem with Kafka Streams and KSQL — How to build fine grained, streaming microservices with the Apache Kafka Streams API and KSQL.

Datasette: Instantly Build an API for SQLite Databases — Got an SQLite database you want to share on the web? This is the tool for you.

MariaDB Coming to Azure as Microsoft Joins the MariaDB Foundation — The popular MySQL fork continues to make big steps.

Distributed PostgreSQL Settling Into Cloud — Citus brings horizontal scalability to Postgres users.

Google Cloud's Distributed NoSQL Database Spanner Goes Global

Azure Cosmos DB Launches Native Support for the Apache Cassandra API — Allows you to take Cassandra-backed apps to Azure using Microsoft’s scalable multi-model database, Cosmos.

Using Grafana with SiriDB — Learn how to setup a Grafana dashboard using the SiriDB plugin.

Troubleshooting MongoDB 100% CPU Load and Slow Queries

Faster Bulk Loading in Postgres with 'Copy' — \copy is a mechanism for you to bulk load data in or out of Postgres.

How ACID Transactions Work in a Globally Distributed Database — .. or FaunaDB, specifically.

The Mode Ordered-Set Aggregate Function — A way to find the most frequent input value in a group.

How to Avoid Excessive Sorts in Window Functions

How to Approach Cassandra NoSQL Data Model Design

Continuous Delivery: GoCD vs. Jenkins — We compared GoCD with Jenkins on philosophy, continuous delivery & plugins. Understand how these CI/CD tools fit your needs.

PostgreSQL 10: An 'Amplified' Version of PostgreSQL — Why version 10 is "the defining version" of the popular RDBMS.

YCSB Benchmark Results for YugaByte and Apache Cassandra — Yugabyte is a new database we featured 2 weeks ago which is compatible with Cassandra’s API.

How Should You Build A High-Performance Column Store for the 2020s?

dbmgr: CLI Tool to Back Up, Restore, and Provision Dev Databases — For MySQL and Postgres only so far.