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”

Azure SQL Database Tiers Options


Microsoft azure providing multiple options for Azur SQL Database Tier, supported Azure Single Database, Azure Elastic Database, and Azure managed instance before starting for what is the options and the details of it if you need to learn more about Azure SQL provisioning, security, High availability, Performance, …etc. check this link you will find very useful articles covering the most basic topics in Azure SQL Database. ➡️ https://lnkd.in/eABFfrs 💨✅ Today I will start to explain the Purchase mode and database tiers related to Azure SQL Single, Azure SQL Elastic Database and Azure SQL Manged instance.

Azure SQL Database Tiers
  • Azure purchasing models
  • Azure SQL Single Database Tiers Options
  • Azure Single Database Tiers on DTU-Based
  • Azure Single Database Tiers on vCore-Based (GP)
  • Azure Single Database Tiers on vCore-Based (Hyperscale)
  • Azure Single Database Tiers on vCore-Based (Business Critical)
  • Azure Elastic Database Tiers Options
  • Azure Elastic Database Tiers on DTU-Based
  • Azure Elastic Database Tiers on vCore-Based
  • Azure SQL Managed Instance Tiers
  • References
  • Keep Following

Azure purchasing models:

Microsoft Azure supported two Purchase model:

  1. DTU-Based Model: Supported Azure SQL Database only
  2. vCore-Based Model: Supported Azure SQL Database and Managed instance

For more information check this article

Azure purchasing models
Continue reading “Azure SQL Database Tiers Options”

Azure Content Hero and Community Hero


On 15 May 2020 I was received Azure Heros badger Content Hero and today 19 June 2020 I received my second Azure Heros badger Community Hero I am So proud 💪 of my activity and contribution to SQL Server and Azure 👏 Glad to know that my contribution to the community is appreciated. Next step is Azure Mentor Badger and Azure Inclusive Leader Badger Coming Soon https://www.microsoft.com/skills/azureheroes

Content Hero badgers are given out for sharing valuable knowledge at conferences, meetups, or other events. Recipients of this rare award have created original content, sample code, or learning resources and documented and shared their experiences and lessons to help others to build on Azure

Azure Content Hero

Community Hero badgers are given out for contributing materially by organizing meetups or conferences or by sharing content and being an active member of the community

Azure Community Hero

For More Information About My Azure articles and posts check here ➡️ https://lnkd.in/edn6nyY

Keep Following

Recover blob data from azure storage after delete


One of the tasks that an Azure administrator should take care of it when you are managing the data on your organization and saving it on Azure Storage you should know How to keep it up and running and also you should know How to recover it after delete

Today we will see what is the required configuration we should do it to be able to recover your deleted data from Azure storage Microsoft Azure has a feature called SOFT DELETE by using this feature you can configure the Azure storage to keep the data available for recovery within the specified data retention period after the delete operation before starting for explaining the soft delete I highly recommend you to take a look into this list of articles you will find very important information and useful content for How to manage Azure storage Check the Articles from ➡️ here

  • Azure Storage Soft delete options and information
  • How to Enable Soft Delete Configuration on Azure Storage account
  • How to check the deleted data and recover it
  • Keep Following
Recover Blob After Delete
Continue reading “Recover blob data from azure storage after delete”

How to Identify and to Delete unused Blobs in Azure Storage


Case Scenario

As Azure administrator, once of the tasks can be assigned to you is identifying all of the blobs that are not modified for the last 100 days and delete them and we need to automate this task to run automatically on Azure Storage

Introduction

Azure Storage services are one of the most important Azure services that many other services depend on it that’s why we should keep monitoring the size of it to reduce the cost, and of the things that we should take care about it, the blobs that are not used from a long time like our case scenario, that’s why Microsoft Azure provided us something called Azure Blob storage lifecycle

Continue reading “How to Identify and to Delete unused Blobs in Azure Storage”

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”

Azure SQL Database Data Sync Group


Introduction

Azure Data Sync is Microsoft service announced on June 18, 2018, and it is used to sync the data from Azure SQL to another Azure SQL Database or from SQL Server on-premises to Azure SQL Bi-Directional this services used for data sync only and you should not use it as disaster recovery or as migration tool or as read-only replica IF you need to know when you should use azure data sync check this Microsoft article, and if you need to know What is the best option for Azure SQL Database Migration, replication and read-only check this link you will find very useful articles

Azure Data Sync Concept

  • Sync Group: is one of the databases that you want to synchronize
  • Hub Database: is one the synchronize Databases
  • Member database: another database in the data sync synchronization is member databases
  • Synchronization: Happened between Hub Database and member databases this means when you do change on one of the member databases the changes reflected on the other member databases through the Hub database
Continue reading “Azure SQL Database Data Sync Group”

Azure SQL Elastic Database Job Agents Configuration


Introduction

As Database administrator we know that SQL jobs managed by SQL Server agent services, but this concept on SQL Server on-premises, in Microsoft cloud we have another something called Azure SQL Elastic job. Before starting in the definition of it I highly recommend you to understand first what is Azure database deployment model options and How we can configure Azure single database, Azure elastic Pool database and Azure Database Managed Instance Check Below Articles 👇

In this article of today I will cover below points and these points from my view are the basic points still we have many others points in this subject and I will cover it in the upcoming posts, Keep Following me and if you are interested to learn more about Azure SQL Database check this link and if you are interested to prepare for Azure administrator certification AZ-103 or AZ-104 check this link

  • What is the Azure SQL Elastic Job?
  • Differences between Azure SQL Database Jobs and SQL Agent
  • Azure SQL Elastic Database jobs Component
  • Configuration Prerequisites
  • Azure SQL Elastic Job Full Configuration (8 Steps)
  • Review the Elastic Job Configuration
  • References
Continue reading “Azure SQL Elastic Database Job Agents Configuration”

Azure SQL Database Managed Instance Fundamental


SQL Server Managed instance is one of the Azure SQL deployment model options and it is providing 100 % Compatibility with SQL Server on-premises so managed instance it the best migration option when you need to migrate the on-premises database without changing any configuration or losing any features not supported by Azure Single database and Azure SQL Database elastic pool. IF you need to know more information about Azure Single database and Azure elastic pool check this post and if you are interested and preparing for azure administrator AZ-103 certification check this link

  • Azure SQL Manged instance Tips
  • Differences between SQL Server On-Premises and Azure SQL Managed instance
  • Azure Managed instance Service Tier
  • Azure SQL Managed instance Security
  • References
Azure Deployment Model Options
Continue reading “Azure SQL Database Managed Instance Fundamental”

Move Azure Single Database to SQL Elastic Pool


AS I explained before in my previous articles How to provision Azure Single Database and How to Provision Azure SQL Database elastic pool today I will explain How we can move Azure Single Database to New Elastic Pool, For more information about Azure Database Deployment model Check this Post and If you are interested in More Azure Database Articles to check this Link and if you are Preparing for AZ-103 Azure Administrator Certification check this Article, In Microsoft documentation, you will find How to Provision Single Database or Elastic pool Server but you will note find information for How to move Single database to Elastic pool server

Case Scenario

Let us assume that we have 2 Azure Single Database Servers contain 3 Database with different Service Tier and we need to move them to Azure elastic pool

Continue reading “Move Azure Single Database to SQL Elastic Pool”

Azure SQL Database Elastic Pool Fundamental


As we know Azure SQL Database elastic pool is one of the Microsoft Azure database deployment model options to know more about these models check this post and to know more about Azure Single Database check this article and if you interested to check all of the Azure SQL Articles check this link, IF you are Preparing for AZ-103 Azure Administrator Certification check this Article

Azure SQL Deployment Model options
Continue reading “Azure SQL Database Elastic Pool Fundamental”

Azure Single Database Fundamental


AS we now Azure SQL Single database is one from deployment Azure Database models if you need to know more information check this post-Azure Database Deployment model options today I am writing about Fundamental information for Azure Single Database

For More Azure Database Articles Check this Link and If you are Preparing for AZ-103 Azure Administrator Certification check this Article

Create Azure Single Database
  1. The Single Database deployment option creates a single isolated database in Azure SQL Database
  2. Azure Single Database Support DTU-based and Vcore-based Purchased Model
  3. The internal of SQL Database server is hidden from the end-user and all are managed by Microsoft Azure
  4. Azure Single Database has it is own Resources (DTU or V-Core) and this resource will not be shared with other databases in the same single instance. Each Database has dedicated resources.
  5. Single Database Isolated meaning if you created two single databases on the same single database server each Database has dedicated resources and the two databases cannot be communicated together and I think this one is a security feature
  6. This means Azure Single Database is the best option for small workloads with applications connects to one DB.
  7. To Provision Azure SQL Single Database, you need (resource Group, Database name, Server Name, User Name, Password, Location, deployment option either single or elastic pool, Compute Storage and purchase model either DTU-based or vCore-based)
  8. In Azure SQL Single database provisioning you can create new or select existing one from (Resource group and Server name)
  9. In Azure SQL Single database provisioning the (resource Group, Database name, Server Name) Should be a unique name.
Continue reading “Azure Single Database Fundamental”

Azure Database Deployment model options


Azure Database Deployment model options

Azure Administration AZ-103 Exam preparation and learning Resources 2020


Introduction

undefinedMy Name Is Mustafa Elmasry I am Database Consultant MCTS, MCTIP, MCSA, MCSE, MCT for more information about me check this page Today I need to announce that I am Very Excited and Thrilled to have passed my AZ-103 I am now Microsoft Certified: Azure Administrator Associate, That’s how I pass my time during #COVID19 days. From 5 months I passed AZ-900 Microsoft Certified: Azure Fundamentals and I started to prepare for Azure Administrator Exam AZ-103 and I am preparing now for the AZ-104 beta new version. I know that I am Database Engineer and this certification not related directly to my carrier objective but I have believed that before starting to learn any cloud services you should have full visibility about azure infrastructure to be able to manage your Azure services well. During the last 5 months, I started to my study journey for Azure administrator and from the first day, I took a covenant on myself to write down all of the notes, hints, and tricks to be a repository that can help the others for how to prepare for Azure administrator certification in this post you will find all of the resources, notes and even the articles I write it during this journey. I take 3 Courses to prepare for the exam AZ-103. In this article, you will find two documentation The First one contain all of the tips and hints I recorded during my study, and the second one it is full documentation explain most of the features and services in azure administration track. In the end, I will be so happy if you share with me your comment and feedback on this post and documents also if anyone has any issue in SQL Server or Azure SQL don’t hesitate to contact me

Microsoft Certified: Azure Administrator Associate
  • Azure AZ-103 Posts and Articles
  • Microsoft Azure AZ-103 Tips, Hints and Notes 2020
  • Azure Administration AZ-103 Documentation 2020
  • Azure Administration AZ-103 Free Resource
  • Another Important Azure Resource
  • Azure Administration AZ-103 Non-Free Courses
  • Keep Following
Continue reading “Azure Administration AZ-103 Exam preparation and learning Resources 2020”

Microsoft Azure AZ-103 Tips,Hints and Notes Part 3



Today in this Part i will list some important notes related to Deploy and Manage Virtual Machine and the previous parts check it here ➡️ Part 1 Manage Azure Subscription ➡️ Part 2 Implement and Manage Storage

For more information about other Azure posts and articles, all of them are collected in one link ➡️  HERE 

Manage Azure VM Articles

  1. Azure Virtual Machines Types,Series
  2. What is Azure AD Connect Sync Engine
  3. Virtual Machine (VM) Backup and Restore (Vault)
  4. Moving Azure VM Using Recovery Service Vault
  5. Azure VM Backup Soft Delete Security features

Deploy and Manage Virtual Machine Tips

Continue reading “Microsoft Azure AZ-103 Tips,Hints and Notes Part 3”

Microsoft Azure AZ-103 Tips,Hints and Notes Part 2


Today in this Part i will list some important notes related to Implement and Manage Storage to Check Part 1 got to this link Microsoft Azure AZ-103 Tips, Hints and Notes Part 1

For more information about other Azure posts and articles, all of them are collected in one link ➡️  HERE 

keep following for the upcoming parts in Azure Tips, Hints, and Notes series.

Manage Azure Storage Account Articles

  1. Managing and implementing Azure storage
  2. Microsoft Azure Storage Kind and Architecture
  3. Create Storage Account Using PowerShell and CLI Command
  4. How To Monitor Azure Storage Account
  5. Sync your local files with Azure Storage Sync Service
  6. Copy Files to or from Azure Storage using Azcopy
  7. Azure Storage Geo-Replication
  8. Azure Date Transfer Solutions
  9. Microsoft Azure Storage Permission

Implement and Manage Storage Tips

Continue reading “Microsoft Azure AZ-103 Tips,Hints and Notes Part 2”

Microsoft Azure AZ-103 Tips , Hints and Notes Part 1


During my study for AZ-103 Exam, I take some notes and hints from the resources, materials, and videos I study from it and from some exam templates, based on that I need to share this points with you and I hope it will be useful for all of us and the series will be around 4 or 5 parts. The first part related to “Manage Azure Subscription and Resources” in the part of today I will list some important articles I write it in this subject and around 20 points as notes related to the same subject

For more information about other Azure posts and articles, all of them are collected in one link ➡️  HERE

keep following me for the upcoming parts in Azure Tips, Hints, and Notes series.

Manage Azure Subscription

  1. Azure Subscription Administrator Roles Types
  2. Manage Azure Policy Using PowerShell
Continue reading “Microsoft Azure AZ-103 Tips , Hints and Notes Part 1”

Enabling Auto-Failover Group on Azure SQL


Today in Article I will explain How we can enable the Auto Failover group on Azure SQL and what is different between Auto-Failover Group and Active Geo-Replication in Azure SQL. Before starting in How to implement the Azure SQL Auto Failover Group I recommend you to take a look on this ➡️ POST to understand How you can configure  Active Geo-Replication on Azure SQL and for more Azure SQL articles check this ➡️ LINK  and for more other Azure Posts and articles check this ➡️ LINK for all of my azure articles

  • Active Geo-Replication VS Failover Group
  • How to enable Auto-Failover Group on Azure Single SQL Server
  • Check the Failover Group Configuration and Connections
  • Test the Failover
  • Conclusion
  • Resources
  • Follow Me on Social Accounts
Continue reading “Enabling Auto-Failover Group on Azure SQL”

KQL in Azure Data Studio April 2020 Release


As I explained before that #Azure Data Studio is a magic tool, with Azure data Studio you can write all of your query language (T-SQL, #PowerShell, #CLI) you can manage your On-premises SQL Server and your Azure #sqlserver and today with the new updates April 2020 release you can write your #KQL (#Kusto) Query With Azure notebook It allows you to connect, query and explore Azure Data Explorer, ApplicationInsights and LogAnalytic

For more information about How to Manage Azure with PowerShell Command from Azure Data Studio check this Post ➡️ https://mostafaelmasry.com/2020/04/22/how-to-manage-azure-with-powershell-command-from-azure-data-studio/

For More Information About KQL Query Check these two Courses ➡️ https://www.pluralsight.com/courses/microsoft-azure-data-exploring & https://www.pluralsight.com/courses/kusto-query-language-kql-from-scratch

or you can download Kusto Explorer client tool from here ➡️ https://aka.ms/Kusto.Explorer

To learn more about the new Features in Azure data Studio released in April 2020 Check this post ➡️ https://cloudblogs.microsoft.com/sqlserver/2020/04/28/the-april-2020-release-of-azure-data-studio-is-now-available/

📊MY Azure Posts Road-Map💯

👉All of my Azure Posts ➡️ https://lnkd.in/edn6nyY/#AllAzurePosts 💨✅
👉 Azure Data Studio Posts ➡️ https://lnkd.in/edn6nyY/#AzureDataStudioPosts 💨✅
👉 Azure Storage Account Posts ➡️ https://lnkd.in/edn6nyY/#AzureStorageAccount 💨✅
👉 Azure VM Posts ➡️ https://lnkd.in/edn6nyY/#AzureVM 💨✅
👉 Azure SQL Database Posts ➡️ https://lnkd.in/edn6nyY/#AzureSQL 💨✅
👉 Azure PowerShell and Cloud Shell Posts ➡️ https://lnkd.in/edn6nyY/#AzurePowerShell 💨✅
👉 Azure Subscription Posts ➡️ https://lnkd.in/edn6nyY/#AzureSubscription 💨✅
👉 Azure Errors and issues Posts ➡️ https://lnkd.in/edn6nyY/#AzureErrors 💨✅
👉 Other Azure Posts for other Services ➡️ https://lnkd.in/edn6nyY/#Others 💨✅

Keep Following

Microsoft Azure Storage Permission


Before starting for How we can access the storage account using an access key or SAS and what is the difference between them I highly recommend you to take a look about this articles series for how to manage azure storage account using Azure portal, PowerShell and Cloud Shell ➡️ https://lnkd.in/edn6nyY/#AzureStorageAccount 💨✅

  • Storage account Firewall
  • Access Key
  • Shared Access Signature
  • Azure Blob Data Permissions Deep Dive (360 in 360) Video by John Savill
  • Database Cloud Tech Azure Posts Road-Map
  • Follow Up Database Cloud Tech on LinkedIn , Facebook and twitter
Continue reading “Microsoft Azure Storage Permission”

Microsoft Azure Events for Upcoming 30 Days


Microsoft Event for Upcoming 30 days if you are looking for more events in other fields check Microsoft Event Site https://events.microsoft.com/

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Azure SQL

Azure DP-200 and DP-201

Azure Data AI

Keep Following Me

How to Manage Azure with PowerShell Command from Azure Data Studio


All of us know Azure Data Studio is new Microsoft tool like SQL Server Management Studio but with highly advanced features like Azure Data Studio Notebook, one of the features that you can PowerShell extension on Azure data Studio to connect to your Azure Portal and do your homework easily, Azure data studio PowerShell extension supported PowerShell and Cloud Shell (CLI) AZ Command, did you imagine this powerful tool from one place you can write your T-SQL, PowerShell, and CLI and you can manage your SQL Server on Premises and your Azure SQL and the other Azure services, all of these services and these languages from one place Using Microsoft Azure data Studio 🚀💪😱

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Managing Azure With PowerShell From Azure Data Studio

Connect to Azure with PowerShell from Azure Data Studio

Continue reading “How to Manage Azure with PowerShell Command from Azure Data Studio”

Azure Date Transfer Solutions


Microsoft Azure provided verity of options for how to transfer your data from or to your storage or from on-premises to Azure or from Azure to on-premises many of options and I explained before some of them like Azcopy check this  ➡  post , Azure Data Migration Services (DMS) Check this  ➡  Post  , Azure Storage Explorer Check this ➡  Post.

And to know more about this this solution easily you open your storage account and in the left side you will find Data Transfer if you click on it Microsoft give you service to search on it about the most optimal offline or online data transfer based on your need and this search depend on 3 keys (Network Speed, Data Size, Transfer Frequency option).

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

So before doing any data transfer check this service to Search from among the common Azure data transfer solutions to select the best option for your data. For more information about Azure solution for data transfer check ➡  Microsoft article.

Continue reading “Azure Date Transfer Solutions”

Azure Storage Geo-Replication


I explained before How we can use the Geo-replication on Azure SQL and how is very helpful for SQL replication and failover for more information about this subject check this ➡ Article Today we will use the same services for replicated the azure storage data.

  • Previous articles in azure Storage services
  • What is Geo-Replication
  • Azure Storage replication Types
  • How to Implement Geo-Replication on Azure Storage

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Previous articles in azure Storage services

Continue reading “Azure Storage Geo-Replication”

Azure VM Backup Soft Delete Security features


I talked before about How we can implement backup on Azure VM using Recovery services vault and we mentioned that recovery services vault can be used for two purpose backup and site recovery but today we will take in one of the azure security feature Soft Delete but before this point, if you need to know how you can implement backup on VM using recovery services vault check this ➡ article and if you need to know how you can implement the site recovery using azure backup vault check this ➡ article.

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Soft Delete Life Cycle on Azure Recovery Services vault
Continue reading “Azure VM Backup Soft Delete Security features”

Copy Files to or from Azure Storage using Azcopy


Before starting on How to move files hosted on the azure container using Azcopy command line I highly recommend you to read below articles to know more information about Azure Storage types, features, how to create it, storage replication types, azure storage explorer and How to monitor your azure storage

  • Azure Storage information
  • What is Azcopy
  • Prerequisites
  • Azcopy command details
  • Check File using Azure Storage Explorer

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Azure Storage information

Continue reading “Copy Files to or from Azure Storage using Azcopy”

Create Deadlock Alert on Microsoft Azure SQL


Deadlock all of us know the meaning of it and how to manage it on SQL Server on-premises and for how to get alert by it normally we are using Database Mail to generate alert from SQL Server but in Azure, the situation is different because there is no Database Mail in Azure there are services called “Azure Monitor” centralized services for managing all of the alerts on all of the Azure resources and this in of the difference between SQL on Azure and SQL on-premises. From this service we can manage our alerts with defining what is the action we need it (Send Email, Execute Function, Call Services, Send SMS ..etc.), You can access the Monitoring Services from this ➡ link or simply by searching azure portal by (Monitor).

  • Azure Alert Component
  • How to create Deadlocks Alert
  • List by alerts created on Azure
  • Alert Dashboard
  • How to Get the deadlock reports Using Azure Matrices
  • How to check Deadlock using SQL Server Script
  • Other Articles For How to Manage Azure SQL Database

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Azure Alert Component

  • Resource: The Azure Resource you need to apply for this Alert role on It and it can be done on the azure subscription itself like alert on cost and budget of the subscription.
  • Condition: it is the logic of the alert what you need to monitor exactly and when
  • Action Group: the action you need to do it when the alert fire on the condition you configure it
  • Matrices: It is like dashboard and reports you can configure it to get some statistics on time and you can build alert on it
  • ALERT DETAILS: alert name and alert description and severity for this alert from (0) to (4)
Continue reading “Create Deadlock Alert on Microsoft Azure SQL”

The subscription is not registered to Microsoft.insights resource provider


When I am creating Alert from Azure Monitor services I found below massage restricted me to complete the process of creating alert after few search on Microsoft document I found that I need to register for the Microsoft.insights provider to my subscription and they we can do it from azure portal or using PowerShell.

Creation of alert rules will fail, since the subscription is not registered to Microsoft.insights resource provider

Fix the issue using PowerShell command

Register-AzureRmResourceProvider –ProviderNamespace Microsoft.Insights

Fix the issue from Azure Portal

Under subscription in the left side select Resource provider and search about Microsoft.insights then do register for it easily

Keep Following Me

Manage Azure Policy Using PowerShell


Azure Policy is a Microsoft service in Azure used for creating and managing policies , assignments and definition and it is used to force some roles on some resources in case of some actions.

  • Policy definition: is the conditions of the policy
  • Policy assignment: in the part we can define which resource or services you need to apply this policy on it , add in your note that the policy assignment by default inherited so for example if you applied Policy on Subscription it will be inherited on all of the resource under this subscription
  • Policy parameters: it will give you the availability to custom your policy
  • Azure initiative Policy: it the like Azure policy but we can use when you need to do group of policy in one step and it is containing the 3 parts (initiative definition, initiative assignment, initiative parameters) “Policy Combo
Azure Policy

Today we will create Azure policy to enforce any new resource for using tag let’s go to see how we can create this policy using PowerShell Command.

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

  • Create Resource Group “IF you need it is not mandatory”
  • Save the Resource Group in PowerShell variable ($resource)
  • Call the Resource Group ID
  • Get the Azure Policy definition of required to assign tag for any new resource will be created
  • Save the Azure policy information into PowerShell variable ($Policy)
  • Create Azure Policy
Continue reading “Manage Azure Policy Using PowerShell”

How to Solve Error Azure Recovery Services vault cannot be deleted


Today when I am doing cleaning for the azure resources that I don’t need it to reduce the cost, I tried to remove Resource Group contain Recovery Service vault Services but it gives me error

Failed to delete resource group prodresouorcegroup: Deletion of resource group ‘prodresouorcegroup’ failed as resources with identifiers ‘Microsoft.RecoveryServices/vaults/elmasryvmbackupvault1’ could not be deleted

Then when I tried to remove the recovery services vault it gives me another error

Vault cannot be deleted as there are existing resources within the vault. Please ensure there are no backup items, protected servers or backup management servers associated with this vault. Unregister the following containers associated with this vault before proceeding for deletion. For instructions, see https://aka.ms/AB-AA4ecq5

After some Google Search I know the correct steps for deleting  Azure Recovery services vault

Continue reading “How to Solve Error Azure Recovery Services vault cannot be deleted”

Sync your local files with Azure Storage Sync Service


We talked before about Storage and the types of storage and how to manage the storage but today we will talk about the file share that’s one of the types of azure storage and the questions now after creating the file share how I can sync my files from my V-Center VM to Azure File share, Microsoft provided us services called Azure file sync so to let us know how we can configure it and what is the prerequisites we should configure it on the V-Center VM

For more information about Azure Storage check below posts and if you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Managing and implementing Azure storage
Microsoft Azure Storage Kind and Architecture
Create Storage Account Using PowerShell and CLI Command
How To Monitor Azure Storage Account
  • Create Azure File Share.
  • Files Assessment on local V-Center VM.
  • Install Azure File Sync on Azure.
  • Install Azure File Sync on local V-Center VM
  • Registration Verification
  • Create Cloud Sync endpoint and server endpoint
Sync your local files with Azure Storage Sync Service
Continue reading “Sync your local files with Azure Storage Sync Service”

Moving Azure VM Using Recovery Service Vault


As I explained before on my last article [Virtual Machine (VM) Backup and Restore (Vault)] that we can use the Azure recovery services vault for taking backup and doing a restore from azure VM using recovery services vault also the same services can be used to migrate your local VM from V-center to Azure using (Recovery services vault site recovery) and in this post, we will explain how to use this services recovery vault to Move VM between two rejoin and to do failover easily for the VM. Let’s go for technical steps

To know more information about azure services check my (Latest Microsoft Azure Articles and Posts)

  • How to build replication on VM
  • How to do Test Failover
  • How to do Real Failover
VM Replication From East US2 to East US
Continue reading “Moving Azure VM Using Recovery Service Vault”

Virtual Machine (VM) Backup and Restore (Vault)


Introduction

Azure Recovery service vault It is azure built in services doesn’t required any infrastructure preparation and it is supported multiple types of backup (VM , File , Disk and SQL Database) it is one of the built options in the VM , so easily when you open Azure virtual machines and select your VM you will find in the left side Backup from this point and this place you can start to manage your backup and restore process as well you can keep monitoring your backup jobs and restore jobs let us go for demo and how to do VM backup and restore it and what is the restore types supported.

  • Azure backup Process.
  • Azure backup hints
  • How to start to take backup from VM
  • Azure Recovery Services vault
  • Azure Restore Options
  • Azure Restore Hints
  • How to do VM restore from Azure recovery services vault

To know more information about azure services check my (Latest Microsoft Azure Articles and Posts)

Azure backup Process:

How the backup process will start and what is the sequences that running behind the seances when I asked azure backup services to take backup from my MV.

  • You need to install Azure backup recovery vault Services
  • Define backup policy then the backup extension will be installed.
  • After this the backup services will start to discovery and analysis your VM disks, files, data and size.
  • Then It will start to create Snapshot from your data. That’s why the backup process sometimes take time but this time will not be more than 24 Hours.
  • After the snapshot completed the Azure backup extension will transfer the snapshot to azure backup recovery vault.

Azure backup hints

Continue reading “Virtual Machine (VM) Backup and Restore (Vault)”

Moving Database Files on SQL Server Always On


I think all of us know how to move files for SQL Server databases from disk to another disk but today I will explain how we can do it on SQL Server always on to reduce the downtime and taking new backup to return the database to always-on again. Let us start on the technical steps.

  • Preparations Steps
  • Check the current DB Files locations
  • Check Always on Health Status
  • Disable all backup jobs on Primary and secondary servers
  • Suspend the data movement on Secondary server
  • Remove Database from Primary server
  • Update DB files by new disk location on secondary server
  • Stop SQL Server instance on Secondary server
  • Move (CUT) DB Files from old location to new Location (Past)
  • Start the SQL Server instance again
  • Verify the DB File Location Using T-SQL on the post
  • Join the DB to availability group from Primary server
  • Check SQL Server always on Health Status Using T-SQL on the post
  • Enable the SQL Server Jobs\
  • Failover the SQL Server for Primary (X) to Secondary Server (Y) and do the same steps on (X)

Let’s Start The Technical Demo

Continue reading “Moving Database Files on SQL Server Always On”

Moving Microsoft Azure Resources Using PowerShell


One of the common tasks as an azure administrator you should know it when you deployed azure resource on resource group related for testing as example and you need to move it to new resource group or resource group of production we can do this activity with one PowerShell command and if you are not interested in PowerShell don’t worry you can do also from Azure Portal.

Alert 💣:Moving Azure resource will create new resource id this meaning if you any subscription or APP referencing this resource-id it will break be caution ✍ (Read More, Document the Steps, Test the Steps ) then do your implementation

To know more information about azure services check my (Latest Microsoft Azure Articles and Posts)

Moving Azure Resource Using Azure Portal

Open Microsoft Azure Portal select the source resource group and from the top, you have two option (Move or Change) both you will direct you to move your resource by the selecting the resource you need to move it then the new resource group (Destination) during this steps you can create new resource group easily.

Moving Azure Resource using PowerShell

Continue reading “Moving Microsoft Azure Resources Using PowerShell”

How to hide SQL databases from users using SSMS


I know the First question you will ask it  “Why we need to hidden it IF the user doesn’t have access on it and he can’t do any operation on this DB 🤔” Simple answer “Business needs & Business Case & Management Request” Whatever the answer but this is the request from management So let us see How we can do it using two solutions.

First Solution hide the DB using Permissions

Before starting on the solution, I need to highlight important point “to implement this solution the user will take ownership of the DB” and this will break the security role. To hide the DB, we need two steps after it the user when he will log in to SQL Server management studio, he will see only this database:

  • Deny or remove the permission of View on databases from the Public User on the instance level.

At this time no one will able to see any databases on the SQL Server management studio except the admins only this means you should grant this permission for specific users that you need them to view all databases “It is just view Permission, accessing the DB is another permission”.

  • Change the DB Authorization by the user name you need him to view this DB only or you can do this step on two or three or more databases at this time this user when he login to SQL Server Management studio he will view these databases only the other databases will be hidden.

Technical deployment scripts

Continue reading “How to hide SQL databases from users using SSMS”

Azure Storage Account and Log Analytics


Monitoring Azure Storage activities depend on Azure activity log services and to access this activity log we have three options and to know more information about Azure Storage account check below posts and for all of my posts in azure check this link (Latest Microsoft Azure Articles and Posts)

Activity log: it is like the event viewer in windows when you open the storage account you will find in the left side activity log if you open it you will find all of the activities you do it and when and who do it

Activity log on azure storage account

Log analytics: Search about log analytics on the Azure portal search and create new work space then on the left you will find container call “Work space data source” under it you will find Azure activity log if you click on it you will find your azure subscription just only connect the subscription to the log analytics then Go for the left side again and select Log and from here you can query your activity log using KQL query (Kusto Query Language). Look at this post to know more information about (Microsoft Azure Log Analytics).

Microsoft azure Log Analytics

Log Analytics on Activity log: we can add Log analytics as a solution on the activity log on Azure storage account to do that ( You Should Create first step 2 Log Analytics workspace > open Storage account > in the left side select activity log > on the top right side click on log > add > Select the log analytics Workspace you created it > then save > the refresh) IF you return to Log Analytics workspace in the left side select solution you will find the solution you created it.

Keep Following Me

Create Storage Account Using PowerShell and CLI Command


before Creating the Storage account i recommend to read these two articles (Microsoft Azure Storage Kind and Architecture & Managing and implementing Azure storage) first to know more information about the choices and options for Storage account. For more information about the all of the previous Posts and Articles related to Microsoft Azure services (Latest Microsoft Azure Articles and Posts)

IF you are interested to read more articles in the same subject here is below :

To create Storage account we should know some information needed for create process

  • Storage account Name: The name should be unique.
  • Resource Group: Storage account services should be created under resource group and it is recommended both to be in the same location for Example “East US”.
  • Location: Location of the Storage account it deepened on it the features of the storage account because not all features supported on all locations.
  • Account Kind: We have 5 Types (V1, V2, BlobStorage, BlockBlobStorage, FileStorge)
  • Storage Replication: Microsoft provide 6 types of replications depended on the locations and the storage account kind (LRS, ZRS, GRS, RA-GRS, GZRS, RA-GZRS)
Continue reading “Create Storage Account Using PowerShell and CLI Command”

Microsoft Azure Storage Kind and Architecture


Azure Storage it is the container for your data that you can save on it the Hot data and Cool data. but what is the best storage types i need it (Blob, File Shares, Tables, Queues)? and what is the Storage Performance and Storage kind (V1, V2,..) and what about the high availability and disaster recovery for my data.based on all of this options you will be able to determined the best azure storage kind for your Business. So before creating any Storage account you should consider the (Location, performance, Kind, replication, access tier)

After reading this post i recommend you to read this post to complete the full picture about how to manage azure storage and for more azure posts check this link by all of my azure posts and articles

IF you are interested to read more articles in the same subject here is below :

Azure Storage Location

When you are creating any resource in Azure Microsoft asking you about the location because not all locations have full azure features. That’s why the location is the the key that will determined on it the features you will have it on the Storage account. e.g. If you selected Australia Center and selected the performance premium storage you will have two kind of storage account only general Purpose V2 and General Purpose V1 but if you selected East US 2 you will have another choices in the storage kind like BlockblobStorage and FileStorage.

Continue reading “Microsoft Azure Storage Kind and Architecture”

Azure Data Explorer Cluster


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

Continue reading “Azure Data Explorer Cluster”

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”

Microsoft Azure Log Analytics


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

  • On-premises servers logs (Windows Server Event Logs, Linux System Log) and this can do by installing agent on the server.
  • Logs of Azure matrices, alerts.
  • Logs of custom app.
  • Logs of Azure APP insight.
  • Logs of Azure resources diagnostics.

What we can do with these logs

For more information about Azure Log Analytics check this post

Services Depend on Log Analytics

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

Conclusion

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)

Announcement AZ-104: Microsoft Azure Administrator (beta) Released


Congratulation Microsoft announced the beta exam Az-104 Microsoft Azure Administrator and this is the replacement of Az-103 that will be retires on August 31, 2020. This mean still you can take the old exam version till August 31, 2020 when you pass the Exam Az-104 you’ll have earned your Azure Administrator Associate certification and it will be valid for two years.

Remember, the number of spots is limited to the first 300 candidates taking the AZ-104 beta exam on or before May 31, 2020. Please note that the beta exam is not available in Turkey, Pakistan, India, or China.

Schedule Your Exam Now AZ-104: Microsoft Azure Administrator (beta)

Advantage of taking beta Exam Microsoft announced that the first 300 people who take the AZ-104 beta exam on or before May 31, 2020, can get 80% off market price!

Learning Resource

Let’s do it Hope more success for all of you

Latest Microsoft Azure Articles and Posts


In this post you will find all of the posts and articles related to Microsoft azure services keep following me

Azure Posts Road-Map

  1. All of my Azure Posts
  2. Az-103 Exam Certification Tips, Hints and Notes
  3. Azure Data Studio Posts
  4. Azure Storage Account Posts
  5. Azure VM Posts
  6. Azure SQL Database Posts
  7. Azure NOSQL Posts
  8. Azure Data Lake
  9. Azure PowerShell and Cloud Shell Posts
  10. Azure Subscription Posts
  11. Azure Errors and issues Posts
  12. Other Azure Posts for other Services
Microsoft Azure Services

Az-103 Exam Certification Tips, Hints and Notes

  1. Microsoft Azure AZ-103 Tips, Hints and Notes Part 1
  2. Microsoft Azure AZ-103 Tips,Hints and Notes Part 2
  3. Microsoft Azure AZ-103 Tips,Hints and Notes Part 3
  4. Azure Administration AZ-103 Exam preparation and learning Resources 2020

Azure Data Studio

  1. How to Manage Azure with PowerShell Command from Azure Data Studio
  2. KQL in Azure Data Studio April 2020 Release

Manage Azure Storage Account

  1. Managing and implementing Azure storage
  2. Microsoft Azure Storage Kind and Architecture
  3. Create Storage Account Using PowerShell and CLI Command
  4. Azure Storage Account and Log Analytics
  5. Azure Storage Account Monitoring Services
  6. Sync your local files with Azure Storage Sync Service
  7. Copy Files to or from Azure Storage using Azcopy
  8. Azure Storage Geo-Replication
  9. Azure Date Transfer Solutions
  10. Microsoft Azure Storage Permission
  11. How to Identify and to Delete unused Blobs in Azure Storage
  12. Recover blob data from azure storage after delete

Manage Azure VM

  1. Azure Virtual Machines Types,Series
  2. What is Azure AD Connect Sync Engine
  3. Virtual Machine (VM) Backup and Restore (Vault)
  4. Moving Azure VM Using Recovery Service Vault
  5. Azure VM Backup Soft Delete Security features

Manage Azure SQL Database

  1. Azure SQL Database Architecture
  2. Azure Database Deployment model options
  3. Azure Single Database Fundamental
  4. Azure SQL Database Elastic Pool Fundamental
  5. Azure SQL Database Managed Instance Fundamental
  6. Move Azure Single Database to SQL Elastic Pool
  7. How to Migrate Database to Azure
  8. Azure Active Geo-Replication Services
  9. Backup Tips on SQL Azure
  10. How to Export data from Azure SQL DB
  11. Azure Services for Monitoring and tuning Azure SQL Database
  12. Create Deadlock Alert on Microsoft Azure SQL
  13. Enabling Auto-Failover Group on Azure SQL
  14. Azure SQL Elastic Database Job Agents Configuration
  15. Azure SQL Database Data Sync Group
  16. Security Layers on Azure SQL Database
  17. Azure SQL Database Automatic Tuning Feature
  18. Azure SQL Database Tiers Options

Azure NoSQL

  1. Azure Cosmos Database Basics

Azure Data lake

  1. Provisioning a Gen 2 Azure Data Lake

Manage Azure using PowerShell and CLI

  1. How to manage Azure using Windows PowerShell
  2. Moving Microsoft Azure Resources Using PowerShell
  3. Create Storage Account Using PowerShell and CLI Command
  4. Manage Azure Policy Using PowerShell

Manage Azure Subscription

  1. Azure Subscription Administrator Roles Types
  2. Manage Azure Policy Using PowerShell

Manage Azure Services

  1. Azure Log Analytics
  2. Azure Data Explorer Cluster

Azure Errors and Issues

  1. How to Solve Error Azure Recovery Services vault cannot be deleted
  2. The subscription is not registered to Microsoft.insights resource provider

All of the Posts Order by the Latest Published

  1. Azure SQL Database Tiers Options
  2. Recover blob data from azure storage after delete
  3. How to Identify and to Delete unused Blobs in Azure Storage
  4. Provisioning a Gen 2 Azure Data Lake
  5. Azure Storage Account Monitoring Services
  6. Azure Cosmos Database Basics
  7. Azure SQL Database Automatic Tuning Feature
  8. Security Layers on Azure SQL Database
  9. Azure SQL Database Data Sync Group
  10. Azure SQL Elastic Database Job Agents Configuration
  11. Azure SQL Database Managed Instance Fundamental
  12. Move Azure Single Database to SQL Elastic Pool
  13. Azure SQL Database Elastic Pool Fundamental
  14. Azure Single Database Fundamental
  15. Azure Database Deployment model options
  16. Azure Administration AZ-103 Exam preparation and learning Resources 2020
  17. Microsoft Azure AZ-103 Tips,Hints and Notes Part 3
  18. Microsoft Azure AZ-103 Tips,Hints and Notes Part 2
  19. Microsoft Azure AZ-103 Tips, Hints and Notes Part 1
  20. Enabling Auto-Failover Group on Azure SQL
  21. KQL in Azure Data Studio April 2020 Release
  22. Microsoft Azure Storage Permission
  23. How to Manage Azure with PowerShell Command from Azure Data Studio
  24. Azure Date Transfer Solutions
  25. Azure Storage Geo-Replication
  26. Azure VM Backup Soft Delete Security features
  27. Copy Files to or from Azure Storage using Azcopy
  28. Create Deadlock Alert on Microsoft Azure SQL
  29. The subscription is not registered to Microsoft.insights resource provider
  30. Manage Azure Policy Using PowerShell
  31. How to Solve Error Azure Recovery Services vault cannot be deleted
  32. Sync your local files with Azure Storage Sync Service
  33. Moving Azure VM Using Recovery Service Vault
  34. Virtual Machine (VM) Backup and Restore (Vault)
  35. Moving Microsoft Azure Resources Using PowerShell
  36. Azure Storage Account and Log Analytics
  37. Create Storage Account Using PowerShell and CLI Command
  38. Microsoft Azure Storage Kind and Architecture
  39. Azure Data Explorer Cluster
  40. How to Export data from Azure SQL DB
  41. Azure Active Geo-Replication Services
  42. Azure Services for Monitoring and tuning Azure SQL Database
  43. Azure Log Analytics
  44. AZ-104: Microsoft Azure Administrator (beta) Released
  45. Azure Subscription Administrator Roles Types
  46. What is Azure AD Connect Sync Engine
  47. Azure Virtual Machines Types,Series
  48. Managing and implementing Azure storage
  49. Azure SQL Database Architecture
  50. How to manage Azure using Windows PowerShell
  51. Backup Tips on SQL Azure
  52. How to Migrate Database to Azure

I’m grateful for being one of the first 250 individuals in the world awarded with the very rare “Content Hero” 👏🦸‍♂️ Badger in 2020 Year 💪 for my contributions to the Azure community 👏 Glad to know that my contribution to the community is appreciated Azure Hero badger by Microsoft Cloud, which is a Blockchain-powered recognition award for being a contributor to the #Azure #community !! “Content Hero badgers are given out for sharing valuable knowledge at conferences, meetups, or other events. Recipients of this rare award have created original content, sample code, or learning resources and documented and shared their experiences and lessons to help others to build on Azure. It’s a new recognition program by Microsoft, and they describe it as a fun way to collect digital badgers for having a meaningful impact in the technical community.” Check out my first Azure Content Hero Badge here: ➡️ https://lnkd.in/eex9m4Q More power to the community members.

Mustafa Elmasry Azure Content Hero