I'm running 3 web apps (for different customers) which each run a separate database instance. Two apps need a database with less than 2GB storage each, and the third app requires about 10GB of storage.
Looking at the SQL Azure database plans, I can use the "Basic" plan for the first two, but I need to get the Standard S0 for the third. This gives me up to 250GB of storage, which leaves a lot of excess capacity. Is there a way I can utilize the S0 database for my other two apps while still maintaining separate logical database instances?
Yes, you can - this is called Azure Elastic Pools https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool