Hands-On-Lab: Securing Azure SQL Databases

Microsoft Azure SQL Database is a DBaaS (Database as a service) or PaaS (Platform as a Service) offering from Microsoft. Azure SQL Database is largely compatible with on premise SQL Server and supports most of the SQL Server features. Azure SQL Database is optimized for SaaS (Software as a Service) applications. In this lab, we’ll learn different ways to effectively secure Azure SQL Database. In the first exercise, we will learn to apply firewall rules to Azure SQL Databases. In the second exercise, we will learn auditing the Azure SQL Database. In the third exercise, we will learn to implement Dynamic Data Masking in Azure SQL Database. In the fourth exercise, we will learn to implement Row Level Security in Azure SQL Database. In the fifth and final exercise, we will learn to implement Transparent Data Encryption (TDE) in Azure SQL Database.

Exercise 1: Understand and Apply Firewall Rules on Azure SQL Server and Databases
Exercise 2: Auditing Azure SQL Database
Exercise 3: Implement Dynamic Data Masking in Azure SQL Database
Exercise 4: Implementing Row Level Security in Azure SQL Database
Exercise 5: Implementing Transparent Data Encryption in Azure SQL Database.

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.

Get weekly learning resources from SQLMaestros, right in your inbox. Subscribe to our Bulletins.