We'll get to know the techniques:
1. Estimate value
with Azure Pricing Calculator (Azure SQL
- Database): Before you create an Azure SQL Database with Elastic Pool, you can estimate the cost using the Azure Pricing Calculator. The calculator allows you to adjust various parameters, such as the region, the type of database, the service tier, and more.
2. Choose the region
(RESOURCE REGION):
- The region is the geographic location where the Azure resource will be deployed. It is important to choose the most appropriate region in terms of proximity to users and compliance requirements.
3. Choose the type of Database (ELASTIC POOL, SINGLE DATABASE): You
- need to decide between a single database or using an Elastic Pool to share resources across multiple databases.
4. Choose the Backup service tier
(BACKUP STORAGE TIER, STORAGE REDUNDANCY, LRS, ZRS, RA-GRS):The
backup
- service tier determines the redundancy and availability of the backup data. Options include Local Redundant Storage (LRS), Zone Redundant Storage (ZRS), and Geo-Redundant Storage (RA-GRS).
5. Choose the procurement model (
PURCHASE MODEL, VCORE, DTU): You
- need to select the procurement model, which can be based on vCores (Virtual Cores) or DTUs (Database Transaction Units), depending on performance and scaling needs.
6. Choose the service tier and performance level:
- Within the chosen procurement model, you need to define the service tier and performance level to meet your specific workload requirements.
7. Create Azure SQL Database Elastic Pool
resource (CREATE a RESOURCE, AZURE PORTAL): Using
- the Azure Portal, you can create Azure SQL Database resource with Elastic Pool. During the process, you'll need to provide information such as name, region, purchasing model, and security settings.
8. Define Authentication Method (AUTHENTICATION METHOD, SQL, AZURE AD):
- When configuring SQL Database, you need to choose the authentication method. This can be traditional SQL authentication or integration with Azure Active Directory (Azure AD).
9. Enable SQL Elastic Pool:
- In the case of choosing Elastic Pool, it is necessary to enable this option during the database configuration.
10. Access and create new database in Azure SQL instance (SQL Server Management Studio):
- After the resource is created, you can access the database using SQL Server Management Studio (SSMS) and create new databases as needed.
11. Add existing Azure SQL Database to Elastic Pool (ADD DATABASES):
- If you have opted for Elastic Pool, you can add existing databases to it, allowing for efficient sharing of resources between databases.