Azure database services overview

Azure database services overview

Introduction



The current post attempts to present an overview of the Azure database services, as of late May 2022. Azure database services mainly cover the conventional database administration side of things (with SQL and NoSQL databases) but can conceptually expand to cover a full range of Analytics and Data Engineering and Analysis services (for example Azure Data Factory and Azure Synapse Analytics). This broader view of data-related services essentially constitutes the Azure Data Platform. Given the dynamic nature of public clouds, this list will most likely change soon in the near future but nevertheless acts as a general point of reference when discussing Azure database services.



You find an overview of all Azure service categories at https://stefanos.cloud/blog/azure-service-categories/.



Database services



Azure allows you to support rapid growth and innovate faster with secure, enterprise-grade, and fully managed database services.



Azure Cache for Redis

Accelerate apps with high-throughput, low-latency data caching



Azure Cosmos DB

Build or modernize scalable, high-performance apps



Azure Data Factory

Hybrid data integration at enterprise scale, made easy



Azure Database for MariaDB

Deploy applications to the cloud with enterprise-ready, fully managed community MariaDB



Azure Database for MySQL

Fully managed, scalable MySQL Database



Azure Database for PostgreSQL

Fully managed, intelligent, and scalable PostgreSQL



Azure Database Migration Service

Accelerate your data migration to Azure



Azure SQL

Modern SQL family for migration and app modernization



Azure SQL Database

Managed, intelligent SQL in the cloud



Azure SQL Edge

Consume Services privately on Azure Platform



Azure SQL Managed Instance

Managed, always up-to-date SQL instance in the cloud



SQL Server on Azure Virtual Machines

Migrate SQL Server workloads to the cloud at lower total cost of ownership (TCO)



Table Storage

NoSQL key-value store using semi-structured datasets



Azure Managed Instance for Apache Cassandra

Modernize Cassandra data clusters with a managed instance in the cloud



Azure confidential ledger Preview

Tamperproof, unstructured data store hosted in trusted execution environments (TEEs) and backed by cryptographically verifiable evidence





Becoming Azure-certified database engineer and data scientist/analyst



As per the Microsoft official certification poster (https://aka.ms/TrainCertPoster), there are four available certifications in the fields of Azure database services engineering and data science/analysis.



- Azure Enterprise Data Analyst Associate. Candidates for the Azure Enterprise Data Analyst Associate certification should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions. Associated certification exam is DP-500.

- Azure Database Administrator Associate. The Azure database administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built with Microsoft SQL Server and Microsoft Azure Data Services. The Azure database administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes. Associated certification exam is DP-300.

- Azure Data Engineer Associate. A candidate for the Azure Data Engineer Associate certification should have subject matter expertise integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions. Associated certification exam is DP-203.

- Azure Data Scientist Associate. Candidates for the Azure Data Scientist Associate certification should have subject matter expertise applying data science and machine learning to implement and run machine learning workloads on Azure. Associated certification exam is DP-100.

The foundational certification which covers all basic aspects of database administration and data engineering/analysis is related to the DP-900 exam: Microsoft Azure Data Fundamentals.



References



https://azure.microsoft.com/en-us/services/



https://azure.microsoft.com/en-us/product-categories/databases/


https://stefanos.cloud/blog/azure-database-services-overview/

Comments

Post a Comment

Popular posts from this blog

Acronis Cyber Protect 15 virtual machine backup not working when using shared mode virtual disks vhds

Image
Case When you apply and run an Acronis Cyber Protect backup against a virtual machine which is part of a guest cluster which makes use of virtual disk shared files of type .vhds (VHD Set), you run across the following error. Activity succeeded with warnings. Activity 'Preparing for backup of virtual machine' succeeded with the following warning 'Windows error: (0xC05CFF0A). The requested operation cannot be performed on the virtual disk as it is currently used in shared mode. Or the error may state something along the lines of: "Failed to open virtual disk file '.vhds'. Unknown format of the virtual disk." The same error as above can occur in virtual machine backup of virtual machines which include a .vdhx shared disk. Solution The above error is by design when you are attempting a virtual machine backup to virtual machine which does not have an Acronis backup agent installed, as per https://kb.acronis.com/content/68573 . According to Acronis, as of July 2
Read more

How to perform hardware health checks in Windows

Image
Case You need to perform an overall hardware health check in a Windows machine, running either a Windows client or a Windows Server operating system. This article provides guidance on the steps to carry out to perform hardware health checks in Windows. Solution Carry out the steps below. - Thoroughly check all Windows event logs (Application, System, Security) for any warnings or errors which may be related to issues you are experiencing with your Windows machine. - Check the device management mmc console by running devmgmt.msc. Ensure that you choose to show all hidden devices from the View menu. If you notice any exclamation marks next to any device, you will need to re-install its driver from the respective manufacturer to ensure that there afterwards no warnings in the device management console. - Check the health of all your disks , either HDD or SSD. Follow instructions in the following KB article for steps to follow to check your disk health: https://stefanos.cloud/kb/how-to-ch
Read more

How to resolve Group Policy error codes 8007071a and 800706ba

Image
Case You are running "Group Policy Update" on an OU inside the Group Policy Management Console in Active Directory but you are receiving RPC errors from your servers or domain-joined workstations, as shown in the example below. After a Group Policy Update, you come across Group Policy error codes 8007071a and 800706ba. This means that the local Windows Firewall is not configured properly to allow Group Policy (GPO) traffic. GPO traffic an be either remote GPO update or remote GP Resultant Set of Policy (RSOP) operations. Solution Option 1 Run gpedit.msc and create a new local group policy object which implements the following policies under Local Computer Policy --> Computer Configuration --> Windows Settings --> Security Settings --> Windows Defender Firewall --> Inbound Rules : The full configuration is shown below. After the above local group policies are configured on each domain server and workstation, you can start applying group policy objects to the dom
Read more