Last Week Reading (2019-11-03)

This week I’m offering you many posts about Cosmos DB, Azure Data Factory and how to design reliable Azure applications.
Have a great week also for those of you who are not at Microsoft Ignite or PASS Summit.

Press

How to Think Like the SQL Server Engine: What’s a Key Lookup?
One of the episodes of awesome series from Brent Ozar.

Configure Self-Hosted IR as a proxy for Azure-SSIS IR in ADF
Step by step guide if you want to access data on-premises without joining your Azure-SSIS IR to a virtual network.

ADF Adds Avro and CosmosDB Data Flow Connectors
Aggregate and join data on the fly from CosmosDB.

Azure Cosmos DB – Programatically Connect to a preferred location using the SQL API
Set up the location from your app.

Azure Cosmos DB: REST API Reference
Watch this video to learn how to quickly fiddle with Postman to work with RestAPI and CosmosDB. Plus a list of supported REST API Versions.

Export data from Cosmos DB to SQL Server
Arjun describes how to export documents to JSON and import all of them to SQL Server.

Passing a file from an Azure Logic App to a Web API
Sometimes you need a small trick.

Book: Praktyczne uczenie maszynowe
My polish friend, Marcin Szeliga, presents his new book about Machine Learning. Sorry, polish language only.

Resiliency checklist for specific Azure services
You must go through the list…

Resiliency patterns
… and these patterns…

Designing reliable Azure applications
… if you care of resilience of the designed system.

ASF 026: Aaron Bertrand interview
Just to remind you, if you not aware yet, there is a fresh new episode of “Ask SQL Family”.

Power BI End-To-End Features
Melissa Coates updated her amazing diagram. Do you know it?

A word from Microsoft’s CEO

As we wrap up #NDEAM, I wanted to share another example of an innovation built to empower everyone. Eyes First games are designed for people with mobility and speech disabilities to be able to play games using just their eyes. https://t.co/6ulFTpeoCl

— Satya Nadella (@satyanadella) October 30, 2019

Video: Introducing Data Virtualization

Smile Corner