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
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
