One doesn’t simply install SQL Server

Microsoft seems to show more interest in supporting ARM products, especially now that Windows Dev Kit 2023 (project Volterra) is out, and it's an ARM based mini PC for software developers. Visual Studio works quite well on it, but what about SQL Server?

#visualstudio #softwaredevelopment #visualstudio2022

(Take 15% off any premium NativeScript course by using the coupon code YT2020)

— — — — — — — — —

❤️ SUBSCRIBE TO MY YOUTUBE CHANNEL 📺

— — — — — — — — —

🏫 FREE COURSES

— — — — — — — — —

📱LET'S CONNECT ON SOCIAL MEDIA

[PaulJacobs]

I am using my M1 Mac Mini with Parallels, and I installed Docker and SQL Edge on the Mac and access it from Parallels Windows 11 VM.. Works really well, and is not as slow as you might expect.. Loved your video Alex, very informative.. Keep them coming..! :)

[EricHarmon]

Thank you for this! I just got my Volterra yesterday. I've been trying to determine how to run SQL Express on an ARM machine. I have a potential client with an ARM Surface device, and my application only uses SQL Server as a database backend. I'm following along with your video right now. I know my app will already run in x64 compatibility mode, but now I can try building it native for ARM with Visual Studio for ARM.

[dgloverau]

Also, while I'm here - I updated my Volterra to the Windows Insider Release Preview (build 22623.898), and updated WSL to GA and it fixed the issue with WSL process running a constant 40% of CPU. Now with WSL loaded the CPU purrs along at 2~3% with no load...

[mls]

You can run SQL Server Management Studio 2018 in ARM, I'm using in Windows 11 with Parallels in my MacBook Pro 14. You even can run SQL Server 2014, 2019 does not work.

[doughenry]

No SQL 2022 on arm is disappointing, especially when Bob Ward stated at Ignite in the spring it was coming. It's funny how ADS is x64 on Volterra, but is now native on Apple Silicon (as of a couple weeks ago). For development work this is probably good enough. However as a SQL DBA, this is still largely not worth the effort.

[yourownazog]

I like every video about Volterra. Thanks for sharing your experience

[DEEDEEICAN]

well.. I've just installed postgresql inside a docker ! WSL is the god that gives anything you ask with this box!! there are still lot of images that doesn't work with amr64 in the docker hub! I'm just hoping it will all soon change!

[doughenry]

Just FYI, as of Docker v 4.16 there's now an option in settings under "Features in Development" to enable images to run in rosetta emulation. SQL 2022 will run under it!. Just have to ignore the error when starting up the container that it can't run. If you look you'll see it running and can connect to it.

It's still not arm native, but it's something anyway.

[JoseSilva-gtzj]

Hey, Alex! Thank you for sharing it, amazing! Please, when possible, could you show how TensorFlow and any MNIST dataset sample could run on ARM in Volterra? Thank you so much!!!

[dgloverau]

hey Alex, great content as always!.

Tried posting a more complete comment - but I think YT gobbled it up.

1. SQL Server Management Studio works on Windows on ARM (I'm running build v18.12.1), I spotted someone down the comments saying v19 doesn't work. Not tried.
2. Best to run SQL in a Docker Container with Docker Persistent Storage Volumes. That way you don't lose data if you delete the SQL container by accident. Docker persistent storage volumes make it easier to copy the .bak as you just do in the Linux filesystem.

Cheers Dave

[Gustavofuentesm]

Great! this sqlserver has stored procedures, triggers and t-sql language... which things aren't available? thanks

[paultarasov]

Sql Server 2014 32bit works great on Arm (Mac mini + Parallels)

[casperes]

There’s also MySQL, SQLite and a number of other SQL database solutions with various pros and cons

[sekirokun]

Can you please do a video on Mac? Planning to switch from Windows to MacOS, currently doing C#/EFcore and would sometimes work with SSMS for normal queries

[cetinbasoz]

That is the reason I sold my M1 and switched to a PC :( A different form of installation through docker or remote installation doesn't really pay the bill. You really need to be able to install locally. Otherwise it is a show stopper.

[fludy]

I didn't understand that ubuntu instance thing. So I have to run ubuntu as well to get my eth0 ip?

[angrysob]

Hi, Alex. I've got MS SQL Server 2012 running in a Windows 11 Pro for Arm image in Parallels on my M1 Max MacBook Pro. I fire up my VM and I've got everything I need for local development (IIS, SQL Server, MySQL, Node, etc.), all in a single Parallels VM. Yeah...it's a few versions behind, but if all you need is basic DB functionality, it works fine.

[pqsk]

Nice. You finally checked it out. On macOS the ip addr is the same as your Mac. I didn't know you can do more things besides query on azure data studio. I do a lot by hand since these days I only use SQL Server to work on my mobile apps. Well I write out and test scripts that are then automated on the app of course 😆 anyways would be cool to see it in the macOS just to see how it works for you. Long live the Schwarzenegger!

[Willie-vrgk]

Fun fact: You sayed "Just in Case" at 2:13 . That is registred trademark in Serbia :)

[marcokaiser]

in the video said the code will be here, but cant find it... where is the code?