Configure Azure SQL Database User Access
Azure SQL allows for Azure Active Directory integration. What does that mean for us? It means having a centralized identity provider for SQL database and server access. No more localized SQL logins!
In this hands-on lab, we integrate a pre-deployed SQL server with Azure AD. We use the Azure Portal to assign an Active Directory admin to the server. We then use SQL Server Data Tools in Visual Studio to assign a test user to the database. Finally, we log into the database using the test user and run a sample query.