Aside from spinning up a SQL Server instance container, the free Azure SQL Database is another great tool for learning SQL. You can even use it for low-traffic or lightweight app. See the documentations for the limits. I will not be responsible for your usage.
That said, let’s provision the database.
Provision an Azure SQL Database
Go to you Azure Portal and search for Azure SQL Database
On the upper left-hand of the UI, click on Create and select SQL database (Free offer).
Configuring an Azure SQL Database is pretty much intutive. For the Server option, use an existing SQL Database Server or create a new one.
Click Review + create to finish the setup.
Connect from VS Code on a MacBook
Go to your Resource Group and find your Azure SQL Database. Or, you can simply search for Azure SQL Database in the search bar again and that will take you to your databases.
Copy the Server name.
Now, open your VS Code (install the mssql extension if you haven’t already). Why VS Code? That’s because Mirosoft will never port SSMS to macOS. That’s why.
Create new connection. Look for the plug icon with the ‘+’ sign next to it.
For the Input type, Browse Azure wouldn’t work for me even if I already took care of the networking setting. Let me know in the comment if you made it work. Using Parameters worked for me.
Paste the Server name. Don’t forget to tick the Trust server certificate. Use SQL login and input the sa user and password that you set when you provisioned your SQL Server.
That should be it. Your Azure SQL Database is now ready to use.
The post How to Provision an Azure SQL Database first appeared on SQL, Code, Coffee, Etc..