Description:
Use Azure Active Directory Authentication for authentication with SQL Database to manage credentials in a single place.
Rationale:
Azure Active Directory authentication is a mechanism to connect to Microsoft Azure SQL Database and SQL Data Warehouse by using identities in Azure Active Directory (Azure AD). With Azure AD authentication, identities of database users and other Microsoft services can be managed in one central location. Central ID management provides a single place to manage database users and simplifies permission management.
From Azure Console
Using Azure PowerShell
For each Server, set AD Admin
Set-AzureRmSqlServerActiveDirectoryAdministrator -ResourceGroupName -ServerName -DisplayName ""
From Azure Command Line Interface 2.0
az ad user show --id
For each Server, set AD Admin
az sql server ad-admin create --resource-group --server --display-name --object-id
.