Azure Table or SQL Azure for storing app data

0 votes
I am developing a Web App that will be hosted in Azure with ASP.NET for the web site and Silverlight within the site for a better user experience. I had a query regarding whether I should use Azure Tables or SQL Azure for storing my application data?
Jul 8, 2019 in Azure by sabby
• 4,370 points

1 answer to this question.

0 votes

Azure tables are cheaper, simpler and scale better than SQL Azure. SQL Azure is a managed SQL environment, multi-tenant in nature, so you should analyze if your performance requirements are fit for SQL Azure. 

You can consider the following points to decide: 

  • Do you need to do complex joins and use secondary indexes? If yes, SQL Azure is the best option.
  • Do you need stored procedures? If yes, SQL Azure.
  • Do you need auto-scaling capabilities? Azure tables is the best option.
  • Rows within an Azure table cannot exceed 4MB in size. If you need to store large data within a row, it is better to store it in blob storage and reference the blob's URI in the table row.
  • Do you need to store massive amounts of semi-structured data? If yes, Azure tables are advantageous.
answered Jul 9, 2019 by Perry
• 17,100 points

Related Questions In Azure

0 votes
1 answer

Where i can see the monitoring data in Azure? Can we get that data locally in SQL or NoSQL?

You can check the logs for the ...READ MORE

answered Jun 30, 2020 in Azure by Shivangi Namgyal
+1 vote
2 answers

Getting an App pool timeout for azure web sites

Windows Azure Web Sites supports two modes, ...READ MORE

answered Aug 21, 2018 in Azure by Priyaj
• 58,140 points
0 votes
1 answer

How can we connect Azure Web App to an Azure SQL Database?

Its easy now! Go to your Azure SQL ...READ MORE

answered Aug 9, 2018 in Azure by club_seesharp
• 3,450 points
0 votes
1 answer

Which is better: Azure Blob or Azure Table?

The best solution is blob storage with ...READ MORE

answered Mar 5, 2019 in Azure by Archana
• 5,640 points
0 votes
4 answers

How can I rename a SQL Azure database?

This command serves the purpose ALTER DATABASE [oldname] ...READ MORE

answered Nov 30, 2018 in Azure by Abhinav
0 votes
1 answer

Which cloud hosting is best ( AWS or Azure or Google)

Hello @Hammer, This totally depends on your needs, ...READ MORE

answered Aug 10, 2018 in AWS by Priyaj
• 58,140 points
+15 votes
23 answers

AWS vs Azure which one will have a more promising career?

Azure is integrating with a lot of ...READ MORE

answered Jul 4, 2018 in Career Counselling by Soumodip Sinha
0 votes
1 answer

Azure has 3 different types of storage accounts. Is there any major difference between them?

Azure Storage provides three types of storage ...READ MORE

answered Mar 4, 2019 in Azure by prerna
• 1,960 points
0 votes
1 answer

Configure Windows Azure For URL rewrite using WordPress.

You need to understand that the configuration is ...READ MORE

answered Jun 28, 2019 in Azure by Perry
• 17,100 points
0 votes
1 answer

How to register new users for MVC4 website on Azure AD?

The application holds the permissions to read/write ...READ MORE

answered Jul 3, 2019 in Azure by Perry
• 17,100 points