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”