Azure Database Authentication and Auditing

1m 49s

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


  • 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
About the Author
Learning paths

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a  Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard. 

Covered Topics