Access packages in Entra ID Governance are a great way to bundle resources together and then provide a user or multiple users access to these resources or access to resources via security groups. But what happens when a user gets removed from a security group that is part of an access package? The answer to … Read more
Have you ever asked yourself this question after setting up Microsoft Entra ID Lifecycle Workflows and API-driven user provisioning: “What happens if one of my colleagues changes a user attribute in Active Directory (AD), will Entra ID Governance correct it?” The answer to this question is: “No, it won’t”. Or like an IT consultant would … Read more
Automating API-Driven User Provisioning with an Azure SQL Database. This post guides you through setting up an Azure SQL database and, integrating it with your HR system’s API, and then automating user creation and updates in Active Directory using API-driven provisioning to on-premises Active Directory
When you are writing PowerShell scripts to automate various tasks in your everyday life in IT, the hardest part is often how to store the credentials to be used in your code in a secure way. In this blog post I want to show you how you can use an Azure Key Vault to store … Read more
IntroA few days ago Microsoft announced that you will be able to use an Azure Storage Account as SFTP (Secure File Transfer Protocol). This is a feature that a lot of people have been waiting for a long time. Please bear in mind that SFTP on a Storage Account is still in preview and lot … Read more
Microsoft Entra service principals (or App regs.) is nice secure way to connect to Azure SQL Database and then perform queries using PowerShell. This is an ideal alternative to using a local Service Account. The upside to this is that you can authenticate with a secret or with a certificate that you create for yourself … Read more
When you create an Azure SQL database (DB) right off the bat, you will be faced with the need to assign permissions in the database to users or security groups. Normally on an on-premises SQL DB it’s no problem and can be done using the GUI in SSMS. But for an Azure SQL DB, there … Read more
So I was asked today to provide my good friend and colleague Martin Bengtsson with an Azure SQL Database (DB) for project regarding reporting from Config manager using Power BI. First thing first, you cannot just create a SQL DB azure, you need to have a SQL server – As-a-Service. Then you can create all … Read more
I got a call last night from our in-house developer, he had created a website, to be used the following morning, and he needed to get a Custom domain name setup. Here is how to setup a Custom Domain name for your Azure App Service You need the following The first step is to create … Read more
