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

Database Weekly 96   . 

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

[Database Weekly](http://dbweekly.com) Issue 96 — March 18, 2016     

Featured [10 Easy Steps to a Complete Understanding of SQL](http://blog.jooq.org/2016/03/17/10-easy-steps-to-a-complete-understanding-of-sql/?utm_source=dbweekly&utm_medium=email) — A walk through some of the fundamentals of SQL and the key concepts it introduces by being a declarative language rather than imperative or object oriented. Jooqtutorial [Denormalization: When, Why, and How](http://www.vertabelo.com/blog/technical-articles/denormalization-when-why-and-how?utm_source=dbweekly&utm_medium=email) — So your data model was built by the book complete with normal form, but you still need to improve performance? Denormalization is a technique that should be considered. Emil Drkušić [AWS Database Migration Service](https://aws.amazon.com/blogs/aws/aws-database-migration-service/?utm_source=dbweekly&utm_medium=email) — You can move live, terabyte-scale databases to the cloud, with options to stick with your existing database platform or to upgrade to a new one. Amazontools [Compose Enterprise: Deploy databases in minutes](https://enterprise.compose.io/?utm_source=cooper&utm_medium=dbweekly&utm_campaign=enterprise-micro1) — We've just launched the beta of Compose Enterprise, a new powerful option for using Compose which lets you deploy production-ready databases with ease within your own cloud clusters. Compose.​iosponsored [![\](https://copm.s3.amazonaws.com/50a23008.png)](https://enterprise.compose.io/?utm_source=cooper&utm_medium=dbweekly&utm_campaign=enterprise-micro1) [Designing a RESTful API with Node and Postgres](http://mherman.org/blog/2016/03/13/designing-a-restful-api-with-node-and-postgres/?utm_source=dbweekly&utm_medium=email) — A complete walkthrough of creating a RESTful Web service using Express, Postgres, and pg-promise. Michael Hermantutorial [Building A Photo Search in A Weekend with Elasticsearch](http://blog.sandeepchivukula.com/posts/2016/03/06/photo-search/?utm_source=dbweekly&utm_medium=email) — Using Docker to get things up and running quickly, this tutorial series demonstrates using Elasticsearch as an image search system. Sandeep Chivukulatutorial [Tile38: Geolocation Data Store, Spatial Index, and Realtime Geofence](https://github.com/tidwall/tile38?utm_source=dbweekly&utm_medium=email) — It supports a variety of object types including lat/lon points, bounding boxes, XYZ tiles, Geohashes, and GeoJSON. Josh Bakercode [Turning The Database Inside Out with Apache Samza](http://www.confluent.io/blog/turning-the-database-inside-out-with-apache-samza/?utm_source=dbweekly&utm_medium=email) — An introduction to Apache Samza, a distributed stream processing framework, both in video and extended transcript form. Martin Kleppmann Jobs [Chain works with Visa/Nasdaq to digitize money & you'll never guess which RDBMS we use](https://jobs.lever.co/chain/1a22df50-4600-4ea2-80ce-89853bad056c) — Come work with us as we rethink the tech stack for financial services. We need folks who are experts in database systems and are eager to make a big impact. Chain.​com [Stop Applying to Jobs - Let Companies Apply to You](https://hired.com/?utm_source=newsletters&utm_medium=dbweekly&utm_term=cat-tech-database&utm_content=stopapplyingtojobs&utm_campaign=q1-16&utm_location=us) — On Hired, sign up in 10 minutes and get offers from top companies like Facebook, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week. Try it today. Hired.​com In brief [Microsoft SQL Server for Linux Is A Brilliant and Logical Idea](http://www.theregister.co.uk/2016/03/14/microsoft_sql_server_linux_not_insane/?utm_source=dbweekly&utm_medium=email) — “Microsoft appear to have decided that their future is in cloud, not the enterprise data centre.” The Registernews [Data Warehouse Market Ripe for Disruption, Gartner Says](http://www.datanami.com/2016/03/14/data-warehouse-market-ripe-disruption-gartner-says/?utm_source=dbweekly&utm_medium=email) Datanaminews [Couchbase Raises $30m in Series-F Fundraising Round](http://www.theregister.co.uk/2016/03/15/couchbase_pockets_30m_in_er_whats_this_now_gosh_series_f/?utm_source=dbweekly&utm_medium=email) The Registernews [Crate Raises $4M Seed Round for Its Next-Gen SQL Database](http://techcrunch.com/2016/03/15/crate-raises-4m-seed-round-for-its-next-gen-sql-database/?utm_source=dbweekly&utm_medium=email) TechCrunchnews [Microsoft exec: Frustrated customers are lining up to ditch Oracle and jump on our cloud](http://www.businessinsider.com/why-microsoft-put-sql-server-on-linux-2016-3?utm_source=dbweekly&utm_medium=email) Business Insidernews [Monitor MySQL, Redis, DynamoDB, Amazon RDS, Postgres, and more](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeekly&utm_content=Databases) — Datadog collects DB metrics for graphing, alerting, and full-stack correlation analysis. 14-day unlimited trial. Datadogtools sponsored [Graph Databases 101](http://www.cray.com/blog/graph-databases-101/?utm_source=dbweekly&utm_medium=email) — A quick, high level introduction to what graph databases are about. David Mizelltutorial [A Quick Look At Postgres' Source Code](http://www.zerobugsandprogramfaster.net/essays/3.html?utm_source=dbweekly&utm_medium=email) Kate Thompsontutorial [An Overview of Apache Streaming Technologies](https://databaseline.wordpress.com/2016/03/12/an-overview-of-apache-streaming-technologies/?utm_source=dbweekly&utm_medium=email) Databaselinetutorial [Search for Emoji with Elasticsearch](http://jolicode.com/blog/search-for-emoji-with-elasticsearch?utm_source=dbweekly&utm_medium=email) Damien Alexandretutorial [Analyzing Your Gmail Email Dump with SQL](https://periscopedata.com/blog//analyzing-your-email-with-sql.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [On-Time Flight Performance with GraphFrames for Apache Spark](https://databricks.com/blog/2016/03/16/on-time-flight-performance-with-spark-graphframes.html?utm_source=dbweekly&utm_medium=email) Databrickstutorial [Descriptive Statistics in SQL](http://www.jeannicholashould.com/2016/03/15/descriptive-statistics-in-sql.html?utm_source=dbweekly&utm_medium=email) Jean-Nicholas Houldtutorial [Why Hadoop Must Evolve Toward Greater Simplicity](http://www.datanami.com/2016/03/15/hadoop-must-evolve-toward-greater-simplicity/?utm_source=dbweekly&utm_medium=email) Alex Woodieopinion [Redis Performance Dashboard and Autoscaling from RedisGreen](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2016a&utm_content=link&utm_term=findout+autoscaling+performance) — Redis auto-scaling and analytics. Backed by support from engineers with years of Redis scaling expertise. RedisGreentools sponsored [Slazure: A Runtime Data Mapper for .NET developers](https://www.syssurge.com/Products/Slazure/Home.aspx?utm_source=dbweekly&utm_medium=email) SysSurge AStools [mailcap: Email Capture and Archiving Server on RethinkDB](https://github.com/internalfx/mailcap?utm_source=dbweekly&utm_medium=email) — A SMTP server tied to RethinkDB for storage. Bryan Morriscode [Match: Scalable Reverse Image Search built on Kubernetes and Elasticsearch](https://github.com/pavlovml/match?utm_source=dbweekly&utm_medium=email) Pavlovcode [regrid: A File Storage System for RethinkDB Inspired by GridFS](https://github.com/internalfx/regrid?utm_source=dbweekly&utm_medium=email) Bryan Morriscode    

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