Integrate Azure SQL with Azure Active Directory

In this short video I'll demonstrate how you can integrate Azure SQL with Azure AD and login to it using AD identities

[Hackenbaker]

Excellent. Very well explained. Thanks a lot.

[kierannevin]

Thank you, what query do you need to use to add Azure Group access to DB instead of specific users?

[afizxxx]

As i understand by this method we can add additional users without creating login. Will try this out. Any limitations that we need to be aware compared to SQL authentication?

[vaibhavwadhai]

Who’s Azure Entra ID suppose to set for SQL server in Azure in PRD environment

[walterwood]

Wouldn't other users need to have their IP addresses added to the firewall, or is there a way around needing an IP address for users?

[srihari]

Actually while adding admin it only show the microsoft account are not allowed