--- title: "SQL Server 2019 now generally available" publication: "DB Weekly" issue: 279 published_at: "2019-11-08" canonical_url: "https://dbweekly.com/issues/279" --- This week's database news #279 — November 8, 2019 [Read on the Web](https://dbweekly.com/issues/279) Database Weekly ![](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1573220521/j2lht58kcsefavqck9ny.png) [Neo4j Introduces Aura, Its New Cloud Graph Database Service](https://techcrunch.com/2019/11/06/neo4j-introduces-new-cloud-service-to-simplify-building-a-graph-database/) — Neo4j, a popular (and open source) graph database, has introduced [a new managed cloud service called Aura](https://neo4j.com/aura/) initially aimed at smaller companies looking to get started with graph databases but who don’t want to self-host. TechCrunch [SQL Server 2019 Now Generally Available](https://cloudblogs.microsoft.com/sqlserver/2019/11/04/sql-server-2019-is-now-generally-available/) — The newest major version of SQL Server is here. A focus has been placed on security with extended ‘always encrypted’ support, the T-SQL language has been extended (particularly in regards to communicating with other, third party databases), and ‘Intelligent Query Processing’ provides new ways to optimize queries for performance. Microsoft [![\](https://copm.s3.amazonaws.com/15bc38db.jpg)](https://hubs.ly/H0lCQ4F0) [Reduce Your Database Footprint & Save Money with Compression](https://hubs.ly/H0lCQ4F0) — Want to store your time-series data in an efficient and cost-effective way? TimescaleDB’s new compression capabilities can boost storage savings up to 96%. Learn more from the [blog](https://hubs.ly/H0lCQ4F0) or register for the [webinar](https://hubs.ly/H0lyx5s0) (11/14). Timescale sponsor [An Introduction to Amazon DynamoDB for Cassandra Developers](https://aws.amazon.com/blogs/database/introduction-to-amazon-dynamodb-for-cassandra-developers/) — A look at how you’d achieve some basic Cassandra operations on DynamoDB (Amazon’s fully managed, multi-master NoSQL database) by using AWS CLI. Amazon Web Services [SQLite To Implement Generated Columns?](https://www.sqlite.org/draft/gencol.html) — Generated columns just came to PostgreSQL 12 and now SQLite has a draft design document covering a similar feature which appears to be getting implemented in the next version: 3.31.0. SQLite [TiDB in the Browser: Running a Go-Based Database on WebAssembly](https://pingcap.com/blog/tidb-in-the-browser-running-a-golang-database-on-webassembly/) — An interesting demo. If a database like TiDB written in Go can run in the browser, what about other complex Go apps or other database systems? [SQLite](https://github.com/kripken/sql.js/) is another database that is easily compiled to WebAssembly. Queeny Jin [PostgreSQL 12 Initial Query Performance Impressions](https://www.cybertec-postgresql.com/en/postgresql-v12-initial-query-performance-impressions/) — Postgres 12 came out just a month ago with a variety of features and performance improvements, but how does it _really_ perform in a stress test? It’s a mixed bag with no obvious conclusions to draw. Kaarel Moppel 💻 Jobs [Calling All MySQL Consultants - Work Remotely from Anywhere](https://www.percona.com/about-percona/careers/mysql-consultant) — At Percona you'll get a chance to see and work on any database architecture imaginable. We're looking for MySQL experts. Percona [Find a Job Through Vettery](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started. Vettery 📒 Everything else [Chaos Order: Randomizing Queries to Uncover Order-Dependency](https://www.simplethread.com/chaos-order-randomizing-queries-uncover-order-dependency/) — _“Core SQL Server architect, Conor Cunningham equates depending on query order without an `ORDER BY` clause to driving a car without a seatbelt..”_ Alex Baldwin [Making Mystery-Solving Easier with `auto_explain`](http://richyen.com/postgres/2019/11/06/auto_explain.html) — One of this developer’s clients had a performance issue after migrating from Oracle to PostgreSQL. No fix seemed to work.. `auto_explain` to the rescue! Richard Yen [Client-Side SQL Query Parsing with ANTLR](https://rockset.com/blog/client-side-sql-query-parsing-with-antlr/) — How a database company does basic ANTLR parsing in the browser to separate out SQL statements in a string. Rahel Patel [eBook: Best Practices for Optimizing Postgres Query Performance](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=DBWeeklySecondary) — Learn how to get a 3x performance improvement on your Postgres database and 500x reduced data loaded from disk in this free pganalyze eBook. pganalyze sponsor [How to Build a Node Web App to Manage Azure Cosmos DB SQL API Data](https://docs.microsoft.com/en-us/azure/cosmos-db/sql-api-nodejs-application) — How to use Microsoft Azure Cosmos DB to store and access data from an Express-based app hosted using the _Web Apps_ feature of Microsoft’s _Azure App Service._ Microsoft Azure [lungoDB: A MongoDB-Compatible Embeddable Database and Toolkit for Go(lang)](https://github.com/256dpi/lungo) — Imagine something like SQLite but MongoDB flavored and aimed at Go developers. There are numerous possible use cases, well outlined in the README [here.](https://github.com/256dpi/lungo/blob/master/README.md) Joël Gähwiler A **[Cooperpress](https://cooperpress.com/)** publication. [Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom