search
  1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Configuring Azure Application and Data Security

Azure SQL Auditing Demo

Contents

keyboard_tab
Introduction
1
Introduction
PREVIEW1m 33s
Data Classification & Protection
2
Data Classification Part 1
PREVIEW2m 3s
3
How to Protect Your Data
1m 12s
4
AIP Custom Rule
2m 29s
5
Data Classification Part 2
1m 7s
Data Sovereignty
11
Configuring Data Sovereignty
46s
Metrics and Risk
30
Metrics and Risk Tolerance
4m 42s
Summary
31
Summary
3m 21s

The course is part of this learning path

AZ-500 Exam Preparation: Microsoft Azure Security Technologies
course-steps
14certification
1lab-steps
4
play-arrow
Start course
Overview
DifficultyIntermediate
Duration1h
Students452
Ratings
4.7/5
starstarstarstarstar-half

Description

Microsoft Azure offers a wide range of options to secure and protect your data, regardless of the format. Whether you're dealing with documents, SQL databases or big data, there are multiple solutions ranging from authentication to virtual networks.
 
In this course, we will cover the protection of your data from external and internal threats, whether those threats be malicious or accidental. We will see how good design combined with the right configuration can secure your organization's most precious asset: its data.

Learning Objectives

  • Configure security policies to classify, protect, and manage data
  • Configure data retention for storage and databases
  • Set up Azure SQL security features and auditing
  • Learn how to configure storage account security and access
  • Learn how to secure HDInsight clusters
  • Configure Cosmos DB security
  • Configure Data Lake security
  • Learn good design features of an Azure application
  • See how Azure App Services can secure your app
  • See how a governance policy can help formalize security requirements

Intended Audience

  • People preparing for Microsoft’s AZ-500 exam
  • System administrators
  • App developers

Prerequisites

  • Experience with Microsoft Azure
  • Experience with Office 365
  • Basic knowledge of computer security principles
  • Basic networking knowledge

 

Transcript

To turn on Azure SQL auditing, go to Auditing under Security in your server or database blade, switch auditing on and then select the destination to store your audit data. In this case, I'm going to select blob storage. Select a storage account, and then specify the retention period as the number of days. The default retention days is zero, which means unlimited retention. You can click View audit logs to see the audit logs.

About the Author

Hallam Webber

Software Architect
Students1474
Courses4

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

SQLSecurityDatabasesMicrosoft AzureDatabases for AzureSecurity for Azure