Choosing a Right SQL on Azure
- Refer Here
- Refer Here for SQL Managed instance and Refer Here for creation steps
Azure SQL Database Features
- Auditing: Enabling the auditing will store the events with the change information in Azure Storage account and Cryptographic audit will also a ledger database (hash of current change = current change + previous changes hash)
- Dynamic Data Masking: This gives ability to mask sensitive information to all users expect admins. This is very useful feature where sensitive data can be protected
Azure mySQL and PostgreSQL
- Lets Create an Azure mysql database (free-instance) as done in the class
- Lets Create an Azure postgres database (free-instance) as done in the class
- Next Steps:
- Understanding flexible servers
- options in postgres and mysql vs options in azure sql