- Create Premium Azure SQL database that will contain sample database with Advanced Tread Protection turned on.
- Turn on database operation auditing
- Set up firewall rules in that way that it is possible to connect to the database.
- Connect to the database and execute some queries, change table structure.
- Check if there are any Threads in your database
- Configure Failover option of the server
- Add Elastic pool to the server
- Add two databases to Elastic pool
- Include created databases in Failover strategy
- Please turn on automatic tuning without the possibility to remove Indexes
- Please check the audit trail of your database
- Recover the database from the beginning of the exercise
Azure SQL – ListMichał Jankowski2019-01-23T19:43:22+01:00