Book Image

Microsoft Azure Security Technologies Certification and Beyond

By : David Okeyode
Book Image

Microsoft Azure Security Technologies Certification and Beyond

By: David Okeyode

Overview of this book

Exam preparation for the AZ-500 means you’ll need to master all aspects of the Azure cloud platform and know how to implement them. With the help of this book, you'll gain both the knowledge and the practical skills to significantly reduce the attack surface of your Azure workloads and protect your organization from constantly evolving threats to public cloud environments like Azure. While exam preparation is one of its focuses, this book isn't just a comprehensive security guide for those looking to take the Azure Security Engineer certification exam, but also a valuable resource for those interested in securing their Azure infrastructure and keeping up with the latest updates. Complete with hands-on tutorials, projects, and self-assessment questions, this easy-to-follow guide builds a solid foundation of Azure security. You’ll not only learn about security technologies in Azure but also be able to configure and manage them. Moreover, you’ll develop a clear understanding of how to identify different attack vectors and mitigate risks. By the end of this book, you'll be well-versed with implementing multi-layered security to protect identities, networks, hosts, containers, databases, and storage in Azure – and more than ready to tackle the AZ-500.
Table of Contents (19 chapters)
1
Section 1: Implement Identity and Access Security for Azure
7
Section 2: Implement Azure Platform Protection
12
Section 3: Secure Storage, Applications, and Data

Protecting Azure SQL against unauthorized user access

Preventing unauthorized network connections may be the first layer of security for Azure SQL databases but clients still need to be authenticated and authorized before they can gain access. Authentication validates the identity of the client that is requesting access while authorization validates the operations that an identity can perform in a SQL database. Azure SQL Database supports two types of authentication: SQL authentication and Azure Active Directory (Azure AD) authentication.

SQL authentication uses a username and password that is stored in the master database (for server-wide access) or individual databases. When a new SQL logical server is created in Azure, we need to specify a local server admin credential. This credential is referred to as the server admin account. This account can authenticate to any database on that server as the database owner. We can use the initial server admin account to create additional...