Microsoft today announced the general availability of Azure Active Directory authentication in Azure SQL Database and Azure SQL Data Warehouse. Azure Active Directory offers an alternative to SQL Authentication allowing centralized identity and group management.
It enables a single sign-on experience using SQL Database and SQL Data Warehouse for federated domains. Azure AD can be used to authenticate against a growing number of Azure and other Microsoft services and helps customers prevent the proliferation of users and passwords.
It supports Azure AD managed and federated domains with user name/password. Password rotation is centralized and triggered automatically from Azure AD. It also supports Integrated Windows Authentication for Azure AD federated domains and clients on domain-joined machines. This enables single sign-on across participating services. Integrated Windows authentication is also supported for remote connections using VPNs.
Learn more about it here.