Fundamental Information for Azure Open Source Databases

As all of us know that Microsoft Azure Supporting many different database types such as Azure SQL, Azure Cosmos DB, and Azure support also MariaDB, MySQL, and PostgreSQL so it easily to migrate your current database (MariaDB, MySQL, and PostgreSQL) to Azure , in this post i will share Fundamental information about MariaDB, MySQL, and PostgreSQL on Azur

  • For more information About Azure SQL Check this Link
  • For more information About Azure Cosmos DB check this link
  • For more information About Azure Exam ( Az-103, DP-200, DP-201, DP-900, DP-300)preparations Check this link
  • For more information About other Azure Services check this link
Microsoft Azure Open Source Databases

MariaDB, MySQL, and PostgreSQL on Azure

  • Microsoft Azure Offers 3 different open source Database Platform on Azure (MySQL, MariaDB, PostgreSQL) and this 3 Database platform service comes with native high availability, automatic patching, automatic backups, and the highest level of security protection
  • Service Tiers Supported by open source Database Platform on Azure
  • Basic: Best of a light workload
  • GP (General Purpose): Best for High Workload required high IO
  • Memory-Optimized: Best for High Workload required high performance and in-memory speed.
  • Supported version for open Source database platform on Azure
  • MySQL and MariaDB on Azure Transactions on either platform are written synchronously to storage. If a node interruption occurs, the database server will automatically create a new node and subsequently attach the storage to the new node. Any transactions in flight are not committed and active connections to the database are dropped. As mentioned with Azure SQL Database, it is important to ensure that applications that connect to the database service include retry logic, also known as connection resiliency, in their database connections.
  • Database migration can be done for 3 open source database platform using Microsoft DMS Azure Database Migration Service
  • Azure SQL Database for MySQL and PostgreSQL does not have a TDE: But Microsoft provided a disk encryption method.
  • Azure PostgreSQL Deployment Model (Single Server, Flexible Server {Preview} or Hyperscale {Citus})
  • Flexible Server, a new deployment option now in preview for Azure Database for PostgreSQL and Azure Database for MySQL, offers customers enhanced choice, performance, and scale by building on a new architecture with native Linux integration “Ignite 2020 News
  • Azure PostgreSQL Hyperscale used for large-scale databases that scale-out across multiple nodes
  • Azure PostgreSQL Hyperscale Server Called Nodes and it is working together in a shared-nothing
  • And the nodes are added to the Server Group
  • Each Server group have something called a coordinator node and multiple workers nodes
  • When the APP Sends the Transaction to Azure PostgreSQL Hyperscale, it sends it to the coordinator node and the coordinator node will find the worker nodes to collect the data to the APP.
  • Azure PostgreSQL Hyperscale is sharded, this means the data in a table can be split into multiple nodes using a type of table called a distributed table.
  • During the Deployment of Azure PostgreSQL Hyperscale Microsoft allow you to create additional worker nodes along with a coordinator node
  • You can deploy Up to 20 worker nodes and in case if you need more you should communicate with the Microsoft support team
  • You can connect to Azure PostgreSQL Using SQL or pgAdmin Clint
  • More information Check Documentation:
  • Query Store Supported in Azure MySQL

Azure SQL Database administration Tips and Hints Exam (DP-300)

Finally, I got my certification Azure Database administrator Associate for Exam (DP-300) after two times failure, during the journey of study I watched many courses, videos, and articles, and this post of today is for spreading what I have from the knowledge and what I learned during the journey, and I do two things during my study published around 70 articles in Azure technologies and prepared one document to contain many pieces of information for Azure SQL Database administration

So, in this post, you will find all of the resources that you can start your study from it and the document I created it

Azure Database Administrator Associate
Continue reading “Azure SQL Database administration Tips and Hints Exam (DP-300)”

Azure DP-900 (Data Fundamental) Certification perpetration

Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got my new badge for Azure Data Fundamental DP-900 with Score 882 and I passed this Exam by 3 resources only.

Azure Data Fundamentals
Continue reading “Azure DP-900 (Data Fundamental) Certification perpetration”

Azure Data Engineer Certification Preparation

This week i got my new Azure Certification badge (Azure Data Engineer) and today i am writing this article to share all of the resources i collected it during my study this is not a technical article I will not explain any concept or any technical information here this article is repository article.

Exam information

To get Azure Data Engineer Badge you should pass two exams DP-200 and DP-201

  1. DP-200 (Implementing an Azure Data Solution)
  2. DP-201 (Designing an Azure Data Solution)

Both exams are They are very similar DB-200 related for How to do and How to Implement and DB-201 related for How to design, how to provide a solution, how to choose between data sources, what is the best solution for data movement …etc.

DP-201 Exam contain many cases questions you should read the case very well and answer the questions on this case

Also, during the study, you can prepare for the other two exams because both of them are covering the same concept of Azure Data Engineer. Study well and enter the 4 exams (DP-200, DP-2001, DP-300, DP-900)

  1. DP-300 (Administering Relational Databases on Microsoft Azure)
  2. DP-900 (Microsoft Azure Data Fundamentals)
Azure Data Engineer Associate

After passing two exams you should earn the badge like this

Continue reading “Azure Data Engineer Certification Preparation”

What you need to know About Azure SQL backup

Most of DBA are coming from On-premise Database Servers they know very well How we can manage SQL backup using SQL Server native backup or even using SQL Server Backup third party tool but when we moved our database to cloud (Azure SQL) all of us starting to ask How the backup is taken in Azure for SQL Database, what is the RTO and RPO, How I can restore the backup all of this information I will list them in my article of today.

Continue reading “What you need to know About Azure SQL backup”