Azure SQL Serverless, enable manual pause
Azure SQL Serverless, enable manual pause. The portal allows for setting an auto-pause time frame. Please enable the API version of Pause/Resume for Azure SQL Serverless Databases to further enhance cost control. https://docs.microsoft.com/en-us/python/api/azure-mgmt-sql/azure.mgmt.sql.operations.databasesoperations?view=azure-python#pause-resource-group-name--server-name--database-name--custom-headers-none--raw-false--polling-true----operation-config-
Currently , this results in an Error:
CloudError: Azure Error: FeatureDisabledOnSelectedEdition
Message: This feature is not available for the selected database's edition
This would be really useful for testing transient errors. I currently have to wait an hour between each test.
Another great feature would be a way to schedule pauses and resumes. For example, if you know your app is only going to be used during work hours, it would be nice to be able to pause the DB at the end of the day and resume the next morning.