Introduction While working on some DR documentation, I realized that the Azure Portal doesn't reveal whether Availability Zones are in use ? This concise post summarizes geo-replication & availability zones and shows how to unveil if availability zones got enabled upon creating the registry.   About Availability Zones & Geo-Replication Azure Container Registry comes in three service tiers: Basic, Standard, and Premium. However, only the Premium tier supports geo-replication and availability zones. With AZ enabled, your registry will get replicated across all the other data center ..read more

Introduction This will be a short documenting article where I demonstrate how to change the access tiers for blobs and file shares using Azure PowerShell and Azure CLI. Content How to view the storage accounts performance SKU with Azure PowerShell and Azure CLI How to view and change the default blob access tier with Azure PowerShell and Azure CLI How to view and change the access tier for specific blobs with Azure PowerShell and Azure CLI How to view and change the access tier of a file share with Azure PowerShell and Azure CLI View the storage account performance SKU When creating a new s ..read more

Introduction There might be situations where you or a group of people wants to get notified in case something goes wrong in any of your long-running PL/pgSQL code. This short article demonstrates how Azure Monitor can be leveraged for this kind of task. Configuration First, we'll have to forward the server logs to a Logs Analytics workspace, which we then use to create an Azure Monitor Alert. So let's create a workspace in case there is not one in place yet. Create a Log Analytics Workspace There is nothing exciting about that. Just navigate to the Azure Portal, enter Log Analytics workspaces ..read more

Introduction The previous articles discovered how middleware components for ASP.NET Core can be written either inline by using lambda expressions or by writing convention-based middleware classes. This post will introduce factory-based middleware components. Articles in this series Part 1 - Introduction to ASP.NET Core middleware Part 2 - Writing inline ASP.NET Core middleware using lambda expressions Part 3 - Writing convention-based ASP.NET Core middleware Part 4 - Writing factory-based ASP.NET Core middleware Part 5 - Testing ASP.NET Core middleware (coming soon) Factory-based middleware S ..read more

Introduction The first part of this series explained what an ASP.NET Core middleware is and how it plays a central role when processing HTTP requests. There are three ways to write a middleware component. Very simple functionality can be formulated inline by using lambda expressions. In more complex situations, you'll want to outsource the envisioned functionality into a separate class. These types must then either follow a convention or implement an interface so they can be instantiated during runtime. This is part two of a five-part series that covers inline middleware. Part 1 - Introductio ..read more

Introduction Anyone who writes a web application with ASP.NET Core uses at least one middleware component. But what exactly is middleware a middleware component, and how does it work? And why would I want to write one myself? In this five-part series, I'll show what middleware components are, how they work, and how you can develop one yourself. I'll also highlight testability and give some examples. Part 1 - Introduction to ASP.NET Core middleware (this article) Part 2 - Writing inline ASP.NET Core middleware using lambda expressions Part 3 - Writing convention-based ASP.NET Core middleware ..read more

Introduction Anyone who writes a web application with ASP.NET Core uses at least one middleware component. But what exactly is middleware a middleware component, and how does it work? And why would I want to write one myself? In this three-part series, I'll show what middleware components are, how they work, and how you can develop one yourself. I'll also highlight testability and give some examples. What is middleware? The term middleware cannot be clearly defined because it is used differently depending on its context. However, in the context of an ASP.NET Core-based web application, the te ..read more

Introduction This post will demonstrate how you can authenticate your Spring Boot featured application against an Azure AD integrated Postgres instance. To accomplish that, we are going to use the Azure Identity Library and create our own DataSource type by extending the HikariDataSource. ? TLDR? You only came here for the code? Fair enough, you'll find it further down at "Putting everything together". It completes previous posts I have published that can be found below. If you are new to this topic, I recommend reading my article to gain some background knowledge. How to manage PostgreSQL ..read more

Introduction There are situations where you want to trace certain SQL statements hitting your Azure Postgres database. This might be the case when you have to comply with government, financial, or ISO certifications and need to provide data to auditors. In other cases you only want temporal tracing to debug certain and otherwise difficult to tackle application problems. Unfortunately, Postgres doesn't provide features like Change Data Capture (CDC) or Change Tracking as MSSQL does. That's why I am going to demonstrate the options available to enable DML statement tracing on an Azure Postgres ..read more

Introduction I found it rather difficult to create a classic availability test by bicep-lang, as it uses an embedded WebTest XML string that doesn't seem to be documented anywhere. The successor of the classic URL ping test produces relief in that respect as it doesn't use the legacy WebTest format anymore. However, even there is a minor obstacle to be aware of. Reasons for creating a web test might be obvious - you'd like to monitor the response time and availability of your HTTP endpoint from different callers spread around the globe. However, in my specific case, I was looking for an alter ..read more