Azure Classroom Series – 05/May/2020

Azure SQL Database

1. 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
2. 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
3. Replication Options
   • mysql: Refer Here
     • How to create Read Replica
     • Data in to syncronize the data from external mysql server in Azure mySQL
   • Postgres:
4. Dynamic Data Masks:
5. 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