---
title: "#151: The Top Features Coming to SQL Server 2017"
publication: "DB Weekly"
issue: 151
published_at: "2017-04-21"
canonical_url: "https://dbweekly.com/issues/151"
---

Database Weekly 151   . 

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

[Database Weekly](http://dbweekly.com) Issue 151 — April 21, 2017     

Featured [GeoMesa: An Open-Source Spatio-Temporal Database Layer](http://www.geomesa.org/?utm_source=dbweekly&utm_medium=email) — GeoMesa provides spatio-temporal indexing on top of Accumulo, Bigtable, and Cassandra, as well as near real-time stream processing and spatial semantics on top of Kafka. The GeoMesa Projecttools [Amazon Redshift Spectrum: Exabyte-Scale In-Place Queries of S3 Data](https://aws.amazon.com/blogs/aws/amazon-redshift-spectrum-exabyte-scale-in-place-queries-of-s3-data/?utm_source=dbweekly&utm_medium=email) — Spectrum makes it possible to run complex queries using Redshift on data stored on AWS S3 without any loading or data prep. Amazontools [The Top Features Coming to SQL Server 2017](https://redmondmag.com/articles/2017/04/19/sql-server-2017-preview.aspx?utm_source=dbweekly&utm_medium=email) — A summary of what Microsoft has unveiled as coming to SQL Server 2017 from [Python support](https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/19/python-in-sql-server-2017-enhanced-in-database-machine-learning/) to adaptive query optimization and [a built-in graph database.](https://docs.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-overview) Joey D'Antoninews [High Available and Scalable Open Source Database - SiriDB](http://siridb.net/) — The time series database SiriDB can scale on the fly, is robust by design and uses a unique mechanism to operate without indexes. SiriDB’s query language includes dynamic grouping for easy and fast analysis. [GitHub repo](https://github.com/transceptor-technology/siridb-server) Transceptor Technologysponsored [![\](https://copm.s3.amazonaws.com/fb47de2c.png)](http://siridb.net/) [How to Calculate Multiple Aggregate Functions in a Single Query](https://blog.jooq.org/2017/04/20/how-to-calculate-multiple-aggregate-functions-in-a-single-query/?utm_source=dbweekly&utm_medium=email) — A look at alternatives to using a large collection of SQL queries to query the same data in different ways, such as pivots and grouping sets. JavaOOQtutorial [Architecture of Giants: Data Stacks at Facebook, Netflix, Airbnb, and Pinterest](https://blog.keen.io/architecture-of-giants-data-stacks-at-facebook-netflix-airbnb-and-pinterest-9b7cd881af54?s=m3&utm_source=dbweekly&utm_medium=email) — Simple event data infrastructure diagrams from several fast-scaling companies. Michelle Wetzlerstory [Why to Use A Relational Database for Time-Series Data](https://blog.timescale.com/time-series-data-why-and-how-to-use-a-relational-database-instead-of-nosql-d0cd6975e87c?utm_source=dbweekly&utm_medium=email) — NoSQL databases are commonly used to store time-series data, but the creator of [TimescaleDB](https://github.com/timescale/timescaledb) sets out a technical case for bringing time-series data into a relational setup. Mike Freedman (Timescale)opinion In brief [Iguazio Re-Architects the Stack for Continuous Analytics](https://www.datanami.com/2017/04/18/iguazio-re-architects-stack-continuous-analytics/?utm_source=dbweekly&utm_medium=email) Datanaminews [Oracle's Databases and Developer Tools Now Available on Docker](https://blog.docker.com/2017/04/oracle-database-dev-tools-in-docker-store/?utm_source=dbweekly&utm_medium=email) — Oracle’s main database product, WebLogic, Coherence, MySQL, and others are available in Docker containers on the Docker Store marketplace. Dockernews [Whitepaper: 5 Steps to Agile DB Management](https://selectstar.io/campaigns/mini-pages/5-steps-to-a-more-agile-database-management.html?utm_source=dbweekly&utm_medium=email) — Database Management is years behind software development. Here's how to bring your DBs up to speed. SelectStarsponsored [Removing Duplicate Rows in Postgres](http://www.cybertec.at/removing-duplicate-rows-in-postgresql/?utm_source=dbweekly&utm_medium=email) — What if you accidentally load data twice? A look at handling duplicate data and a resulting clean up. Hans-Juergen Schoenigtutorial [Tips for Monitoring Redis](http://www.mikeperham.com/2017/04/20/monitoring-redis/?utm_source=dbweekly&utm_medium=email) — Ways to get more info from Redis, such as on latency and slow commands. Mike Perhamtutorial [Creating Role-Based Access Control in MongoDB](https://scalegrid.io/blog/creating-role-based-access-control-in-mongodb/?utm_source=dbweekly&utm_medium=email) ScaleGridtutorial [A Data Model for the Recruitment Process](http://www.vertabelo.com/blog/technical-articles/hire-or-get-hired-a-data-model-for-the-recruitment-process?utm_source=dbweekly&utm_medium=email) vertabelotutorial [MySQL Stored Procedures 101](https://medium.com/@peter.lafferty/mysql-stored-procedures-101-6b4fe230967?utm_source=dbweekly&utm_medium=email) Peter Laffertytutorial [Inside Anodot's Anomaly Detection System for Time-Series Data](https://www.datanami.com/2017/04/19/inside-anodots-anomaly-detection-system-time-series-data/?utm_source=dbweekly&utm_medium=email) Datanamistory [Designing a Data Warehouse on Hadoop](https://wearerealitygames.com/2017/04/14/designing-a-data-warehouse-on-hadoop-2/?utm_source=dbweekly&utm_medium=email) Reality Gamesstory [Running Out of IDs](https://hashrocket.com/blog/posts/running-out-of-ids?utm_source=dbweekly&utm_medium=email) — _“Keep on using serial for most use cases and keep bigserial in your back pocket if a real need arises.”_ Josh Branchaudstory [Cassandra vs. MongoDB](https://scalegrid.io/blog/cassandra-vs-mongodb/?utm_source=dbweekly&utm_medium=email) — Considering the differences between Cassandra vs. MongoDB as the data store for your next project scalegrid.​ioopinion sponsored [BigQuery: One Store to Rule Them All](https://brigade.engineering/bigquery-one-store-to-rule-them-all-222429788d4?utm_source=dbweekly&utm_medium=email) Brigade Engineeringopinion [SQL Is The Perfect Interface](http://dangoldin.com/2017/04/11/sql-is-the-perfect-interface/?utm_source=dbweekly&utm_medium=email) Dan Goldinopinion [Apache ORC: High-Performance Columnar Storage for Hadoop](https://orc.apache.org/?utm_source=dbweekly&utm_medium=email) Apache Foundationtools    

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