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 #Azure, Azure Storage, Azure Storage services

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” →
Mustafa EL-Masry #Azure, Azure Storage, Azure Storage services

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” →
Mustafa EL-Masry #Azure, Azure Storage

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” →
Mustafa EL-Masry #Azure

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” →