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”