Large Key Value Store in Sql Azure

Question

The requirement is to store a large key-value pair in SQL Azure which has an MD5 hash key and an integer value. Any practices I should be knowing about before querying it?

Answer 1

It depends on how complex your queries if you should maybe consider storage options other than Azure SQL. 

These can be:

1. Azure storage tables - A NoSQL service provided by Azure services which is cheaper as compared to SQL azure. It is also known for fast query processing
2. DocumentDB - Another NoSQL service provided by Azure which is a little more easier to work with that azure SQL. It is also more query friendly. 

Check this azure training out to get more insights on Microsoft Azure!