---
title: "This week's database news, issue 102"
publication: "DB Weekly"
issue: 102
published_at: "2016-04-28"
canonical_url: "https://dbweekly.com/issues/102"
---

Database Weekly 102   . 

This week's database news -[Read this on the Web](http://dbweekly.com/issues/102) 

[Database Weekly](http://dbweekly.com) Issue 102 — April 28, 2016     

Featured [10 SQL Tricks That You Didn’t Think Were Possible](https://blog.jooq.org/2016/04/25/10-sql-tricks-that-you-didnt-think-were-possible/?utm_source=dbweekly&utm_medium=email) — A fun, and very extensive, walkthrough of the possibilities and properties of SQL you may have overlooked. Lukas Ederopinion [What I Learned From Programming Databases](http://www.philipotoole.com/what-i-learned-from-programming-a-database/?utm_source=dbweekly&utm_medium=email) — “Programming a database is possibly the most instructive project one can ever complete as a software developer.” Philip O'Toolestory [Neo4j Pushes Graph DB Limits Past a Quadrillion Nodes](http://www.datanami.com/2016/04/26/neo4j-pushes-graph-db-limits-past-quadrillion-nodes/?utm_source=dbweekly&utm_medium=email) — “There is effectively no limit to the sizes of graphs that people can run with Neo4j 3.0,” said Philip Rathle of Neo. Datanamitools [Open Source Rising: Rapidly Building Adoption with Postgres on IBM POWER8, Red Hat](http://www.enterprisedb.com/postgres-plus-edb-blog/marc-linster/open-source-rising-rapidly-building-adoption-edb-postgres-ibm-po?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016LoPBlog) — 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. EnterpriseDBsponsored [![\](https://copm.s3.amazonaws.com/4b6be604.png)](http://www.enterprisedb.com/postgres-plus-edb-blog/marc-linster/open-source-rising-rapidly-building-adoption-edb-postgres-ibm-po?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016LoPBlog) [Managing the New York Stock Exchange with SQL Server](http://www.sqlserverradio.com/lior-king/?utm_source=dbweekly&utm_medium=email) — 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](http://arstechnica.com/information-technology/2016/04/power-tools-sorting-through-the-crowded-specialized-database-toolbox/?utm_source=dbweekly&utm_medium=email) — With so many choices today, matching the right database to the requirements isn’t getting any easier. Ars Technicaopinion [Training Firm's Unexpected Growth Exposes Weakness of Relational Tech](http://www.datanami.com/2016/04/26/firms-unexpected-growth-exposes-weakness-relational-tech/?utm_source=dbweekly&utm_medium=email) — The tale of how one company ran into problems as they rapidly scaled. Datanamistory [Inside Capacitor, BigQuery’s Next-Gen Columnar Storage Format](https://cloud.google.com/blog/big-data/2016/04/inside-capacitor-bigquerys-next-generation-columnar-storage-format?utm_source=dbweekly&utm_medium=email) — BigQuery / Dremel engineer Mosha Pasumansky deep dives into BigQuery storage. He discusses how the new Capacitor storage engine improves efficiency. Googletutorial Jobs [The Easiest Way to Find a Job](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=easiest&utm_campaign=q2-16-dbweekly&utm_location=us) — 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.](https://hired.com/?utm_source=newsletters=petercooperpress=cat-tech-database=easiest=q2-16-dbweekly=us) Hired.​com In brief [Azure SQL Database Now Supports Powerful Geo-Replication Features for All Service Tiers](https://azure.microsoft.com/en-us/blog/azure-sql-database-now-supports-powerful-geo-replication-features-on-all-service-tiers/?utm_source=dbweekly&utm_medium=email) Microsoftnews [Neo4j 3.0 Released: Three Top Things to Look For](http://neo4j.com/blog/neo4j-3-0-massive-scale-developer-productivity/?utm_source=dbweekly&utm_medium=email) Philip Rathlenews [12 Common Mistakes While Backing Up Databases](http://ib-aid.com/en/articles/12-common-mistakes-while-backing-up-databases/?utm_source=dbweekly&utm_medium=email) Alexey Kovyazintutorial [How Gitter Saved $600 Per Month with MongoDB Point-in-Time Recoveries](https://medium.freecodecamp.com/mongodb-point-in-time-recoveries-or-how-we-saved-600-dollars-a-month-and-got-a-better-backup-55466b7d714?utm_source=dbweekly&utm_medium=email) Gittertutorial [Effective Elasticsearch Plugin Management with Docker](https://www.elastic.co/blog/elasticsearch-docker-plugin-management?utm_source=dbweekly&utm_medium=email) Tyler Langloistutorial [Data Warehouse Modeling: The Snowflake Schema](http://www.vertabelo.com/blog/technical-articles/data-warehouse-modeling-the-snowflake-schema?utm_source=dbweekly&utm_medium=email) Emil Drkušićtutorial [What PostgreSQL Tells You About Its Performance](http://okigiveup.net/what-postgresql-tells-you-about-its-performance/?utm_source=dbweekly&utm_medium=email) OK I GIVE UPtutorial [A 2 Minute Intro to the MySQL Document Store](https://www.youtube.com/watch?v=1Dk517M-_7o&utm_source=dbweekly&utm_medium=email) — MySQL Document Store lets you work with relational tables and schema-less JSON collections in parallel. YouTubevideo [Your Technical Documentation Should Be a Graph: Here's Why](http://neo4j.com/blog/technical-documentation-graph/?utm_source=dbweekly&utm_medium=email) Axel Morgneropinion [Have you got SQL fingers?](http://www.red-gate.com/products/sql-development/sql-prompt/?utm_source=dbweekly&utm_medium=displayemail&utm_content=sqlfingers_v2&utm_campaign=sqlprompt&utm_term=email-24848#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.](http://www.red-gate.com/products/sql-development/sql-prompt/?utm_source=dbweekly&utm_medium=displayemail&utm_content=sqlfingers_v2&utm_campaign=sqlprompt&utm_term=email-24848#sql-fingers) sqlprompttools sponsored [ThingieQuery: An SQL Plugin/IDE for Excel](http://thingiequery.com/?utm_source=dbweekly&utm_medium=email) — An Excel plugin that lets you do things using SQL on Excel spreadsheets. ThingieQuerytools [JetBrains DataGrip: A New IDE for Databases and SQL](https://www.jetbrains.com/datagrip/?utm_source=dbweekly&utm_medium=email) JetBrainstools [Apache Geode: A Real-Time, Consistent Data Management Platform](https://geode.apache.org/?utm_source=dbweekly&utm_medium=email) Apache Foundationtools [NoDb: Simple File System Storage for .NET Core](https://github.com/joeaudette/NoDb?utm_source=dbweekly&utm_medium=email) — Because “not all projects need a database”. Joe Audettetools [One Call to Rule Them All](http://blog.dreamfactory.com/working-with-virtually-related-data-0?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=onecall) — DreamFactory's autogenerated REST APIs work across multiple databases on a multitude of servers. Free, open source platform. DreamFactorytools sponsored [TinyDB: A Lightweight, Pure Python Document Oriented DB](https://github.com/msiemens/tinydb?utm_source=dbweekly&utm_medium=email) Markus Siemenscode [SQLite 3.12.2 Released](http://www.sqlite.org/releaselog/3_12_2.html?utm_source=dbweekly&utm_medium=email) SQLitecode [SQL to NoSQL: Top 6 Questions Before Making The Move](http://www.slideshare.net/dashDB/sql-to-nosql-top-6-questions-before-making-the-move?utm_source=dbweekly&utm_medium=email) — What to consider when moving from the world of relational databases to a NoSQL document store. Glynn Bird [Migrating 700GB of MySQL Data](http://engblog.yext.com/post/migrating-mysql-data?utm_source=dbweekly&utm_medium=email) Joshua Blenderstory    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/102) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK