In Azure Datastudio frequently token errors occure, which can not be easly solved. This are the typical connection settings Solution: Clear the token cache and relogin:
Azure AD / Entra ID Login issues with Azure Datastudio Read More »
Json Parsing and processing https://github.com/VBA-tools/VBA-JSON Sample to show how to run REST Requests from excel VBA https://codingislove.com/excel-json/ https://alexwohlbruck.github.io/cat-facts/docs/endpoints/facts.html Other Links GitHub – vba-blocks/vba-blocks: A package manager and build tool for VBA GitHub – VBA-tools/VBA-Web: VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web Adding Items To A
Collection of VBA Links Read More »
There are several ways which are causing the an azure vm to be not accessible any more. This can be a blocking software (e.g. netlimiter) or a misconfigured firewall. To still access the vm we need to run command via powershell. This is how this can be achieved Option 1: Run a powershell command In
Access Azure VM when network is not working Read More »
We want to manage secrets from within a portal developed azure function in c#. In the following we develop a function, which is able to save / update a secret into a keyvault This post was inspired by https://richardswinbank.net/adf/access_google_analytics_with_azure_data_factory Prerequisits We first create a resource group (here keyvaulttest) and within this 3 resources– a keyvault
Keyvault and Azure Functions Read More »
The error message retrieved is this: Regular login did not help. Digging further this shows this error already in the Azure CLI So what required was a relogin, although az still seems to work as normal
Pulumi building authorizer error Read More »
After a while typically we have a lot of not any more required local branches. Therefore an easy way to clean this up Remove ALL local branches that are not on remote Remove ALL local branches that are not on remote AND that are fully merged AND that are not used This is based on
Cleanup local GIT Repos Read More »
In most cases the service connections in Azure DevOps are created in the mode automatic (the Azure DevOps default). Strange enough there is (currently) no option in the UI to set a new credential once it’s expired. The only solution in the UI is to create a new one and delete the old one. The
UPdate Azure Devops Service Connection Secret Read More »
With a customer I have today seen the first time that there is a feature of custom message banners in Azure DevOps. This can not be set via the UI but is a command line only option. Documentation can be found here https://docs.microsoft.com/en-us/azure/devops/organizations/settings/manage-banners
Custom Azure DevOps banner Read More »
Since long it was complicated to get the last login timestamp of all users from azure. With the introduction of MS Graph for Powershell this has changed partly. For this to work it is expected that the Powershell 7.1 is installed and started with pwsh.exe
Get Last Login from Azure Read More »
Beside the normal project file based secrets Azure Function solution have another way of configuring user secrets.The project file contains the following property: The UserSecretsId can be found as directory name with a secrets.json file%appdata%\Microsoft\UserSecrets\e49ded1f-262d-428b-81bb-3fd6941e1261´\secrets.jsonThis contains the typical settings as else be found in local.settings.json: In addition there is also an option to open it
User Secrets in Visual Studio Read More »