Using REST API to pause Azure SQL Data Warehouse – “Bearer authorization error=’invalid_token’, error_description=’The authentication scheme of not supported”

  A customer of mine recently approached me for assistance to help resolve an Authorization error he was receiving , when he was running a custom prepared automation script in C# that would pause and restart the SQL data warehouse. To save costs, you can pause and resume compute resources on-demand.  He had tried the…

2

Automatically Monitor and Change the service tier and performance level (pricing tier) of an Azure SQL database based on the DTU alert using Webhooks, Alerts, Runbooks

  We all know how easy it is to change the service tier of an Azure SQL database as the needs of your application change using the Azure Portal/PowerShell. But what if you want to automate the upgrade and the downgrade of your database? And, what if you have many databases and don’t want to…

9