Sandro Pereira is a Portugal-based enterprise integration expert and Microsoft MVP, sharing deep technical knowledge on Azure Integration Services, BizTalk Server, cloud and on-prem integration patterns, architecture, and best practices.
27 articles from this blog
Explains why Azure App Service doesn't reflect updated settings until a restart and how to fix it.
Troubleshooting guide for fixing the 'Can't start the background design-time process' error in Azure Logic Apps designer within VS Code.
Explains how to use Named Values in Azure API Management to centralize configuration and avoid hardcoding in policies.
Guide to configuring antivirus exclusions for optimal BizTalk Server performance, based on Microsoft best practices.
Explains why Azure API Management policy changes may not apply, focusing on policy hierarchy, scope conflicts, and common mistakes.
Learn how to use the built-in Trace feature in Azure API Management to debug and troubleshoot API policies step-by-step.
Learn how to reference App Settings (environment variables) directly inside Azure Logic Apps workflows using the @appsetting() expression for better configuration management.
A guide to sending custom metadata as Service Bus message properties from BizTalk Server, covering property schemas, orchestration, and pipeline components.
Explains how to set the correct Content-Type property when sending messages from BizTalk Server to Azure Service Bus, addressing version differences.
Microsoft's new 'Clone to Standard' feature simplifies migrating Azure Logic Apps from Consumption to Standard tiers, reducing manual effort.
Explains a critical 32-character naming limit in Azure Logic Apps Standard that can cause deployment and runtime errors due to Host ID collisions.
Explains how an empty workflow.json file can silently crash an Azure Logic App host and prevent all workflows from loading, with solutions.
Troubleshooting guide for resolving a WinSCP assembly loading error in BizTalk Server's SFTP adapter, including version compatibility and installation steps.
A PowerShell script automates installing the correct WinSCP version for BizTalk Server 2016/2020, eliminating manual version checks and errors.
Azure Logic Apps designer's 'Run with payload' feature currently enforces JSON-only input, preventing manual testing of workflows expecting XML or other content types.
Guide to configuring BizTalk Server's native backup jobs to store database backups directly in Azure Blob Storage using SQL Server's BACKUP TO URL feature.
Explains why being an Azure Storage Account Owner doesn't grant data access and how to assign the correct Storage Data roles.
Troubleshooting guide for fixing the 'browser blocked popup' error when creating a Logic App connection in the Azure Portal.
A custom BizTalk pipeline component that extracts metadata from incoming filenames for routing and tracking, part of an open-source utility pack.
A guide to creating a custom BizTalk send pipeline component for dynamic outbound file naming using XPath and timestamps.
