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.
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
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.
Microsoft Azure supported two Purchase model:
For more information check this article
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
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
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
DB Cloud TECH 