Azure SQL Database
- Azure Cognitive Search (Azure Search):
- Search as a Service solution for applications to search the data using the Azure Cognitive which provides Standard or AI-enriched Indexes for your application
- Search as a Service solution for applications to search the data using the Azure Cognitive which provides Standard or AI-enriched Indexes for your application
- Intelligent Performance:
- Set of tools provided by Azure to monitor or help in tuning the DB Performance
- Query Performance Insights provide the information about the following with necessary information to tune the performace
- Resource Consuming
- Long Running
- Custom Queries
- SQL Server/SQL Database, Azure also provides Automatic Tuning:
- mysql options:
- Postgres Options
- Set of tools provided by Azure to monitor or help in tuning the DB Performance
- Replication Options
- mysql: Refer Here
- How to create Read Replica
- Data in to syncronize the data from external mysql server in Azure mySQL
- Postgres:
- mysql: Refer Here
- Dynamic Data Masks:
- Power Platform Support is added to SQL Database
SQL Server Managed Instance
- This option creates a SQL Server which is exactly like the SQL Server on-premise.
- SQL Server Managed Instance will be created in the Virtual Network
- During DB Migration, we initally create sql Managed Instances and then try to use sql Databases
Next Topics
- No SQL
- Cache
- Data Warehouses
