I'm looking for some guidance please, we have a small (~500Mb) custom SQL server database that we need to run alongside the standard Sitecore 9.1.1 databases.
I'm also new to Azure so I apologies if I have missed something, but as far as I can see we need to create another resource group with another SQL database within that - the running costs being quoted seem very high given we don't hold a lot of data in there. I guess what I am looking to do is effectively create a new database within an existing
Azure SQL server.
Failing that I wonder if an option is to simply create new tables within the
Sitecore_core database. However, I'm not sure of the implications of this - is it possible/supported? I guess this would save costs if it's possible as we are just re-purposing the existing database that's already in the budget and paid for.
Any pointers appreciated!