Provisioning a Gen 2 Azure Data Lake


Gen 2 Azure Data Lake It is Microsoft Service designed for big data processing, and it is a combination between azure storage feature and Azure Gen1 Data lake and Microsoft recommend to use GEN2 for X of reasons (Performance, Management, and Security) Azure Gen2 Data Lake is the addition of a hierarchical namespace  , So Gen2 Azure Data Lake is designed for managing and storing a very big large amount of data petabytes. For more information about Gen2 Azure Data Lake Check Microsoft documentation

Continue reading “Provisioning a Gen 2 Azure Data Lake”

Azure Storage Account Monitoring Services


Azure Storage is one of the Azure services and most of the azure services depend on it that’s why we should know how we can monitor the capacity, performance, and so many other things but before listing the Azure Storage account monitoring tools I highly recommend you to take a look into this link that contains a lot of articles related to Azure storage and if you are interested to know more about Azure services such as Azure VM, Data Studio, SQL Database, PowerShell, CLI, Subscription Check this link contain a lot of articles in azure, and if you are preparing for Azure administrator certification check this article

  1. Monitor activity on Azure storage
  2. Azure monitoring classic
  3. Azure Storage insights
  4. Main Azure Monitor
  5. Azure Storage account monitoring Resources

Monitor Activity on Azure Storage

To check the activity executed on Azure storage like data process and actions ingress and Egress you can check it using Activity log and Log Analytics Services from this place you will have full Visibility about what is the process, actions and command executed on Azure storage account For more information I already explained this point in this article (Azure Storage Account and Log Analytics)

Continue reading “Azure Storage Account Monitoring Services”

Azure Cosmos Database Basics


Introduction

Azure Cosmos Database one of the Non-Relational NoSQL Database provided by Microsoft and we have another NoSQL Options in Azure like (Data Lake Storage Gen2, Blob Storage, Redis Cache, HBase in HDInsight), also Azure Cosmos Database Supported multiple API like (Core SQL, Mango DB, Cassandra, Graph, Azure Table) IF you need to learn more about this Point Check this Link Choose the appropriate API for Azure Cosmos DB, Azure Cosmos Database supported Write option in multiple regains in the same Database and the synchronizations tacking care about syncing the data. For more information about Azure Cosmos database, I highly recommend you to look into Microsoft Documentation

  • How to Provision Azure Cosmos DB Account
  • How to Provision Azure Cosmos DB Container
  • Load and Explorer the data into Azure Cosmos DB Container
  • Replication in Azure Cosmos DB
  • Data Consistency in Azure Cosmos DB
  • Cosmos DB and open Source
  • Azure Cosmos Database Resources
Cosmos DB NoSQL

How to Provision Azure Cosmos DB Account

To Create Azure Cosmos Database we need to create First Database account and this like Database instance we can host on it multiple databases, then after this step, we need to create Container ID and this the Database name in this you can find below what is the information required when we need to create Azure Cosmos Database account and for how to do it check below 👇✅ GIF File ✅to know how you can do it and For more information Check this Article

  • Account Name: it is like the instance name in SQL Server
  • Notebooks: Jupyter notebook is an open-source web application that allows you to create and share documents it is like the Azure Data Studio Notebook For more information read this Article
  • Location: The location you need to host on it your Azure Cosmos DB account
  • Account Type: It is something like a definition or categorized, we can consider it like Azure Resource Tag.
  • Geo-Redundancy: Enabling this Option automatically replicates your data to the region geo-paired with your current region you selected it. For more information about the Region geo-paired check this link Azure Regional Pairs IF you don’t enable it during the setup you can enable it after the configuration from the main overview of the Azure Cosmos Account
Enable Geo-Redundancy
  • Multi-region Write: Enable the write option on the Regions you selected it on the geo-redundancy this means If you need to enable the Multi Regions Write option you Should Enable the Geo-Redundancy option with it this option you can enable it after the installation from Replicate Data Globally option If you need to learn more about this option check this Link

Continue reading “Azure Cosmos Database Basics”

Azure SQL Database Automatic Tuning Feature


What is Azure Automatic Tuning Feature

Microsoft Azure SQL Database Automatic tuning one of the monitoring and tuning features we can use it on Azure SQL for more information about other monitoring and tuning services check this Article, Automatic tuning is a fully managed intelligent performance service used for collecting the Azure SQL Database Workload and monitor queries executed on a database continuously, and it is working based on AI Artificial intelligence and ML Machine Learning technologies, with Automatic tuning Azure SQL will automatically capture all of the performance issues and analyze it then will create a new index or drop index  based on the performance case, even one of the capabilities of this services after applying the performance solution it will be under validating based on the AI and ML technologies and if the Azure Automatic tuning found this solution not fixed the issue, it will rollback it automatically, all of this actions will be recorded in the logs to be able to track it

Continue reading “Azure SQL Database Automatic Tuning Feature”

Security Layers on Azure SQL Database


In this article I will explain the options available on Azure we can use it for securing Azure SQL Database, as we know that we have azure deployment model options (Single Database, Elastic Pool, Managed instance, SQL on Azure VM) our article today focused on Azure Paas Database deployment option (Single Database, Elastic Pool, Managed Instance) for more information about Database Deployment option and more details Azure SQL Database deployment models check below articles and if you are interested in more Azure Articles in Database and other services check this Link, also IF you are preparing for Azure AZ-103 so this Post for you check it now.

  1. Azure Database Deployment model options
  2. Azure Single Database Fundamental
  3. Azure SQL Database Elastic Pool Fundamental
  4. Azure SQL Database Managed Instance Fundamental
Azure Database Security Layers
Continue reading “Security Layers on Azure SQL Database”