Microsoft Azure Storage Kind and Architecture


Azure Storage it is the container for your data that you can save on it the Hot data and Cool data. but what is the best storage types i need it (Blob, File Shares, Tables, Queues)? and what is the Storage Performance and Storage kind (V1, V2,..) and what about the high availability and disaster recovery for my data.based on all of this options you will be able to determined the best azure storage kind for your Business. So before creating any Storage account you should consider the (Location, performance, Kind, replication, access tier)

After reading this post i recommend you to read this post to complete the full picture about how to manage azure storage and for more azure posts check this link by all of my azure posts and articles

IF you are interested to read more articles in the same subject here is below :

Azure Storage Location

When you are creating any resource in Azure Microsoft asking you about the location because not all locations have full azure features. That’s why the location is the the key that will determined on it the features you will have it on the Storage account. e.g. If you selected Australia Center and selected the performance premium storage you will have two kind of storage account only general Purpose V2 and General Purpose V1 but if you selected East US 2 you will have another choices in the storage kind like BlockblobStorage and FileStorage.

Continue reading “Microsoft Azure Storage Kind and Architecture”

Azure Data Explorer Cluster


Azure Data Explorer it is fully Microsoft managed services for data analytics that we can use it for real time analysis for big large of data streaming. With azure data Explorer we will have the availability to ingest massive of data from multiple sources and with azure data explorer we can start to query this massive of record using KQL (Kusto Query Language).

Keep Following this link to check all of my posts/ articles in azure services

Continue reading “Azure Data Explorer Cluster”

How to Export data from Azure SQL DB


Most of the peoples now looking for how to migrate the DB from on-premises to Azure and for this subjects, Microsoft provided us multiple solutions and services can be used for this request and for more information you can check my post (How to Migrate Database to Azure) that l already explained all of these services on it.But the question now can we take a backup from Azure SQL DB and restore it on our local SQL Server on-premises?

Answer yes but not with a normal process we know it backup and restore to know more information about azure backup check my post (Backup Tips on SQL Azure) we will use bacpac file using the Export option in Azure portal

To check my previous posts / articles on azure technology follow up this link

  • How to Export Azure SQL Database.
  • How to check Blob Files on Azure storage account
  • How to Copy the bacpac file.
  • How to import bacpac file into SQL Server
  • Notes and considerations
  • Resources and references
Continue reading “How to Export data from Azure SQL DB”

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”