Skip to main content

Microsoft Azure Collective

Articles

Browse articles with relevant Microsoft Azure tags

34 articles

-4 votes
180 views
1 minute read
How-to guide

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 ...
Tejas Nagchandi's user avatar
1 vote
352 views
1 minute read
How-to guide

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 ...
Berthold's user avatar
  • 101
2 votes
1k views
1 minute read
How-to guide

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. ...
M--'s user avatar
  • 28k
2 votes
352 views
1 minute read
How-to guide

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'...
B.Griffin's user avatar
  • 361
6 votes
377 views
5 minute read
Knowledge article

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 ...
Nandan's user avatar
  • 4,693
3 votes
336 views
1 minute read
Knowledge article

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 ...
SumanthMarigowda-MSFT's user avatar
-1 votes
5k views
1 minute read
How-to guide

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 ...
Harpreet Singh Matharoo's user avatar
4 votes
13k views
1 minute read
How-to guide

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. ...
Harpreet Singh Matharoo's user avatar
0 votes
794 views
2 minute read
How-to guide

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 ...
Harpreet Singh Matharoo's user avatar
2 votes
2k views
2 minute read
Knowledge article

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 ...
Harpreet Singh Matharoo's user avatar
0 votes
2k views
1 minute read
Knowledge article

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 ...
Harpreet Singh Matharoo's user avatar
0 votes
129 views
1 minute read
Knowledge article

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. ...
Harpreet Singh Matharoo's user avatar
0 votes
1k views
1 minute read
Knowledge article

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 ...
Harpreet Singh Matharoo's user avatar
4 votes
1k views
1 minute read
Knowledge article

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 ...
SumanthMarigowda-MSFT's user avatar
-1 votes
127 views
3 minute read
Knowledge article

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 ...
Abdul Basith's user avatar
0 votes
511 views
1 minute read
Knowledge article

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 ...
CHEEKATLAPRADEEP's user avatar
0 votes
962 views
1 minute read
How-to guide

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 ...
CHEEKATLAPRADEEP's user avatar
-2 votes
2k views
1 minute read
How-to guide

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 ...
CHEEKATLAPRADEEP's user avatar
1 vote
1k views
1 minute read
How-to guide

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 ...
Harpreet Singh Matharoo's user avatar
-1 votes
178 views
2 minute read
How-to guide

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 ...
SouravMishra-MSFT's user avatar
1 vote
13k views
1 minute read
Knowledge article

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. ...
Harpreet Singh Matharoo's user avatar
0 votes
84 views
1 minute read
Knowledge article

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 ...
ShwetaM's user avatar
  • 639
-1 votes
148 views
6 minute read
Knowledge article

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 ...
CHEEKATLAPRADEEP's user avatar
0 votes
213 views
1 minute read
Knowledge article

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 ...
AjayKumar's user avatar
  • 3,115
0 votes
2k views
1 minute read
Knowledge article

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 ...
CHEEKATLAPRADEEP's user avatar
5 votes
200 views
1 minute read
Knowledge article

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 ...
SumanthMarigowda-MSFT's user avatar
3 votes
213 views
1 minute read
Knowledge article

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....
CHEEKATLAPRADEEP's user avatar
-1 votes
172 views
7 minute read
Knowledge article

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 ...
Abdul Basith's user avatar
1 vote
317 views
13 minute read
Knowledge article

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 ...
Abdul Basith's user avatar
-1 votes
130 views
4 minute read
Knowledge article

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 ...
Community's user avatar
  • 1
0 votes
600 views
6 minute read
Knowledge article

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 ...
Jetter McTedder's user avatar
1 vote
724 views
1 minute read
How-to guide

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 ...
HimanshuSinha's user avatar
3 votes
5k views
1 minute read
How-to guide

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 = &...
Aleksandras Mandyc's user avatar
16 votes
7k views
3 minute read
How-to guide

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 ...
Eamon O'Reilly's user avatar