Auto Scaling for Azure SQL
Ability to create rules which enable automatically scaling up or down the DTUs on an Azure SQL Database based on usage.
We now have an auto-scaling serverless option. It will continue to be extended based on what we learn from customer usage. Documentation is here:
Peter Bannister commented
A work around is to use a scheduler job to invoke a worker role method to call an SQL for alter DB.
This looses connection when the final scale is done, but we use this for scaling up/down for daily workload, but before people come in / leave.
Works very well for us