Microsoft Azure Collective
You must join and become a Member of the collective to propose an article.
You must join and become a Member of the collective to propose an article.
Stay up to date
We'll highlight new content in your collectives with a blue activity indicator on navigation items and posts.
Manage preferences
Articles
Browse articles with relevant Microsoft Azure tags
34 articles
-4
votes
180
views
1 minute read
Create file on Azure file storage using postman
Create a file in Azure FileShare using postman.
Pre-Requisite
Azure Storage account with a file share
Role assignment Storage File Data Privileged Contributor scoped to file share.
Get required ...
- 494
1
vote
352
views
1 minute read
How to rename the function in the Azure Function Apps
Sometimes, renaming the function classes is required as that represents the meaningful name of the current version and the functionality of that class.
There is no inbuilt option for renaming the ...
- 101
2
votes
1k
views
1 minute read
FTP authentication has been disabled for this web app. You will not be able to authenticate using these credentials
What should you do when you get this error?
You can simply follow the steps in the below image:
Go to the Configuration of the Azure Web app (or) Azure App Service.
Next, go to the General Settings.
...
- 28k
2
votes
352
views
1 minute read
Inserting a Value into a Dataverse Lookup Column in Using Data Factory
When inserting data into a dataverse sink in data factory, it is worth bearing in mind that lookups may not behave how you expect them to. There are 3 situations involving lookups to be aware of:
You'...
- 361
6
votes
377
views
5 minute read
A Developer's Manual for Azure's AI services.
Introduction: Azure is like a beacon in the vast world of artificial intelligence for developers , looking to integrate cutting-edge AI capabilities into their applications. This article is a ...
- 4,693
3
votes
336
views
1 minute read
Issue while logging in to Azure/Entra portal - AADSTS50020/AADSTS160021/AADSTS16000
Error : When Users are trying to login to Azure portal using their personal Microsoft Account (Outlook, Hotmail..) they are getting AADSTS160021 or AADSTS16000 or AADSTS50020 errors.
Reason: Whenever ...
- 2,258
-1
votes
5k
views
1 minute read
How to update Usage Location for users in Entra ID in Bulk, based on On-Premises Organizational Unit.
Entra ID is a cloud-based identity and access management service that helps users to access the resources they need. Usage location is a property in Entra ID that determines the location where a user ...
4
votes
13k
views
1 minute read
How to Retrieve the Last Sign-In Date Time for All Users in Azure AD Using Microsoft Graph
Microsoft Graph is a powerful tool that allows administrators to manage their Azure AD tenant and automate tasks. One common task is to retrieve the last sign-in date time for all users in Azure AD. ...
0
votes
794
views
2 minute read
Export Entra ID Apps with Expiring Secrets/Certificates and Owners using Microsoft Graph PowerShell
Introduction
The following PowerShell script is designed to export information regarding enterprise applications, focusing on those with expiring secrets and certificates. It prompts the user for ...
2
votes
2k
views
2 minute read
How to Export Microsoft 365 Users and their Licenses to CSV with PowerShell
The Microsoft 365 admin center offers robust support for the Active Users report, providing comprehensive information on currently active Office 365 users and their assigned licenses. In this post, we ...
0
votes
2k
views
1 minute read
How to Use Azure AD Dynamic Groups to Manage Shared Mailboxes in Azure
Introduction
This technical article outlines a comprehensive approach to adding shared mailboxes to Azure AD Dynamic Groups, simplifying the management process for administrators. By leveraging a ...
0
votes
129
views
1 minute read
How to Export Groups targeted by Microsoft Group Lifecycle Policies to CSV
Overview
This technical document outlines the process and functionality of a PowerShell script designed to connect to Microsoft Graph and export groups targeted by lifecycle policies to a CSV file. ...
0
votes
1k
views
1 minute read
How to bulk update MFA Phone Auth Method using PowerShell
Intro
If you want to update Phone Auth method for a Single user, you can use Authentication Methods option on Azure Portal under user section. However, there is NO easy way to update Phone Auth Method ...
4
votes
1k
views
1 minute read
How to get the total size allocated to a Storage account and the for types like Queues, tables, blobs and files.
To determine the total size allocated to a storage account and the consumed size for each of its storage types (queues, tables, blobs, and files), you can use either PowerShell or Kusto Query Language ...
- 2,258
-1
votes
127
views
3 minute read
Configuring A Failover Group For A Production Database In Azure
Overview
All production databases should be configured to replicate to a secondary geo-replica database in a paired Azure location. The primary database (production) and the secondary database will ...
- 31
0
votes
511
views
1 minute read
Azure Synapse Analytics: MagicUsageError - Cannot read notebook Notebook10 - The possible reason is that the notebook doesn't exist
Problem Statement: While running the notebook from another notebook, you will experience the below error message:
MagicUsageError: Cannot read notebook Notebook10 - The possible reason is that the ...
- 12.6k
0
votes
962
views
1 minute read
How to remove duplicate rows of all columns from source data before copying to sink in Azure Data Factory
Requirement/Use Case:
Let's assume we have a requirement to remove duplicate rows (or keep only distinct rows using all columns) from a source file data. For better understanding let's say, it should ...
- 12.6k
-2
votes
2k
views
1 minute read
How to find a latest Azure Data Factory pipeline run ID and pipeline run status using web activity from another pipeline?
To get the pipeline runID and pipeline run status, instead of using Pipeline Runs - Get (which requires a pipeline RunID) we can use Pipeline Runs - Query By Factory REST API (Query pipeline runs in ...
- 12.6k
1
vote
1k
views
1 minute read
How to Automatically Remove Pending Guest Users in Azure Active Directory after 30 Days
Guest users are external users who are invited to access resources in an organization's Azure AD tenant. However, sometimes these guest users can accumulate and remain in the directory for extended ...
-1
votes
178
views
2 minute read
Self-Help Document to handling Errors due to deprecation of Legacy TLS protocols
To improve the security posture of your tenant, and to remain in compliance with industry standards, Microsoft Azure Active Directory (Azure AD) has started deprecating the following Transport Layer ...
1
vote
13k
views
1 minute read
How to fix DeletingCloudOnlyObjectNotAllowed Error received on AD Connect
Microsoft Azure Active Directory Connect (AD Connect) is a tool that synchronizes user accounts and other objects from AD to Azure AD, allowing single sign-on (SSO) to cloud-based applications. ...
0
votes
84
views
1 minute read
Application Registration Endpoints Descriptions
1.OAuth 2.0 authorization endpoint (v2)
https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/authorize
This is a v2 authorization endpoint which is used to identify the user to get authenticated ...
- 639
-1
votes
148
views
6 minute read
Migrating a SQL IaaS Database To Azure SQL Using DMA (Data Migration Assistant)
Overview
This document describes how to migrate a SQL database from an on-premises SQL Server (SQL IaaS) to Azure SQL using the Microsoft DMA utility (Data Migration Assistant). There are other ways ...
- 12.6k
0
votes
213
views
1 minute read
Azure Notification Hub understanding the key metrics telemetry
Azure Notification Hubs enables viewing telemetry data in the Azure portal. Details of the metrics are available on the Notification Hubs Metrics page.
In this article, we cover most frequently asked ...
- 3,115
0
votes
2k
views
1 minute read
Azure Synapse Analytics: How to read an excel data from ADLS gen2 and write Synapse Dedicated SQL Pool
Problem statement: How to read an excel data from ADLS gen2 and write to Synapse dedicated SQL Pool?
This article provides you detailed step by step guide which helps to read data from an excel data ...
- 12.6k
5
votes
200
views
1 minute read
How to get detailed reports on Azure archive Storage Billing
If you want to know the number of blobs archived, total amount of storage consumed for archived content, costs related to the archived content.
Monitoring Archive storage capacity: Monitoring Archive ...
- 2,258
3
votes
213
views
1 minute read
Azure Synapse Analytics: Unable to access Spark APIs through C# and F# and execute C# code in notebooks and through jobs
Problem Statement: When I'm working on a .NET Spark (C#) Notebook in Azure Synapse runtime for Apache spark 3.3. I always get the following error message: Fail to start interpreter. detail: org.apache....
- 12.6k
-1
votes
172
views
7 minute read
Overview Of Azure Traffic Manager And Configuring Priority Based Endpoints
Introduction - Azure Traffic Manager
A DNS-based traffic load balancer is Azure Traffic Manager. This service lets you disperse traffic to your public-facing applications among Azure regions across ...
- 31
1
vote
317
views
13 minute read
Securing Web App Using Private Endpoint And Connecting Through Point To Site VPN with Gateway Transit
Introduction
Azure Webapps - Microsoft built and operates Azure Web Apps, a cloud computing-based platform for hosting websites. It's a platform as a service that lets you create Web apps that operate ...
- 31
-1
votes
130
views
4 minute read
Automate Windows Update With Azure Automation Accounts
Introduction
To manage operating system upgrades for your Windows and Linux virtual machines in Azure, utilize Update Management in Azure Automation. Reporting to Update Management, you can rapidly ...
CommunityBot
- 1
0
votes
600
views
6 minute read
Azure SQL Database Unit Testing with GitHub and tSQLt
Continuous Integration (CI) and Continuous Delivery/Deployment (CD) are a set of principles or methodologies that empower development teams to deliver code faster, more reliably, and with fewer bugs ...
1
vote
724
views
1 minute read
How to parametrize query in Lookup Activity
One of the common requirements is to use one lookup activity to pull a different set of records from an underlining table. You may want to pass the value as a parameter and use the parameter to ...
- 1,764
3
votes
5k
views
1 minute read
How to connect from Azure Databricks to Azure SQL DB using service principal
Register app in Azure , get app ID(principal ID)
Create Service Principal Secret , save
Add service principal to SQL DB + assign permissions
Connect from Databricks to SQL
Code:
jdbcHostname = &...
16
votes
7k
views
3 minute read
Testing and debugging Azure Functions locally with sample events
Azure Functions has built-in functionality to help you debug your Functions locally using the integration from Core tools, VS Code, Visual Studio, and IntelliJ IDEs. You can learn more about this ...
- 169
Members can contribute articles
Simply submit a proposal, get it approved, and publish it.
See how the process works
Simply submit a proposal, get it approved, and publish it.
See how the process works