Azure Database Solutions
Various flavours of SQL Server. SQL Server on the edge of the network for IoT, ML processing. Azure database for MySQL, PostgreSQL, MariaDB, Cosmos DB, Cache for Redis, Managed Instance for Apache Cassandra.
Managed Cloud Databases
Azure SQL is a cloud-based relational database service that offers several different deployment options to meet the needs of businesses of all sizes. Here are some of the key Azure SQL offerings:
Azure SQL Database: This is a fully managed relational database service that provides a highly scalable, secure, and available database solution. It supports multiple languages and frameworks and can be used for a wide range of workloads, including transactional and analytical workloads.
Azure SQL Managed Instance: This is a fully managed database service that provides a SQL Server instance in the cloud. It is designed to be highly compatible with SQL Server, making it easy to migrate existing on-premises SQL Server workloads to the cloud.
Azure SQL Virtual Machines: This offering allows businesses to deploy SQL Server on virtual machines in the cloud. It provides a high degree of flexibility and control, allowing businesses to choose the size, configuration, and operating system of their virtual machines.
All of these Azure SQL offerings provide businesses with a highly scalable, secure, and available database solution that can be easily managed and monitored from the Azure portal. They offer a wide range of features and tools to help businesses optimise their database performance, ensure data security, and improve their overall productivity.
With Azure SQL, businesses can easily take advantage of the benefits of cloud-based database services, without having to worry about managing complex infrastructure.
Azure SQL Edge, on the other hand, is a cloud-based data engine that extends SQL Server to the edge of the network. It provides businesses with a highly scalable, secure, and intelligent data solution that can be easily deployed on edge devices, such as IoT devices, gateways, and routers.
With Azure SQL Edge, businesses can run analytics, AI, and machine learning workloads directly on their edge devices, without having to move their data to the cloud. This allows businesses to gain real-time insights into their data and take immediate actions based on those insights.
Azure SQL Edge provides a highly secure and reliable database solution that is designed to operate in disconnected or intermittently connected environments. It offers built-in support for Azure IoT Edge, allowing businesses to easily deploy and manage their edge devices at scale.
Azure SQL Edge is highly flexible and can be easily integrated with other Azure services, such as Azure Stream Analytics and Azure Machine Learning, to provide a comprehensive end-to-end data solution. It also supports a wide range of programming languages and frameworks, including .NET, Java, and Python.
Azure SQL Edge provides businesses with a powerful and flexible data solution that can help them optimise their operations and gain valuable insights into their data at the edge of the network. It offers a range of features and tools to help businesses manage their data, ensure data security, and improve their overall productivity.
Other offerings include
Azure Database for MySQL
Azure Database for PostgreSQL
Azure Database for MariaDB
Azure Database for Cosmos DB
Azure Cache for Redis
Managed Instance for Apache Cassandra
Each of these have a different use case which can be evaluated based on requirements and/or current architecture.