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

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

FsLogix 2201 Public Preview release

Image
The FsLogix 2201 Public Preview release is now available for download from Microsoft. The change log is as follows: - Fixed issue where the FSLogix Profile Service would crash if it was unable to communicate with the FSLogix Cloud Cache Service. - The OfficeFileCache folder located at %LOCALAPPDATA%MicrosoftOffice16.0OfficeFileCache is now machine specific and encrypted so we now exclude it from FSLogix containers. Office files located outside this folder are not impacted by this update. - Windows Server 2019 version 1809, and newer versions of Windows Server, natively support per-user search indexes and we recommend you leverage that native search index capability. FSLogix Search Indexing is no longer available on those versions of Windows Server. - Windows 10 Enterprise Multi-session and Windows 11 Enterprise Multi-session natively support per-user search indexes and FSLogix Search Indexing is no longer available on those operating systems. - FSLogix now correctly handles cases where...
Read more