Well, In this article, we will write a SQL query to change the Azure SQL pricing tier, and along with that, we will also discuss how to change the Azure SQL pricing tier using Azure Portal.
Table of Contents
How to Change Azure SQL Pricing Tier using SQL Query & Azure Portal
Let’s write the SQL query to change the Azure SQL pricing tier and execute that and then we will see if we have done the steps successfully and then we will discuss how to do the same thing using the Azure Portal.
Change Azure SQL Pricing Tier using SQL Query
You can write the SQL query like below and then refer to the example below on the implementation.
ALTER DATABASE [<Your Database Name>] MODIFY(EDITION='< Database edition>' , SERVICE_OBJECTIVE='<TheserviceObjective>')Example
You can run the below query to change the pricing tier of the TsInfo Azure SQL database to Basic from General Purpose.
ALTER DATABASE [TsInfo] MODIFY(EDITION='Standard' , SERVICE_OBJECTIVE='S1') Click on the Query editor (preview) from the left navigation on the SQL database page.
Paste the above query on the Query window –> then click on the Run button to see the query has been executed successfully.
Now, when I have clicked on the Overview tab, I can see the pricing tier of my Azure SQL database has been changed successfully. Refer to the screenshot below.
How to Change The Azure SQL Pricing Tier Using Azure Portal
Follow the below steps
- Log in to the Azure Portal.
- Search for the SQL databases in the Azure Portal and then click on the search result SQL databases.
- Click on the database from the lists.
- On the SQL database page, click on the Compute + storage link from the left navigation under Settings. Select the desired Service tier from the Service tier dropdown as highlighted below, and you are done with the steps.
Change Azure SQL Pricing Tier – Video Tutorial
You may also like following the articles below
Wrapping Up
In this Azure article, we discussed how to change the Azure SQL pricing tier using SQL Query & Azure Portal. Thanks for reading this article !!!
I am Rajkishore, and I am a Microsoft Certified IT Consultant. I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machines, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.
