A recurring challenge I’ve encountered over the years is finding the balance between cost and performance for SQL databases used by front end business teams. Business Users always want more memory and compute, IT Leadership always wants to minimize unnecessary costs, and usage of databases by business end users can be cyclical and unpredictable.
With Azure SQL Database you can programmatically scale the memory and compute up and down, but how do you make sure it happens at the right time? Also, how do you do chargebacks to the teams that needed extra compute for their SQL Server? This video will review a method for adding a Power Apps button that end users can push to turbo-charge an Azure SQL Database for a period of time. IT Leadership can control who pushes the button, the size of the scale-up, the duration of the scale-up, and the Power App will also trigger a record that can be used for chargebacks to prevent abuse of the turbo button. This solution is a simple and easy approach to keep business end users happy, possibly reduce or at least control costs and possibly even your carbon footprint, and store end user activity for easy and customizable translation to chargebacks.
