Mustafa EL-Masry #Azure, Cosmos DB

Azure Cosmos DB Global data distribution Architecture


In my first article in Azure Cosmos DB, we talked about What is Cosmos DB and How to provisions it, then in the Second article we talked about Partitioning Architecture in Azure Cosmos DB. And today we will complete our learning to understand What is global distribution in Azure Cosmos DB? For more information about my Azure articles check this link

When we say global distribution you Should think Automatically in Cosmos DB because it is the most solution in the market provide this feature global distribution, But why global distribution we should be interested in it for couple of reasons unlimited elastic write and read scalability, Yes Cosmos DB provides a solution to read and write option in multiple regions most of the databases solutions provide read scalability but in Azure Cosmos DB we have also write scalability.

Continue reading “Azure Cosmos DB Global data distribution Architecture” →
Mustafa EL-Masry #Azure, Cosmos DB, General topics

Partitioning Architecture in Azure Cosmos DB.


Introduction

In my first article in Cosmos DB, I talked about the basic information about How to provision Cosmos DB, and today we will complete our discussion in How Cosmos DB Partitioning work, and What are the Logical Partition and Physical Partition then in the upcoming posts we will talk more and more about Designing and Architecture Layers for Cosmos DB Such as Consistency levels in Cosmos DB Which Consistency levels are suitable with your APP, What are Cosmos API choices, Disaster Recovery and High Availability in Cosmos DB Keep Following ..

  • Cosmos DB Physical Partition
  • Cosmos DB Logical Partition
  • Cosmos DB Partition Key
  • How to Choose the Right Partition Key
  • Resources
Continue reading “Partitioning Architecture in Azure Cosmos DB.” →
Mustafa EL-Masry #Azure, Azure Database

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” →
Mustafa EL-Masry Big Data

Big Data Storage in Microsoft Azure


Azure storage is a Microsoft solution designed to store your data on it with different models (Blobs, Tables, Queue, File Shares, and Disks) to know the differences, usage, High Availability and the architecture for Azure storage I highly recommend you to check this path you will find a lot of tips and articles About Azure storage subject.

Now let us take a look about storage technology when we talk about Big data, what is the best option for our data and how I can choose the best option, based on what so let us think from architecture and design point of view.

Microsoft provided a variety of options to store your big data on it based on your requirements and based on the data type, in this article we will discuss 4 options that can be used as Azure storage solution for big data.

  • Azure Storage Blobs
  • Azure Data Lake Store
  • Azure Cosmos DB
  • Azure HBase on HDInsight
Continue reading “Big Data Storage in Microsoft Azure” →
Mustafa EL-Masry #Azure, Azure Database, SQL Server 2016

SQL Server Stretch Database to Azure


One of the interesting feature announced in SQL Server 2016 and later to move your cold data to Azure and the data will be accessible from your APP with ZERO development cost no change in the APP level at all and no change on the Query level in SQL Server it is just configuration and implementation for Stretch Database from on-premises to Azure, IF you are DBA and you have tables with big size and you need to reduce it, if you have Cold data and the APP not accessing it frequently, If you need to reduce the backup and restore time at this time this feature for you.

Before starting on the benefits of this feature and How to implement it I highly recommend you to take a look into this page to learn more about Azure SQL https://lnkd.in/edn6nyY/#AzureSQL

  • Benefits from SQL Server Stretch Database
  • How to Configure the SQL Server Stretch Database to Azure
  • Validate the Database Stretch configuration and Data movement
  • How to Disable the Stretch data
  • References
  • Keep Following
  • Cloud Tech Website blog survey
SQL Server Stretch Database
Continue reading “SQL Server Stretch Database to Azure” →