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.
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