Cosmos DB in Azure Functions V1 and V2

As one of serverless families in Azure, Cosms DB is becoming very popular. In many development scenarios, Cosmos DB actually replaces existing RDBMS because it requires relatively lower cost for maintenance, and is easy to use. Another serverless family, Azure Functions, also provides triggers and bindings for Cosmos DB. However, in Azure Functions V1 and … Continue reading “Cosmos DB in Azure Functions V1 and V2”

Converting UTC to Local Time via Azure Functions and Logic Apps

In many information system development scenarios, including integration scenarios, handling date/time value is always problematic. If your information systems reside in your office or data centre located in your area, that won’t bring about too much trouble. However, if your organisation runs applications in several different regions, which implies different time zones, date/time values when … Continue reading “Converting UTC to Local Time via Azure Functions and Logic Apps”

Testing ARM Templates with Pester

ARM template is a great tool for Azure resources deployment. However, it’s very tricky to use because: It’s a JSON object with massive number of lines, Its JSON structure is quite complex so that it’s not that easy to read at a glance, It’s hard to validate if there is a typo or not, and … Continue reading “Testing ARM Templates with Pester”

Dynamic Access to Azure Functions Keys without KUDU Dependencies

ACKNOWLEDGEMENT: This has been originally posted on Mexia blog I was asked by a previous client whether there would be a way to access to individual function keys, host keys and master key of an Azure Functions app instance without visiting Azure Portal. Because they wanted to use Azure Functions for their CI/CD pipeline with … Continue reading “Dynamic Access to Azure Functions Keys without KUDU Dependencies”

SOAP over Azure API Management, Logic Apps and Functions

ACKNOWLEDGEMENT: This has been originally posted on Mexia blog When we work for a service integration project for a customer’s information systems, not all systems use cutting-edge technologies. Rather, still many information systems use legacy ways to get integration works done. For example, some legacy applications still drop files to a designated folder so that … Continue reading “SOAP over Azure API Management, Logic Apps and Functions”

Securing SAS Token from Azure Logic Apps

ACKNOWLEDGEMENT: This has been originally posted on https://blog.mexia.com.au/securing-sas-token-from-azure-logic-apps When we are using Azure Logic Apps, especially HTTP trigger, their endpoint URLs are overwhelmingly long. Here is an example: View the code on Gist. The purpose of the SAS token used in the Logic Apps is for authentication and authorisation, which is good. But the problem … Continue reading “Securing SAS Token from Azure Logic Apps”

Outbound IP Registration to Azure SQL Using Azure Functions

As Azure SQL Database is PaaS, it has its own firewall settings. Due to its white-listed nature, only traffic from registered IP addresses is allowed to access to the server instance. Of course, there is an option that the server allows all Azure resources to access to the server. However, this is not secure because … Continue reading “Outbound IP Registration to Azure SQL Using Azure Functions”

Azure Functions with IoC Container

I’ve been talking about managing dependencies and unit testing in Azure Functions quite a few times in those articles: Is Your Serverless Application Testable? – Azure Functions Precompiled Azure Functions Revisited Testing Precompiled Azure Functions Debugging Azure Functions in Our Local Box Managing Dependencies in Azure Functions Testing Azure Functions in Emulated Environment with ScriptCs … Continue reading “Azure Functions with IoC Container”