DB Weekly Issue 102: April 28, 2016

Issue 102 — April 28, 2016

Featured

10 SQL Tricks That You Didn’t Think Were Possible — A fun, and very extensive, walkthrough of the possibilities and properties of SQL you may have overlooked.

Lukas Eder

What I Learned From Programming Databases — “Programming a database is possibly the most instructive project one can ever complete as a software developer.”

Philip O'Toole

Neo4j Pushes Graph DB Limits Past a Quadrillion Nodes — “There is effectively no limit to the sizes of graphs that people can run with Neo4j 3.0,” said Philip Rathle of Neo.

Datanami tools

Open Source Rising: Rapidly Building Adoption with Postgres on IBM POWER8, Red Hat — Learn more about RapidBuild program that supports the adoption of Postgres with a tuned, configured, price-performance solution developed by trusted ecosystem partners IBM, Red Hat, EDB, and reseller Avnet.

EnterpriseDB sponsored

Managing the New York Stock Exchange with SQL Server — An interview with Lior King, DBA Team Manager at Intercontinental Exchange (ICE), the company who manages the New York Stock Exchange.

SQL Server Radio

Power Tools: Sorting Through The Crowded Specialized Database Toolbox — With so many choices today, matching the right database to the requirements isn’t getting any easier.

Ars Technica

Training Firm's Unexpected Growth Exposes Weakness of Relational Tech — The tale of how one company ran into problems as they rapidly scaled.

Datanami

Inside Capacitor, BigQuery’s Next-Gen Columnar Storage Format — BigQuery / Dremel engineer Mosha Pasumansky deep dives into BigQuery storage. He discusses how the new Capacitor storage engine improves efficiency.

Google

Jobs

The Easiest Way to Find a Job — Hired lets you sit back while job offers come to you. When you complete your profile, instantly apply to 3,500+ companies on the platform who will contact you with job offers, including salary and equity up-front. Try it today.

Hired.com

In brief

Azure SQL Database Now Supports Powerful Geo-Replication Features for All Service Tiers

Microsoft news

Neo4j 3.0 Released: Three Top Things to Look For

Philip Rathle news

12 Common Mistakes While Backing Up Databases

Alexey Kovyazin

How Gitter Saved $600 Per Month with MongoDB Point-in-Time Recoveries

Gitter

Effective Elasticsearch Plugin Management with Docker

Tyler Langlois

Data Warehouse Modeling: The Snowflake Schema

Emil Drkušić

What PostgreSQL Tells You About Its Performance

OK I GIVE UP

A 2 Minute Intro to the MySQL Document Store — MySQL Document Store lets you work with relational tables and schema-less JSON collections in parallel.

YouTube video

Your Technical Documentation Should Be a Graph: Here's Why

Axel Morgner

Have you got SQL fingers? — Try SQL Prompt and you’ll be able to write, refactor, and reformat SQL effortlessly in SSMS and Visual Studio. Find out more.

sqlprompt tools sponsored

ThingieQuery: An SQL Plugin/IDE for Excel — An Excel plugin that lets you do things using SQL on Excel spreadsheets.

ThingieQuery tools

JetBrains DataGrip: A New IDE for Databases and SQL

JetBrains tools

Apache Geode: A Real-Time, Consistent Data Management Platform

Apache Foundation tools

NoDb: Simple File System Storage for .NET Core — Because “not all projects need a database”.

Joe Audette tools

One Call to Rule Them All — DreamFactory's autogenerated REST APIs work across multiple databases on a multitude of servers. Free, open source platform.

DreamFactory tools sponsored

TinyDB: A Lightweight, Pure Python Document Oriented DB

Markus Siemens code

SQLite 3.12.2 Released

SQLite code

SQL to NoSQL: Top 6 Questions Before Making The Move — What to consider when moving from the world of relational databases to a NoSQL document store.

Glynn Bird

Migrating 700GB of MySQL Data

Joshua Blender