Last week reading (2018-12-30)

Good day SQL folks!

Here is your weekly list of articles worth to read! The year is almost ended so I would like to wish you all the best in the new year! We have SQL Server 2019 with all exciting features, we have the Azure Cloud with new “stuff” that will be announced soon!!!

But now, straight to the point – today I give you a lot of Azure Cosmos DB articles to read!

Optimizing for development and testing in Azure Cosmos DB

How to start Azure Cosmos DB development for free.. You have three options to do it without any investment on your side.

Azure Cosmos DB and multi-tenant systems

Building a multi-tenant system on another multi-tenant system can be challenging, but Azure provides us all the tools to make our task easy. An example of a multi-tenant system would be a company providing background check services that any other company can use in their HR system.

Working with Azure Cosmos DB stored procedures, triggers, and user-defined functions

Azure Cosmos DB provides language-integrated, transactional execution of JavaScript. When using the SQL API in Azure Cosmos DB, you can write stored procedures, triggers, and user-defined functions (UDFs) in the JavaScript language. You can write your logic in JavaScript that executed inside the database engine.

Optimize the cost required to read and write data from Azure Cosmos DB

This article describes how the cost required to read and write data from Azure Cosmos DB is calculated. Read operations include get operations on items and write operations include insert, replace, delete, and upsert of items.

Total Cost of Ownership(TCO) with Azure Cosmos DB

Azure Cosmos DB is designed with the fine grained multi-tenancy and resource governance. This design allows Azure Cosmos DB to operate at significantly lower cost and help users save. Currently Azure Cosmos DB supports more than 280 customer workloads on a single machine with the density continuously increasing, and thousands of customer workloads within a cluster.

Cheers,

Damian