---
title: "This week's database news, issue 81"
publication: "DB Weekly"
issue: 81
published_at: "2015-11-27"
canonical_url: "https://dbweekly.com/issues/81"
---

Database Weekly 81   . 

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

[Database Weekly](http://dbweekly.com) Issue 81 — November 27, 2015     

Featured [50 Shades of NULL](http://www.vertabelo.com/blog/technical-articles/50-shades-of-null-or-how-a-billion-dollar-mistake-has-been-stalking-a-whole-industry-for-decades?utm_source=dbweekly&utm_medium=email) — Subtitled “How a Billion Dollar Mistake has Been Stalking a Whole Industry for Decades”, this is a look at the history of nil/null values and how NULL works in SQL. Lukas Eder [What NoSQL Solution Should You Choose?](http://kuzzle.io/blog/2015/11/what-nosql-solution-should-you-choose-mongodb-elastisearch-oriendb/?utm_source=dbweekly&utm_medium=email) — Quick summaries of MongoDB, Elasticsearch, OrientDB, Hadoop, and Cassandra, focusing on what each can and can’t do. Kuzzleopinion [Heroic: A Time Series Database from Spotify](http://spotify.github.io/heroic/?utm_source=dbweekly&utm_medium=email) — Heroic is an open-source monitoring system originally built at Spotify to address the problems being faced with large scale gathering and near real-time analysis of metrics. Spotifycode [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-24174) — Watch these free SQL Prompt tips videos for SQL writing hints from top SQL Server MVPs. SQL Prompt is the SQL code productivity add-in for SQL Server Management Studio and Visual Studio. [Find out how easily you can write SQL.](http://www.red-gate.com/products/sql-development/sql-prompt/?utm_source=dbweekly=displayemail=sqlfingers_v2=sqlprompt=email-24174) Red Gate Softwaresponsored [![\](https://copm.s3.amazonaws.com/f5304ccf.gif)](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-24174) [Organize Complex Queries Using SQL's 'WITH'](https://modern-sql.com/feature/with?utm_source=dbweekly&utm_medium=email) — SQL:1999 introduced the ‘WITH’ clause to define “views” within queries. These with-queries are only visible in a single statement and can be used to improve the structure of this statement without polluting the global namespace. Markus Winand [Apache Geode: A Distributed, In-Memory Low Latency Database](http://geode.incubator.apache.org/?utm_source=dbweekly&utm_medium=email) — The Apache-incubated open source version of a commercial in-memory database called GemFire. Apache [HyperLogLog in Pure SQL](https://www.periscopedata.com/blog/hyperloglog-in-pure-sql.html?utm_source=dbweekly&utm_medium=email) — Hyperloglog is a very interesting algorithm and you can have an extremely efficient version [directly in Postgres](https://github.com/aggregateknowledge/postgresql-hll). And if you’re not up for building and pulling in your own extensions here’s a raw SQL implementation of it. Periscope [10 Use Cases Where NoSQL Will Outperform SQL](http://www.networkworld.com/article/2999856/big-data-business-intelligence/10-use-cases-where-nosql-will-outperform-sql.html?utm_source=dbweekly&utm_medium=email) — Written by a director at Couchbase. Network Worldopinion Jobs [Freelance with Companies like Airbnb, IDEO, & JPMorgan](http://www.toptal.com/developers?utm_source=cooperpress&utm_medium=cpm-newsletter&utm_content=freelanceWithCompanies&utm_campaign=db) — Work with top clients, set your own rates, and work from anywhere as an elite Toptal developer. Join the most exclusive network of top software engineers in the world. Toptal In brief [4 Upcoming Database Conferences: Winter 2015-2016](http://www.vertabelo.com/blog/notes-from-the-lab/upcoming-database-conferences-winter-2015-2016?utm_source=dbweekly&utm_medium=email) Leandro Toniutnews [What End of Support for SQL Server 2005 Means for CIOs](http://www.cio.com/article/3007062/servers/what-end-of-support-for-sql-server-2005-means-for-cios.html?utm_source=dbweekly&utm_medium=email) CIOnews [Recent Improvements to Redis Lua Scripting](http://antirez.com/news/97?utm_source=dbweekly&utm_medium=email) Salvatore Sanfilipponews [Redis Performance Dashboard and Autoscaling from RedisGreen](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2015b&utm_content=link&utm_term=seamless%20autoscaling%20performance) — Seamless scaling and analytics backed by support from engineers who have been scaling Redis for years. RedisGreentools sponsored [Adding Summary Statistics to your SQL Table](https://periscopedata.com/blog//sql-summary-statistics.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Understanding ElasticSearch Performance](https://joshrendek.com/2015/11/understanding-elasticsearch-performance/?utm_source=dbweekly&utm_medium=email) Josh Rendektutorial [A MySQL Data Analysis Example In 3 Easy Steps](http://www.datapine.com/blog/mysql-data-analysis-example/?utm_source=dbweekly&utm_medium=email) Agata Kwapientutorial [Bulk Transformations of Couchbase Data Using Apache Spark with an External Source](http://blog.couchbase.com/bulk-transformations-of-couchbase-data-with-an-external-source-using-apache-spark?utm_source=dbweekly&utm_medium=email) Matt Ingenthrontutorial [How to Monitor Neo4j-Based Application Performance with Ruxit](http://neo4j.com/blog/neo4j-application-performance-ruxit/?utm_source=dbweekly&utm_medium=email) Wolfgang Beertutorial [Generated Primary and Foreign Keys for Distributed Databases](http://www.enterprisedb.com/postgres-plus-edb-blog/dick-dowdell/generated-primary-and-foreign-keys-distributed-databases?utm_source=dbweekly&utm_medium=email) Dick Dowdelltutorial [pg_paxos: High Availability Data Replication for PostgreSQL](https://www.citusdata.com/blog/14-marco/335-pgpaxos-high-availability-table-replication-postgresql?utm_source=dbweekly&utm_medium=email) Citus Datatools [The Ultimate list of Top SQL Monitoring Tools](http://cloudmonix.com/blog/the-ultimate-list-of-top-sql-monitoring-tools/?utm_source=dbweekly&utm_medium=email) Cloudmonixtools [Choosing a Database for Analytics](https://segment.com/blog/choosing-a-database-for-analytics/?utm_source=dbweekly&utm_medium=email) Segmentopinion [How to Achieve Outstanding Performance with MongoDB Monitoring](https://blog.ruxit.com/how-to-achieve-outstanding-performance-with-mongodb-monitoring/?utm_source=dbweekly&utm_medium=email) Martin Goodwellopinion    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/81) [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