The technique described in the article was originally described at http://www.andresnava.com/2017/05/free-azure-sql-database/, however navigating to that webpage takes us to the hosting provider and site no longer seems to be available.
Google does not have a cached copy. Luckily way back machine has a copy here – https://web.archive.org/web/20170602140013/ http://www.andresnava.com/2017/05/free-azure-sql-database/
And many things have changed in Azure since the non-existent article was posted. Just for redundancy and staying on the edge, here’s a paraphrasing.
- Create a new Mobile App via the Mobile App Quickstart (through App Services in Azure)
Give an App Name, Create new or Use Existing Resource Group, Chose an App Service plan / Location, could be a free tier app service
And wait for the deployment to complete
- Go to Quick Start for the newly created App service and choose Windows C# template
- Choose Step 1 Connect a database, click on theiicon so the Data Connections Blade opens
- Hit Add Data Connection
Create a new database
- Create a new Server
- Now under pricing tier, you should see a new unlocked option called “Free” as in the screenshot below
Choose the Free tier, and hit Apply to see a 32 MB free database option
Now when you navigate to “Sql Databases” you should see the newly created database server. So that’s your free 32 MB database from Azure at your disposal. A free database of 32 MB can only be created one per region. So if you need another 32 MB database, then try to create a database in another region.