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
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
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
For more information about Azure Log Analytics check this post
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)
DB Cloud TECH 