Last week reading (2018-06-11)

Good day SQL folks!

Last week was pretty hot not because of the weather. Microsoft has bought GitHub and this was the news number one for most of the time. Meanwhile I was attending the ITCamp in Cluj giving two lectures about USQL and RLS Security implementation in SQL Server. Especially the second session went not as usual as there was no electricity in the venue and I was the only one who did the session. I had a portable beamer and two power banks and full room of people.

Now let’s start the Monday with something new to read.

Free E-Book: A Developer’s Guide to Building AI Applications

This book, which is clearly developer-focused, walks you through the process of building intelligent cloud-based bots, and makes relevant code samples available from GitHub.

Denormalizing your data with Azure Functions and Cosmos DB’s change feed

In this article you find how to do a denormalization, a common data processing pattern and how it can be easily implemented using Azure Functions to process the change feed of Cosmos DB containers.

Quickstart: Run the SQL Server 2017 container image with Docker

Here you have an introduction of how to start using Docker to pull and run the SQL Server 2017 container image, mssql-server-linux. Then connect with sqlcmd to create your first database and run queries.

From SQL to Azure Cosmos DB – Jimmy Bogard

[Video – 1:01:26] We’ve built on relational databases for decades, and even used SQL databases in the cloud. But the relational model, as flexible as it is, cannot model every modern scenario we see in our applications. With Cosmos DB, we finally have many kinds of NoSQL database at our disposal, all under one umbrella. Key-value, columnar, document, and graphs, we have many more options to build on.

Power BI Desktop June Feature Summary

This month our reporting features focus on accessibility and more flexibility when formatting your charts. With filtering and sorting options, our data view is now more powerful. Several connectors also get major updates this month, including a new driver for our SAP Business Warehouse connector that comes with numerous significant improvements

ASF 010: Dejan Sarka interview

[Podcast – 25:30] If you missed that – there is a new interview. This time with Dejan Sarka who is one of the most recognized person in our DB world. At least one of the most colorful.

Cheers,

Damian