When using SQL Server I can create as many databases as I want with the T-SQL "CREATE DATABASE" command.
After reading azure-sql-revealed-a-guide-to-the-cloud-for-sql-server-professionals and looking at the calculator I'm confused about the option of "Single Database" and "Elastic Pool" for Azure SQL... Does this mean that when I choose the Single Database option I can only issue the "az sql db create" command once?
What is the difference between az sql db create and the T-SQL command "CREATE DATABASE"?
Sat Apr 10 2021 Update:
Thank you AnuragSharma...
As per my pervious discussion, it looks like a single tiny serverless database would be a minimum of about $5/mo. Can you please guide me on using the pricing calculator so I can learn how much that monthly cost increases each time I use the "CREATE DATABASE" command for another tiny serverless database (which I just learned from the book Practical Azure SQL Database for Modern Developers page 26 is not a candidate for elastic pool). Would each new serverless database be approximately another $5/month or would it be less because they can share the same server and firewall?
Thanks
Siegfried
