Weekly reading #17
Today I am going to share most of the links about CosmosDB. I was asked if I like this solution or not. Well, I have the luck that I was able to fix a poorly written database to a one that works like a charm. So I like it!
The problem that has been described in this article is very important. Imagine you need to create a document key that is larger than 100 bytes. The older solution that has been present in the Cosmos DB calculated partition key based on the first 100 bytes. Now things has changed and a hash is calculated based on 2kB of data.
Read about the implications (performace).
If the above article was a little bit more complex than start from this one. I would consider it as “Cosmos DB 101”.
This is the seventh part in a series of articles and this is why I consider this as a good resource about pratical approach to the Cosmos DB. There are also information about Azure Functions in context of Cosmos DB and many more. The series has been written by Jason Roberts
Erin Stellato explains how you can attack a problem of assigned memory to queries in SQL Server by playing around with the Query Store
Brent has announced on his blog that there is an updated Stack Overflow public XML data dump. You can download the database from torrent file (40GB). Please prepare a bit more space on your drive as once you uncompress the database has over 350GB.