Different between the azure table storage and the azure sql service

Question

Brahma Prakash Shukla · Answer

https://stackoverflow.com/questions/10257872/azure-storage-tables-vs-sql#:~:text=SQL%20Azure%20is%20great%20when,and%20usually%20with%20large%20volumes.

Rijwan Ansari · Answer

HI, Azure Table is a type of Azure Storage service that allows you to store structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. You want to store flexible datasets like user data for web applications, address books, device information, or other types of metadata your service requires. Example: Azure Cosmos DB For more details: https://learn.microsoft.com/en-us/azure/storage/common/storage-introduction Azure SQL Service You can use Azure SQL Database. Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business. This is similar to SQL Server on Azure Cloud. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql

Ijas Ahamed · Answer

There is a fundamental difference between a SQL table and Azure table. While azure tables are capable of storing one type of data in a row and another type of data in an another row, SQL database tables are designed to store the same type of data in each and every row.

Different between the azure table storage and the azure sql service

Answers (3)