Azure SQL Managed Instance Authentication Demo

Azure Database Authentication and Auditing covers two topics that bookend Azure database security. We start by looking at the advantages of using Azure Active Directory authentication side-by-side or in place of traditional database logins. Then we see how to implement Azure SQL authentication with Azure AD credentials. Auditing is a database’s security backstop of last resort, enabling administrators to investigate data and server issues. We see how Azure database auditing technology, inherited from SQL Server, has been adapted to the cloud environment and integrated with Azure’s event reporting.

Learning Objectives

• Overview of Azure SQL authentication
• Implement Azure database authentication with Azure AD credentials 
• Overview Azure database auditing
• Implement auditing to an Azure storage account
• Implement auditing to Log Analytics

Intended Audience

• Students working towards the AZ-500: Microsoft Azure Security Technologies exam
• Those wanting to learn how to use Azure Active Directory to authenticate Azure databases and implement database auditing in the Azure ecosystem

Prerequisites

• Students should be familiar with Active Directory concepts such as managed identities and role-based access control
• Familiarity with database concepts, while not essential, will be helpful