--- title: "#159: What's New in SQL:2016" publication: "DB Weekly" issue: 159 published_at: "2017-06-16" canonical_url: "https://dbweekly.com/issues/159" --- Database Weekly 159 This week's database news -[Read this on the Web](http://dbweekly.com/issues/159) [Database Weekly](http://dbweekly.com) Issue 159 — June 16, 2017 [What's New in SQL:2016](http://modern-sql.com/blog/2017-06/whats-new-in-sql-2016?utm_source=dbweekly&utm_medium=email) — The new ISO standard introduces row pattern recognition, JSON, listagg and many other features. Unsurprisingly, support is currently quite low but should increase over time. Markus Winandtutorial [SQLite 35% Faster Than The Filesystem?](https://www.sqlite.org/fasterthanfs.html?utm_source=dbweekly&utm_medium=email) — A look at how SQLite can be both faster and more space efficient when dealing with small blobs versus the standard filesystem. [Related Hacker News discussion.](https://news.ycombinator.com/item?id=14550060) SQLitestory [How to Optimize Cassandra Database Performance](https://selectstar.io/blog/optimize-cassandra-performance/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=Cassandra_Blog) — 3 ways to ensure that your Cassandra workloads are operating at peak efficiency SelectStarsponsored [![\](https://copm.s3.amazonaws.com/c3cc3ebc.png)](https://selectstar.io/blog/optimize-cassandra-performance/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=Cassandra_Blog) [SystemML, the 'SQL for Machine Learning,' Is Now a Top-Level Apache Project](https://thenewstack.io/systemml-becomes-top-level-project-apache-software-foundation/?utm_source=dbweekly&utm_medium=email) — Developed to provide the ability to scale data analysis from a small laptop to large clusters without the need to rewrite the entire codebase. Susan Hallnews [Amazon Aurora Introduces Database Cloning Capabilities](https://aws.amazon.com/about-aws/whats-new/2017/06/amazon-aurora-introduces-database-cloning-capabilities/?utm_source=dbweekly&utm_medium=email) Amazon Web Servicesnews [TimescaleDB Focuses on Query Power and Scale](https://thenewstack.io/timescaledb-focuses-query-power-scale/?utm_source=dbweekly&utm_medium=email) The New Stacknews [How to Document SQL Server Database Objects](https://www.sqlshack.com/how-to-document-sql-server-database-objects/?utm_source=dbweekly&utm_medium=email) Jefferson Eliastutorial [When to Use Bind Values and When to Use Inline Values in SQL](https://dzone.com/articles/when-to-use-bind-values-and-when-to-use-inline-val?utm_source=dbweekly&utm_medium=email) Lukas Edertutorial [How to Migrate from SQL to MongoDB](https://resources.mongodb.com/migrating-to-mongodb?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=sponsored&utm_medium=display&utm_source=dbweekly0616) — Learn why today's most innovative companies are migrating to MongoDB. MONGODBsponsored [The Different Types of NoSQL Databases](http://opensourceforu.com/2017/05/different-types-nosql-databases/?utm_source=dbweekly&utm_medium=email) — Key-value stores, document stores, column stores, and graph databases. Roopendra Vishwakarmatutorial [Mosaic: Processing A Trillion-Edge Graph On A Single Machine](https://blog.acolyer.org/2017/05/30/mosaic-processing-a-trillion-edge-graph-on-a-single-machine/?utm_source=dbweekly&utm_medium=email) — A look at an interesting architecture: _“Unless your graph is bigger than Facebook’s, you can process it on a single machine.”_ Adrian Colyerstory [Using UUID or GUID as Primary Keys? Be Careful](https://tomharrisonjr.com/uuid-or-guid-as-primary-keys-be-careful-7b2aa3dcb439?utm_source=dbweekly&utm_medium=email) — You can use UUIDs as the primary key to avoid certain scaling problems, but should you? Tom proposes an alternative. Tom Harrison Jropinion [How to Properly Monitor Elasticsearch](https://thenewstack.io/properly-monitor-elasticsearch/?utm_source=dbweekly&utm_medium=email) Eric Bernsentutorial [SQL Server 2016 Row Level Security In Action](https://gavindraper.com/2017/06/07/sql-server-row-level-security/?utm_source=dbweekly&utm_medium=email) Gavin Draper [What You Need to Know about SQL Server's Distinct Windowed Aggregate Calculations](http://sqlmag.com/sql-server/what-you-need-know-about-distinct-windowed-aggregate-calculations?utm_source=dbweekly&utm_medium=email) Itzik Ben-Gantutorial [SQL Server 2017 Graph Data Features In Action](https://gavindraper.com/2017/06/12/sql-server-2017-graph-data/?utm_source=dbweekly&utm_medium=email) Gavin Drapertutorial [Running SQL Queries Against Baby Names from Social Security Card Applications](http://sqlservercode.blogspot.com/2017/06/running-sql-queries-against-baby-names.html?utm_source=dbweekly&utm_medium=email) Denis Gobotutorial [All the developer services you want, wherever you want them](https://www.manifold.co/?utm_campaign=manifold-2017-wk-24&utm_source=dbweekly&utm_medium=email&utm_content=db-weekly-1) — Manifold enables you to purchase everything from RedisGreen to CloudAMQP with one account, on one bill. Manifoldtools sponsored [oi: Blazingly Fast Ordered Data Intersection Tool](https://github.com/mtojek/oi?utm_source=dbweekly&utm_medium=email) — Grep request logs in the blink of an eye. Marcin Tojektools [Soundwave: A Configuration Management Database](https://medium.com/@Pinterest_Engineering/soundwave-an-open-source-configuration-management-database-df75b31b8f5a?utm_source=dbweekly&utm_medium=email) Pinterest Engineeringtools Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/159) [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