[HOWTO] Create an EA Project in a Microsoft Azure SQL Database

This blog post serves as a thought support and describes the necessary steps to create a Sparx Enterprise Architect project in a Microsoft Azure SQL database. Prerequisites Enterprise Architect v14 Microsoft SQL Server Management Studio 18 (for direct download click here) Enterprise Architect Schema Creation Scripts for Microsoft SQL Server EASchema_1220_SQLServer.sql EASchema_1220_SQLServer_Update1.sql Enterprise Architect Initial […]

[HOWTO] Access Azure File Share in PowerShell Script executed by a Scheduled Task

Last week I had to set up an Azure File Share for data transfer purposes. Clients will upload data to the Azure File Share and the data will then be moved from the share to a local drive by a PowerShell script. The PowerShell script gets invoked every 15 minutes by a Scheduled Task. The […]

Manual JWT Validation against Azure Active Directory

For our current WebApi project we decided to implement OAuth2 authentication with Azure Active Directory. As our API needs to support other authentication mechanisms like Basic and Negotiate beside OAuth2 we implemented multiple authentication filters that, where each filter is responsible for a specific authentication mechanism. One of these authentication filters, the BearerAuthenticationFilter, is responsible […]