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?
🎥 Volterra First Look | Windows Dev Kit 2023 Tests - • Volterra First Look | ...
🎥 Visual Studio on Volterra - • Volterra vs M1 Mac Min...
🔴 Windows Dev Kit 2023 playlist - • Volterra
#visualstudio #softwaredevelopment #visualstudio2022
💻NativeScript training courses - nativescripting.com
(Take 15% off any premium NativeScript course by using the coupon code YT2020)
👕👚iScriptNative Gear - nuvio.us/isn
- - - - - - - - -
❤️ SUBSCRIBE TO MY KZbin CHANNEL 📺
Click here to subscribe: / alexanderziskind
- - - - - - - - -
🏫 FREE COURSES
NativeScript Core Getting Started Guide (Free Course) - nativescripting.com/course/na...
NativeScript with Angular Getting Started Guide (Free Course) - nativescripting.com/course/na...
Upgrading Cordova Applications to NativeScript (Free Course) - nativescripting.com/course/up...
- - - - - - - - -
📱LET'S CONNECT ON SOCIAL MEDIA
ALEX ON TWITTER: / digitalix
NATIVESCRIPTING ON TWITTER: / nativescripting

[@EricHarmon67]

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.

[@PaulJacobs51]

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..! :)

[@geostel]

I'm starting learning c#/ef with m1 macbook pro, sql edge works directly on docker on mac, without any vms

[@geostel]

also azure data studio available native on m1 in preview

[@PaulJacobs51]

@@geostel I actually program with Classic-ASP which requires IIS, so I use SQL Server Management Studio on the VM, but I do have SQL Edge installed in Docker on the Mac as well.

[@vicitacious]

M1 Mac Mini works great! Also, I use DataGrip for direct access to the db server but since I mostly use EF I hardly need it😊

[@maximillianus5453]

is it important install vscode??

[@bolow]

Thanks, Alex, I've followed almost the same steps but with macOS Docker Desktop instead of WSL, I'm using Parallels 18. Everything is working.

[@yourownazog8069]

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

[@mls4108]

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.

[@erik9817]

Thanks for the video. How would one host what's shown in the video for production (cheaply)? I looked up the cost of Azure SQL Edge, and it seems to be (minimally) around EUR10/month. Say we'd host in a VM running in a Docker container as in video, then we'd have to may for both VM and Azure QSL Edge license? Or is it possible to just deploy the Docker container (with Azure SQL Edge DB inside) without a VM?

[@sekirokun210]

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

[@userpml]

Thx Alex! Last week i spent also a long time with this problem and come to same conclusion. Docker is the only way to start MsSQL on ARM. I installed docker on my M1 Mac and using my app on Parallels with windows 11. It works.👍

[@erik9817]

Did you install Docker on the host OS macOS, or the guest OS Win 11?

[@userpml]

I instaled Docker on host MacOS .

[@fludy0207]

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

[@cornelisderuiter4279]

Love your videos!

[@anwar6971]

How can you install oracle virtual box on the machine?

[@muhammadelhelaly7162]

Finally working 🥳🥳 Many thanks 🙏🏻

[@coox4546]

Nice video! I love your channel. Just a tip. It’s not necessary to copy a file into wsl filesystem. Windows file system should be accessible from the ubuntu via mnt folder as well. At list it works in x86 architecture.

[@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!

[@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...

[@AZisk]

nice! thanks for the update

[@marcokaiser1700]

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

[@gnommak]

Hi Alex! Have you heard about Ventura ability to mount Rosetta 2 translator to Linux VM? I start seeing that some users managed to install intel docker inside arm linux with mounted Rosetta 2. They used lima + colima. I think it's would be interesting topic for your next video.

[@rastaman4lk]

I was able to install it on Parallels Desktop, MS SQL SERVER 2014 32-bit, without any issues. But if you have a newer version of your existing database, you will not be able to copy it from the newer to the old one. I created a migration script that created the schema with data. So then I just executed that script on my new database (2014). It's working for me without any issues. But it depends on how larger your database is.

[@twoodcc]

how about a mysql speed test, Volterra vs Mac Mini?

[@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

[@AZisk]

great tip

[@Willie-vr6gk]

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

[@Gustavofuentesm]

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

[@dgloverau]

Yup most stuff just works - stuff missing for SQL in a container seems to be the .NET CLR support, so you can't for example use the EOMONTH CLR functions... Cheers Dave

[@JoseSilva-gt6zj]

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!!!

[@woolfel]

I don't believe current tensorflow supports qualcomm ai engine. The current release supports GPU, CPU and TPU. Qualcomm has an SDK for running models, but they convert it from keras format to their own and then you deploy the translated model.

[@JoseSilva-gt6zj]

​@@woolfel ​ Thank you! "Neil Trevett" of the "Khronos Group" said that a new standard for sharing code between NPUs (Apple and Qualcomm) may be on the way. I'm glad about it.

[@woolfel]

@@JoseSilva-gt6zj that would be a good thing. lots of people have been waiting for tensorflow and pytorch support for other hardware accelerators. earlier this year I looked into AMD radeon support with tensorflow and it was making progress. Nvidia has dominated for tooo long.

[@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!

[@julybrown4916]

Great video Alex, can we please have the Mac version of it?

[@maxvamp]

@AZisk thanks for the great video. I love how you included Azure Edge. I wonder if this is part of the hybrid ecosystem MS plans on going forward with. Only MS knows. Keep rocking!

[@AZisk]

hybrid to the max - this is the MS way :)

[@angrysob7962]

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.

[@aler.4108]

Did you try to install version 2019 or 2022 ? Can you connect from VM using SSMS to remote SQL server?

[@angrysob7962]

@@aler.4108 Hi - this may be a duplicate response because KZbin appears to be flaking out on me this morning, so apologies if that's the case. I did, in fact, attempt to install SQL Server 2019 and 2022 when I originally set up the Windows 11 on Arm VM months ago. Both installs failed so I installed 2012 which worked perfectly fine. Windows 11 has made a lot of improvements through dozens of updates since I originally set up my development environment, so I may try to upgrade my SQL instance again. As far as SSMS goes, there is no discrete version for the Mac. However, you can get Microsoft Azure Studio for the Mac (both Intel and Arm flavors) and it will work fine to manage the SQL databases on your VM. You can also run SSMS inside your VM. You can connect to any SQL server to which you have access as long as you also have a network path to the server(s) in question. I use a product called Aqua Data Studio on the Mac side because I can manage multiple different database engines with it. It's a JAVA app so it's a memory hog and kinda slow, but it does the job nicely.

[@angrysob7962]

@@aler.4108 Hi - this may be a duplicate response because KZbin appears to be flaking out on me this morning, so apologies if that's the case. I did, in fact, attempt to install SQL Server 2019 and 2022 when I originally set up the Windows 11 on Arm VM months ago. Both installs failed so I installed 2012 which worked perfectly fine. Windows 11 has made a lot of improvements through dozens of updates since I originally set up my development environment, so I may try to upgrade my SQL instance again. As far as SSMS goes, there is no discrete version for the Mac. However, you can get Microsoft Azure Studio for the Mac (both Intel and Arm flavors) and it will work fine to manage the SQL databases on your VM. You can also run SSMS inside your VM. You can connect to any SQL server to which you have access as long as you also have a network path to the server(s) in question. I use a product called Aqua Data Studio on the Mac side because I can manage multiple different database engines with it. It's a JAVA app so it's a memory hog and kinda slow, but it does the job nicely.

[@paultarasov]

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

[@rastaman4lk]

I can confirim that as well, no issues.

[@doughenry7287]

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.

[@yuri_grillo]

Hi, Alex! Thank you for bring this quality of content about Volterra to us. Could you show how Python works on Volterra to?

[@AZisk]

that’s next :)

[@DaTruAndi]

@@AZisk Make sure you get the ARM version though - the challenge is - Python Devel I think is not available as ARM build. A lot of the more advanced things you may use in Python may not have ARM binaries to pull in, may need to run a lot in Windows Subsystem for Linux and compile things for your platform.

[@doughenry7287]

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.

[@AZisk]

interesting to know. thanks

[@karthikeyans8922]

Hey I am having M1 Macbook Air. If I purchase Parallels 18 desktop standard edition, will it work for future mac os upgrades or i need to keep upgrading to the relevant Parallels version?

[@casperes0912]

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

[@user-xr3rb6pn9m]

There is, but if you have a 100 000+ lines of T-SQL stored procedures (not kidding, that's what we have at work), you would rather use this weird solution than migrate to a different engine

[@EricHarmon67]

Alex, I spent a while today and couldn't get docker desktop running on my Volterra, so I could never install the sql edge package. Docker installs but won't start up. Is there a trick to it? If so, would you consider doing a video on that?

[@AZisk]

you have to make sure your docker daemon is running

[@EricHarmon67]

@@AZisk I wonder if I'm barking up the wrong tree here. Am I supposed to be installing the Docker Desktop for Windows? That's what I installed successfully on my Windows 11 x64 box, and that's what I'm attempting to install on the Volterra. I've been researching the daemon, and everything I'm finding is pointing to a Linux install.

[@AZisk]

@@EricHarmon67 You have to install docker for Linux in WSL. Docker desktop for Windows doesn't work on ARM yet.

[@EricHarmon67]

@@AZisk Ok, at least that gives me a place to start, thanks! I pulled up a link today that was supposed to lead me through the process, but it didn't work. It may have been outdated. I'll keep trying!

[@adjolev]

Do a video for the mac :) Great video btw!

[@ahmetuzun3136]

Hi, can we do the same on Windows 11 running in Parallels Desktop on M1 MacOS?

[@ahmetuzun3136]

Oops, the answer seems to be at the end of the video. Sorry :)

[@ahmetuzun3136]

...and yes, I really would like to see it done on Windows 11 running in Parallels Desktop.

[@cuachristine]

Alex. Why couldn’t you install the docker image for the real SQL Server?

[@doughenry7287]

It's not compiled for Arm, only x86-64 😞

[@abrahamguevara1921]

1:54 Not yet 😢

[@malaksedarous]

If Azure data studio is being emulated then why not use SQL Server Management Studio (without having the MS SQL server itself) through the translation layer as well? It works well for me. It's a bit slow but very usable. And I'm not even using voltera, I'm using the slower SQ2 Surface Pro X.

[@smokinjoe2122]

to confirm, SSMS works with Windows on ARM? Just curious as I am wanting to switch to Mac / Parallels Windows 11

[@malaksedarous]

@@smokinjoe2122 Not officially, but it installs and runs normally. It's just a bit slow as it's running through the emulation layer. You should try it out before purchasing a computer if it's a dealbreaker. Or maybe Alex can show us in a video?

[@theloniousMac]

I'd just install PostressSql on an M1 Mac. Or MySQL. Or MongoDB or SQLlite. Coupled with a development/management tool like TablePlus and I'd never look back at SQLserver.

[@nicholaitunstall7031]

Docker doesn't want to connect

[@cetinbasoz1030]

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.

[@erik9817]

Interesting take. And I thought that Docker images were superior, not have to install stuff locally. :) Care to tell more?

[@cetinbasoz1030]

@@erik9817 You need to install docker itself locally :) I wouldn't agree it is superior, you at least need to learn to use it. Having a docker image and local install of SQL server is not 100% the same thing. At least, I don't know how would I connect to docker SQL server using windows credentials, do you and would like to share? In a docker container, SQL server is the one for linux, no? It doesn't support all the CLR code that windows version does. Am I wrong?

[@inamulbhuyan]

Windows on arm with qualcomm oryon cpu 2023

[@muhammadelhelaly7162]

I cannot even install docker on my machine 😢

[@foxe2206]

ty ty ty ty

[@lucasfoussier]

I would like te see this on m1 Mac 😊

[@Theskullsplaylist]

I'd like to see video of Google play store running on it

[@royarnab22]

+1 for M1 Mac. :) please.

[@Frostainum]

lol sorry offtopic, but the presenter looks like Klitschko brother :D

[@aeonlancer]

Why cannot XCode be used for just everything easily?

[@aaaaanh]

That’s a very real pgsql server

[@atharvarusia6190]

great videos, also third

[@rohithkoushal2428]

year 2024 and still nothing from Microsoft

[@talktomenowxbmc]

Microsoft builds ARM based hardware for developers and ignores SQL Server for ARM. This makes no sense whatsoever especially that SQL is backbone of Microsoft development. Either they rushing with product development or they have no strategy.

[@broccoloodle]

Using WSL is cheating, it is not Windows

[@AZisk]

then call me a cheater :)

[@mokshaGyanRam]

hahahaha lol its true its sucks mac suck they took alot of money and then dont give accessories like USB HDMI etc I wish this company will loose everything in future and people open their eyes now and will go for intell and stop wasting their money on mac I wish some other great person will bring great product

[@talktomenowxbmc]

Microsoft builds ARM based hardware for developers and ignores SQL Server for ARM. This makes no sense whatsoever especially that SQL is backbone of Microsoft development. Either they rushing with product development or they have no strategy.

[@AZisk]

its a chicken and egg problem