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 https://www.youracclaim.com/badges/b14fd62d-59ca-44c2-aa6d-b0ff85140b0b

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”

Distributed Tables in Azure Synapse SQL


Azure Synapse is the new Generation of SQL DW (Azure SQL Data Warehouse), that is launched in the past year In November 2019 the First announced for Azure SQL Synapse was in Microsoft Ignite 2019, With Azure Synapse you can bring together cloud data warehousing and big data analytics into a single service platform, Azure Synapse is massively parallel processing (MPP) Engine. Microsoft Added on it many features, With Azure, Synapse Compute is separate from storage, this means you can scale compute independently for the data in your System (APP), With Azure synapse, you can bring the relational Data and Non-relational data together in one place and easily you can do your query and your analytics on a huge amount of information, Azure Synapse build for a massive parallel query for Analytics not for transaction database, Azure Synapse uses Azure Data Lake Storage Gen2 for more information About Azure Data Lake Gen2 Check this Post, Azure Synapse Support (Apache Spark integration, Power BI, Azure ML), Also you can take a look to this demo with Rohan Kumar this demo is part from Microsoft Ignite 2019 Keynote and you can Follow Rohan Posts from here

Continue reading “Distributed Tables in Azure Synapse SQL”

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”

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”