#169: A Guide to Writing Better SQL Queries

This week's database news - Read this on the Web

Database Weekly Issue 169 — August 25, 2017

A Guide to Writing Better SQL Queries — A two part series (part 2 here) digging into how SQL queries are processed, some anti-patterns, and where big-O complexity gets involved. Karlijn Willems   tutorial   Finding all Palindromes Contained in Strings with SQL — Using SQL for unusual and complex tasks can be both fun and a great way to learn more. Lukas Eder   tutorial   Get a preview of what's coming in MongoDB 3.6 — Watch as MongoDB CTO, Eliot Horowitz, explains his commitment to improving, expanding, and innovating on MongoDB before walking through several major improvements coming in MongoDB 3.6 including change streams, retryable writes, and more. MONGODB   sponsored   Amazon Aurora Under The Hood: Quorums and Correlated Failure — Anurag Gupta discusses the design considerations and technology underpinning Aurora, AWS’s highly distributed relational database. Amazon Web Services   story   Understanding Correlated and Uncorrelated Sub-Queries in SQL — Sub-queries are queries within another query, but they come in two types: correlated and uncorrelated. Ben Richardson   tutorial   In-Memory Database Provider Redis Labs Raises $44M — Redis Labs, a database company focused on Redis, has raised $44 million in a funding round led by Goldman Sachs. Matthew Lynley   news   Index Sorting Coming to Elasticsearch 6.0 — Will allow users to optimize indexes to store documents on disk in a specific order. Elastic Blog   news   M|18 MariaDB User Conference Call for Papers Open — Takes place in February next year in New York. Shane Johnson   news   Will The Upcoming MongoDB IPO Be A Seminal Moment For The Big Data Market? Computer World   news   The 2017 Firebase Summit is coming to Amsterdam 31 October 2017 — Attend technical sessions, instructor-led codelabs & demos, and meet-ups with Firebase developers. Google, Inc.​   sponsored   A Guide to Data Synchronization in Microsoft SQL Server Michelle Young   tutorial   Why Parameter Sniffing Hurts Your SQL Server Query Performance Hacker Noon   tutorial   5 Essential Steps to Hardening Your MySQL Database Kyle Rankin   tutorial   Amazon Aurora Under the Hood: Reducing Costs Using Quorum Sets Amazon Web Services   story   How a Company Replaced Mixpanel with BigQuery, Dataflow and Kubernetes Vadim Solovey   story   Best Practices for Architecting Highly Monitorable Applications — Is your application easy to monitor in production? Many applications are, but sadly, some are designed with observability as an afterthought. VividCortex   sponsored   Predixy: A High Performance Redis Proxy — A fully featured Redis proxy with support for Sentinel and Cluster. Joyield, Inc.​   tools   OmniDB 2.0: A Browser-Based Postgres Management Tool 2nd Quadrant   tools   Database Weekly is curated by Peter Cooper Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK