Getting Started with Azure SQL Developer on Macbook - SQL, Code, Coffee, Etc.

Getting Started with Azure SQL Developer on Macbook - SQL, Code, Coffee, Etc.

No, this is not the SQL Server Developer Edition. This is something new (as of the time of writing). Well, it’s like the Developer Edition that you’ve all been familiar with in all the SQL Server versions. This Developer edition is for the cloud-only, PaaS Azure SQL Database. And, yeah, we would like to thank Microsoft for this!

The idea behind Azure SQL Developer is for anyone to build, iterate, and test locally at no cost. This means NO Azure subscription to deal with and NO credit card required! Everything will work seamlessly when you deploy your application to an Azure SQL Database backend!

It’s exactly like the SQL Server Developer Edition that we all love. As of this writing, it’s in Private Preview . And I got the chance to get into the preview program. Find more information about it here. There’s a short intro on youtube here.

I’d like to build something on top of Azure SQL Developer. But for now, let’s set it up on my dev environment:

Laptop: Macbook Pro M5 Pro<br>Code Editor: Zed 1.11.3<br>Terminal: iTerm2<br>Container App: OrbStack (my preferred container app on mac)<br>Database: Local Azure SQL Developer container<br>AI Coding Agent: Claude Code Max 5x

By the way, same steps should apply to Windows.

Authenticate to the Preview Registry

Like I said, Azure SQL Developer is currently in Private Preview. I was given a user and password to authenticate to the registry to pull the latest image.

Zshdocker login sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io -u private-preview-readerdocker login sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io -u private-preview-reader

Input the password that was sent to you when you get admitted to the private preview. Hopefully, pulling the image would be much more convenient when this goes public.

You should get a Login Succeeded message.

Pull the Azure SQL Developer image and deploy container

Let’s pull the image and deploy the Azure SQL Developer container to OrbStack.

Zshdocker run --platform linux/amd64 -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD='YourStrongPassword' -p 1433:1433 --name azuresqldb --hostname azuresqldb -d sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latestdocker run --platform linux/amd64 -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD='YourStrongPassword' -p 1433:1433 --name azuresqldb --hostname azuresqldb -d sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latest

Normally, I would pull the image first then deploy. But you can also directly deploy and docker should be able to pull the image first (duh).

Test connection to our local Azure Database Developer

Let’s send a query to the database to make sure we can establish a connection to it.

Zshdocker exec azuresqldb /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P 'YourStrongPassword' -C -Q 'SELECT @@VERSION;'docker exec azuresqldb /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P 'YourStrongPassword' -C -Q 'SELECT @@VERSION;'

And if you’ve followed the steps correctly, you should now be able to connect to the local version of Azure SQL Database.

As of this writing, as you can see in the screenshot below, the current version of Azure SQL Database Developer is 12.0.2000.8, July 12, 2026

Enjoy! I’ll build something on top of this. Come back for that later!

Author: Marlon Ribunal

I'm here to learn and share things about data and the technologies around data.

Leave a Reply Cancel reply<br>Required fields are marked *.<br>Message *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SQL Server 2017 Reporting Services (SSRS)<br>Basics Series

1.<br>Installation

2.<br>Simple Table Report

3.<br>Report Deployment

4.<br>Simple Parameterized Report

5.<br>Range Value Parameter

Power BI Desktop Series<br>Getting Started

1.<br>Getting Started With Power BI Desktop: Installation

2.<br>Getting Started With Power BI Desktop: Getting Data

3.<br>Getting Started With Power BI Desktop: Simple Visualization

Book I Wrote

SQL Server 2012 Reporting Services Blueprints is a step-by-step, task-driven tutorial. It provides enterprise reporting blueprints that address your day-to-day issues and requirements. Right from the very start, you’ll learn SSRS beyond the basics, giving you the skills to create the best reports for any task. Explore the possibilities, master your options, and choose the best tool for the job.

Book I’m Featured In

Data Professionals At Work is a collection of interviews of, well, data professionals working in the various aspects of the data industry – Database Administrator, Data Development, Data Analysis, Business Intelligence, Data Science, among others. You’ll read about how these professionals got their start in the data world. You’ll read about their opinion on what’s on the leading edge in the industry. You’ll get to...