No video :(

One doesn’t simply install SQL Server

Подписаться 241 тыс.

Просмотров 19 тыс.

50% 1

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 - nativescriptin...
(Take 15% off any premium NativeScript course by using the coupon code YT2020)
👕👚iScriptNative Gear - nuvio.us/isn
- - - - - - - - -
❤️ SUBSCRIBE TO MY RU-vid CHANNEL 📺
Click here to subscribe: / alexanderziskind
- - - - - - - - -
🏫 FREE COURSES
NativeScript Core Getting Started Guide (Free Course) - nativescriptin...
NativeScript with Angular Getting Started Guide (Free Course) - nativescriptin...
Upgrading Cordova Applications to NativeScript (Free Course) - nativescriptin...
- - - - - - - - -
📱LET'S CONNECT ON SOCIAL MEDIA
ALEX ON TWITTER: / digitalix
NATIVESCRIPTING ON TWITTER: / nativescripting

Опубликовано:

26 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 98

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

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

@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

@yourownazog8069 Год назад

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

@cornelisderuiter4279 Год назад

Love your videos!

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

@paultarasov Год назад

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

@rastaman4lk Год назад

I can confirim that as well, no issues.

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

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

@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 3 месяца назад

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

@angrysob7962 3 месяца назад

@@aler.4108 Hi - this may be a duplicate response because RU-vid 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 3 месяца назад

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

@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

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

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

@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

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

@muhammadelhelaly7162 Год назад

Finally working 🥳🥳 Many thanks 🙏🏻

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

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

@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 :)

@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

@abrahamguevara1921 Месяц назад

1:54 Not yet 😢

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

@Willie-vr6gk Год назад

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

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

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

@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

@fludy0207 Год назад

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

@marcokaiser1700 5 месяцев назад

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

@anwar6971 Год назад

How can you install oracle virtual box on the machine?

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

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

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

@julybrown4916 Год назад

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

@nicholaitunstall7031 Год назад

Docker doesn't want to connect

@twoodcc Год назад

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

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

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

@adjolev Год назад

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

@foxe2206 7 месяцев назад

ty ty ty ty

@Frostainum 11 месяцев назад

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

@inamulbhuyan Год назад

Windows on arm with qualcomm oryon cpu 2023

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

@royarnab22 Год назад

+1 for M1 Mac. :) please.

@lucasfoussier Год назад

I would like te see this on m1 Mac 😊

@muhammadelhelaly7162 Год назад

I cannot even install docker on my machine 😢

@Theskullsplaylist Год назад

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

@aaaaanh Год назад

That’s a very real pgsql server

@aeonlancer Год назад

Why cannot XCode be used for just everything easily?

@atharvarusia6190 Год назад

great videos, also third

@rohithkoushal2428 6 месяцев назад

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.

@AZisk Год назад

its a chicken and egg problem

@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 Год назад