Azure Active Geo-Replication Services

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).

  • What is Azure Geo-Replication
  • What is Geo-Replication Mode
  • How to Configure Active Geo-replication
  • Geo-Replication Permission
  • Benefits from the secondary and Geo-Replication
  • How to Failover to Secondary
  • Checking the replication Status
  • Remove Geo-Replication
  • Conclusion
Active Geo-Replication
Continue reading “Azure Active Geo-Replication Services”

Azure Services for Monitoring and tuning Azure SQL Database

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

  • Query performance insight.
  • Azure SQL Performance Recommendation Services
  • Azure SQL Analytics
  • Azure SQL Automatic Tuning Services
  • Diagnostics settings
  • Learning Resources
Azure SQL Database Monitoring Services
Continue reading “Azure Services for Monitoring and tuning Azure SQL Database”

Microsoft Azure Log Analytics

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.
  • Logs of Azure matrices, alerts.
  • Logs of custom app.
  • Logs of Azure APP insight.
  • Logs of Azure resources diagnostics.

What we can do with these logs

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


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)

Announcement AZ-104: Microsoft Azure Administrator (beta) Released

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.

Schedule Your Exam Now AZ-104: Microsoft Azure Administrator (beta)

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!

Learning Resource

Let’s do it Hope more success for all of you

Azure Subscription Administrator Roles Types

In Azure we have different roles types and as of now they are 3 types

  • Classic subscription administrator roles
  • Azure Active Directory (Azure AD) administrator roles
  • Azure role-based access control (RBAC) roles

Classic subscription administrator roles model

  • Account Administrator: user has full access
  • Server Administrator: user managing the services and assign Co-administrator role to user
  • Co-Administrator: Same as services administrator but with some limitations.

Azure Active Directory (AAD) administrator model Roles

  • Global Administrator: can manage all azure resources
  • Billing Administrator: Can Mange the Billing and Subscriptions
  • User Administrator: can add user inside the directory but outside the directory cannot add them.

Azure Role-Based Access Control (RBAC) model Roles

  • 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.