Azure Active Geo-Replication Services is one of the powerful services in Azure used for replicating the SQL database data to another Regions using the same concept of always on data are readable on the another regions and synced on time , With Active Geo-Replication we can configure up to four readable secondary databases in the same or different data center locations (regions).
When we are talking about Performance tuning and Monitoring on Azure SQL Server, we should consider some services provided on azure supporting us in this task
Azure Log Analytics it is Microsoft azure services help us to analyze and assess the logs from many resources for example we can push the logs from below resources to azure log analytics
On-premises servers logs (Windows Server Event Logs, Linux System Log) and this can do by installing agent on the server.
For more information about Azure Log Analytics check this post
Services Depend on Log Analytics
Azure SQL Analytics it is Azure solution for advanced monitoring scenarios that allows you to collect and visualize important data related to the performance of your Azure SQL Database, elastic pools, and managed instances in a single place. It is based on Log Analytics, so it relies on the Log Analytics for more information check Microsoft article
For How to Start on Azure SQL Analytics check this post
Conclusion
Azure Log Analytics advanced services you can use it to dump all of your logs in one place and you can query the log to dive deep on it is very powerful tool from Microsoft azure Azure Log Analytic the simple definition for it , is Microsoft services used for log analysis from multiple sources Example we can configure the diagnostics setting in Azure SQL to push the logs for Log analytics direct or to keep it saved in Azure storage blog container and log analytics services can pull the logs from the storage containers. But How you can filter and search on this massive of logs. Microsoft provide us amazing option inside the log analytics that you can query your data on it and the use of it is very easy , this query depend on KQL Language (Kusto Query)
Congratulation Microsoft announced the beta exam Az-104 Microsoft Azure Administrator and this is the replacement of Az-103 that will be retires on August 31, 2020. This mean still you can take the old exam version till August 31, 2020 when you pass the Exam Az-104 you’ll have earned your Azure Administrator Associate certification and it will be valid for two years.
Remember, the number of spots is limited to the first 300 candidates taking the AZ-104 beta exam on or before May 31, 2020. Please note that the beta exam is not available in Turkey, Pakistan, India, or China.
Advantage of taking beta Exam Microsoft announced that the first 300 people who take the AZ-104 beta exam on or before May 31, 2020, can get 80% off market price!
Owner Role: this meaning the user has full access to all resources and also can delegate role access for others users. It is same like Server administrator role in classic model roles.
Contributor Role: this user can create and manage resources but can’t delegate access to others users like owner role
Reader Role: this role means the users can view azure resources only.
User access administrator: Special account can access and manage all azure resources. And this account should be used by the azure admin only.
Built in Roles: we have more than 70 built in roles
Custom Role: administrator can custom some roles based on his needs using RBAC Services.
DB Cloud TECH 