Last week reading (2018-12-09)

Good day SQL folks!

Here is your weekly list of articles worth to read!

Azure Cosmos DB SQL language reference

Azure Cosmos DB supports querying documents using a familiar SQL (Structured Query Language) like grammar over hierarchical JSON documents without requiring explicit schema or creation of secondary indexes. This article provides documentation for the SQL query language syntax, which is compatible with SQL API accounts.

Azure Cosmos DB partitioning design patterns – Part 1

In this article, you will learn how to use partition keys to efficiently distribute data, improve application performance, and enable faster look-up.

Azure SQL Managed Instance Business Critical tier is Generally Available

High availability is implemented using SQL Server Always On technology that ensures that changes made on the primary server are replicated to at least two replicas before the transaction is committed.

Manage consistency levels in Azure Cosmos DB

This article explains how to manage consistency levels in Azure Cosmos DB. You learn how to configure the default consistency level, override the default consistency, manually manage session tokens, and understand the Probabilistically Bounded Staleness (PBS) metric.

Cloud Application Architecture Guide

This cloud computing architecture e-book focuses on architecture, design, and implementation—considerations that apply no matter which cloud platform you choose

Cheers,

Damian