Set up and use Azure SQL

Question

Hi team,

I need guidance on the steps to get an Azure Microsoft SQL for SQL database and SQL programming.

Especially the requirements, services, and steps to take to achieve this for a database below 500MB.

Any help will be greatly appreciated.

Thank you

Answer 1

These ones may help.

https://learn.microsoft.com/en-us/azure/azure-sql/database/design-first-database-tutorial

https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?tabs=azure-portal

--please don't forget to Accept as answer if the reply is helpful--

--------------------------

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

Answer 2

Hello there,

If you have not used Azure portal yet, please use the $200 free credit offered by Microsoft.

https://azure.microsoft.com/en-in/

Based on your requirements, you need to create two resources inside Azure portal:

1. SQL Server
2. Azure SQL Database.

Below link will be useful:

https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?tabs=azure-portal

There are pricing/performance options available during database set up and you should choose basic S0 tier

Basic offers 5DTU and 10GB of storage, which should be enough for your requirement.

You can upgrade to premium anytime.

Let me know if this helps !

Considering marking this as an answer if you find it helpful !!