--- title: "#169: A Guide to Writing Better SQL Queries" publication: "DB Weekly" issue: 169 published_at: "2017-08-25" canonical_url: "https://dbweekly.com/issues/169" --- Database Weekly 169 This week's database news -[Read this on the Web](http://dbweekly.com/issues/169) [Database Weekly](http://dbweekly.com) Issue 169 — August 25, 2017 [A Guide to Writing Better SQL Queries](http://www.kdnuggets.com/2017/08/write-better-sql-queries-definitive-guide-part-1.html?utm_source=dbweekly&utm_medium=email) — A two part series ([part 2 here](http://www.kdnuggets.com/2017/08/write-better-sql-queries-definitive-guide-part-2.html)) digging into how SQL queries are processed, some anti-patterns, and where big-O complexity gets involved. Karlijn Willemstutorial [Finding all Palindromes Contained in Strings with SQL](https://blog.jooq.org/2017/08/22/finding-all-palindromes-contained-in-strings-with-sql/?utm_source=dbweekly&utm_medium=email) — Using SQL for unusual and complex tasks can be both fun and a great way to learn more. Lukas Edertutorial [Get a preview of what's coming in MongoDB 3.6](https://www.mongodb.com/presentations/mongodb-world-2017-keynotes?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q3&utm_content=primary&utm_medium=display&utm_source=dbweekly0825) — 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. MONGODBsponsored [![\](https://copm.s3.amazonaws.com/ae42d38a.png)](https://www.mongodb.com/presentations/mongodb-world-2017-keynotes?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q3&utm_content=primary&utm_medium=display&utm_source=dbweekly0825) [Amazon Aurora Under The Hood: Quorums and Correlated Failure](https://aws.amazon.com/blogs/database/amazon-aurora-under-the-hood-quorum-and-correlated-failure/?utm_source=dbweekly&utm_medium=email) — Anurag Gupta discusses the design considerations and technology underpinning Aurora, AWS’s highly distributed relational database. Amazon Web Servicesstory [Understanding Correlated and Uncorrelated Sub-Queries in SQL](http://ithare.com/understanding-correlated-and-uncorrelated-sub-queries-in-sql/?utm_source=dbweekly&utm_medium=email) — Sub-queries are queries within another query, but they come in two types: correlated and uncorrelated. Ben Richardsontutorial [In-Memory Database Provider Redis Labs Raises $44M](https://techcrunch.com/2017/08/21/in-memory-database-provider-redis-labs-raises-44m/?utm_source=dbweekly&utm_medium=email) — Redis Labs, a database company focused on Redis, has raised $44 million in a funding round led by Goldman Sachs. Matthew Lynleynews [Index Sorting Coming to Elasticsearch 6.0](https://www.elastic.co/blog/index-sorting-elasticsearch-6-0?utm_source=dbweekly&utm_medium=email) — Will allow users to optimize indexes to store documents on disk in a specific order. Elastic Blognews [M|18 MariaDB User Conference Call for Papers Open](https://mariadb.com/resources/blog/m18-mariadb-user-conference-call-papers-now-open?utm_source=dbweekly&utm_medium=email) — Takes place in February next year in New York. Shane Johnsonnews [Will The Upcoming MongoDB IPO Be A Seminal Moment For The Big Data Market?](http://www.computerworlduk.com/data/why-mongodb-ipo-could-be-seminal-moment-for-nosql-market-3662813/?utm_source=dbweekly&utm_medium=email) Computer Worldnews [The 2017 Firebase Summit is coming to Amsterdam 31 October 2017](https://firebase.google.com/dev-summit-17/?utm_source=cooperpress&utm_medium=dbweekly&utm_campaign=firebasesummit) — 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](https://chatbotslife.com/guide-to-data-synchronization-in-microsoft-sql-server-5f18e84ff5a0?utm_source=dbweekly&utm_medium=email) Michelle Youngtutorial [Why Parameter Sniffing Hurts Your SQL Server Query Performance](https://hackernoon.com/why-parameter-sniffing-hurts-your-sql-query-performance-d73c0da71fbc?utm_source=dbweekly&utm_medium=email) Hacker Noontutorial [5 Essential Steps to Hardening Your MySQL Database](https://medium.com/linode-cube/5-essential-steps-to-hardening-your-mysql-database-591e477bbbd7?utm_source=dbweekly&utm_medium=email) Kyle Rankintutorial [Amazon Aurora Under the Hood: Reducing Costs Using Quorum Sets](https://aws.amazon.com/blogs/database/amazon-aurora-under-the-hood-reducing-costs-using-quorum-sets/?utm_source=dbweekly&utm_medium=email) Amazon Web Servicesstory [How a Company Replaced Mixpanel with BigQuery, Dataflow and Kubernetes](https://blog.doit-intl.com/replacing-mixpanel-with-bigquery-dataflow-and-kubernetes-b5f844710674?utm_source=dbweekly&utm_medium=email) Vadim Soloveystory [Best Practices for Architecting Highly Monitorable Applications](https://www.vividcortex.com/resources/architecting-highly-monitorable-apps?utm_campaign=DB%20Weekly&utm_source=ppc&utm_medium=Architecting%20Highly) — Is your application easy to monitor in production? Many applications are, but sadly, some are designed with observability as an afterthought. VividCortexsponsored [Predixy: A High Performance Redis Proxy](https://github.com/joyieldInc/predixy?utm_source=dbweekly&utm_medium=email) — A fully featured Redis proxy with support for Sentinel and Cluster. Joyield, Inc.​ tools [OmniDB 2.0: A Browser-Based Postgres Management Tool](https://www.postgresql.org/about/news/1775/?utm_source=dbweekly&utm_medium=email) 2nd Quadranttools Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/169) [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