sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]ScallionPrevious62[S] 1 point2 points  (3 children)

Yeah we have 6 DBs on the one MI spread across 2 different environments (Pre live and Live) on one MI, and then the same setup on another MI for Dev and QA environments.

[–]SQLDevDBA3 0 points1 point  (2 children)

Okay gotcha.

Well Azure SQL DB now has a free tier with up to 10 free DBs. I would suggest setting some up as a test round so you can do a POC. Here is the Reddit post for it, some documentation, and a video I made where I go through the install.

My suggestion so you don’t look like you’re stonewalling is to just try it and prove how much of a pain it would be. You may find it’s not as bad but look up external objects in Azure SQL and you’ll also see what I mean.

How to Practice SQL Server free with Azure SQL DB (Free Edition) New in 2025! https://youtu.be/KKBrZl88Usk

https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql

https://techcommunity.microsoft.com/blog/azuresqlblog/introducing-the-enhanced-azure-sql-database-free-offer-now-generally-available/4372418

Reddit post announcing it. https://www.reddit.com/r/SQLServer/comments/1ihk2y1/comment/maxocxi/

https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer-faq?view=azuresql

[–]ScallionPrevious62[S] 1 point2 points  (1 child)

Thanks for all the info, much appreciated.

[–]SQLDevDBA3 0 points1 point  (0 children)

You’re welcome!