Workshop: Defence in Depth - Securing your Data in Azure SQL Database - 1/2

Module 1/2

With more data security regulations coming into force globally, are we ensuring that our end-to-end data security is up to scratch? Security can be applied to our databases at various levels - from the infrastructure through the transport to the actual data itself.

This workshop will focus on Azure SQL Database and the security that can be applied both in the service itself and at the database level to reduce your risk of exposure.

Attendees will see how features such as Data Classification and Auditing can be combined to promote a defense in depth approach and implement an early warning system for unusual or inappropriate activities.

Topics covered

  • Firewalls and Connectivity
  • Authentication
  • Encryption
  • Auditing
  • Data Classification
  • Database Permissions
Requirements
  • Azure Subscription
  • SQL Client tools - Azure Data Studio or SQL Server Management Studio
Audience Requirements
  • Familiarity with deploying Azure services
  • Writing T-SQL queries.