Advanced Database Systems

This is a short post to recommend a course available online.

Rather than a technical course, this is a class at Carnegie Mellon University: Advanced Database Systems.

The class is given by Andy Pavlo and covers all the internal of advance database systems, focussing on in-memory.

We are taken on a...

Service Endpoint vs Private Endpoint in Azure

What is the difference between Service Endpoint and Private Endpoint in Azure?

What are the advantage of one versus the other?

When should we use one versus the other?

For this article, I’ve done something a different. I’ve created a video on YouTube.

Change Management in a Kusto Database

Let’s say you’ve setup an Azure Data Explorer cluster. You’ve also setup real time ingestion pipeline. If you haven’t, take a look at the Real Time Lab I’ve put together, where you’re going to build pipelines and query data in real time.

Now this has been running for weeks, maybe months.

You...

Recursive ADLS Access Control

Last time we showed how to use Logic App to invoke ADLS REST APIs (list blobs specifically) using AAD identities (in this case, Azure’s Managed Service Identities, MSI).

In the past, we discussed access control in Azure Data Lake Storage (ADLS). Those intricacies are useful when accessing ADLS using Azure AD authentication.

Azure Data Lake Storage Logic App with Managed Identities

Last time we discussed some gotcha with Azure Data Lake Storage (ADLS) and access control. Those intricacies are useful when accessing ADLS using Azure AD authentication.

Unfortunately, Azure AD authentication is a little more than one year old, so a lot of tools are still using the good old storage account access keys....