Using Azure AD to authenticate public clients to SQL Azure
In a recent post from his blog, Premier Developer Consultant Marius Rochon shows how to use Azure AD to authenticate public clients to SQL Azure.
Azure AD enables access authorization to SQL Azure as an alternative to providing username/password information in the connection string: https://azure.microsoft.com/en-us/documentation/articles/sql-database-aad-authentication/. It is somewhat analogous to using Windows Authentication when both the client and the database are on a Windows domain network. It is particularly useful on public (non-confidential) clients where storing secrets is inappropriate and the only alternative would be to have the user use special SQL-only credentials.