Exercise 2 – deploying Azure SQL Database elastic pools

If we want to manage and scale multiple databases that have various and unpredictable usage requirements, we will use Azure SQL Database elastic pools.

Pools are suitable for large numbers of databases with specific usage patterns. For a given database, this pattern is characterized by infrequent usage peaks and low average usage. Otherwise, do not place multiple databases under moderate sustained load in the same elastic pool.

Pools simplify management tasks by running scripts in elastic jobs. Elastic jobs eliminate most of the tedious work associated with numerous databases.

Pooled databases generally support the same business continuity features available with single databases.

Azure SQL Database elastic pools are a simple and cost-effective solution. They are a deployment option, which means we purchase Azure compute resources (eDTUs) and storage resources to be shared between all the included databases...