How Azure RBAC Work


Azure RBAC is Role-based Access Control it is the gateway for any access (access management of Azure resources) and this service will help you to manage the access and to know who has access and what is kind of access he should take it.

RBAC Diagram
Continue reading “How Azure RBAC Work”

Azure Cosmos DB High Availability and Disaster Recovery Architecture


Part 6 in Azure Cosmos DB architecture Series Keep Learning and Spread your Knowledge if you don’t read the previous parts I highly recommend you to take a look into them:

Continue reading “Azure Cosmos DB High Availability and Disaster Recovery Architecture”

Azure Cosmos DB API Architecture


Again, still we have a lot of information we can spread our knowledge on it for Cosmos DB today I will talk about Cosmos DB API options and How I can choose between them and what is the key factor I should consider it when I choosing the Cosmos DB API. IF you don’t read my last articles in Azure Cosmos DB so here is your road map to learn Cosmos DB:

Continue reading “Azure Cosmos DB API Architecture”

Distributed Tables in Azure Synapse SQL


Azure Synapse is the new Generation of SQL DW (Azure SQL Data Warehouse), that is launched in the past year In November 2019 the First announced for Azure SQL Synapse was in Microsoft Ignite 2019, With Azure Synapse you can bring together cloud data warehousing and big data analytics into a single service platform, Azure Synapse is massively parallel processing (MPP) Engine. Microsoft Added on it many features, With Azure, Synapse Compute is separate from storage, this means you can scale compute independently for the data in your System (APP), With Azure synapse, you can bring the relational Data and Non-relational data together in one place and easily you can do your query and your analytics on a huge amount of information, Azure Synapse build for a massive parallel query for Analytics not for transaction database, Azure Synapse uses Azure Data Lake Storage Gen2 for more information About Azure Data Lake Gen2 Check this Post, Azure Synapse Support (Apache Spark integration, Power BI, Azure ML), Also you can take a look to this demo with Rohan Kumar this demo is part from Microsoft Ignite 2019 Keynote and you can Follow Rohan Posts from here

Continue reading “Distributed Tables in Azure Synapse SQL”

Full Architecture for SQL Backup to Blob Storage in Cloud


One of the tasks that any DBA should know How to take backup to URL or restore a backup from URL and this’s the easiest part very simple steps and command but this is not our main objective, we should understand all of the components how it is working, what is the different options, what is the changes happened before SQL Server 2016 and After SQL Server 2016 to take the maximum benefits from this service or feature here in my article I will try to conclude all of this things as much as I can.

  • Introduction.
  • Benefits from taking backup to URL.
  • What is Azure Storage Blob?
  • What are the Pre-requisites to do SQL backup on the URL?
  • What is the Difference between SAS Token and access key Azure Storage
  • When I Should use SAS Token or access key Azure Storage
  • When the Backup files will be saved as Block Blob or Page Blob
  • How to Generate and configure Access Policy, Access key, and Shared Access Signature
  • Create SQL Server Credential using access key or SHARED ACCESS SIGNATURE
  • Backup to Azure Storage and restore from Azure Storage.
  • Validate the Backup File.
  • Notes and Limitation for SQL backup to URL.
  • References and Resources.
SQL backup to Azure Storage
Continue reading “Full Architecture for SQL Backup to Blob Storage in Cloud”