i waited for years

...for SQL Server to work on my ARM-based MacBook Pro, and more recently on the Snapdragon X Elite machines. Now it can.
Try Quadratic today - www.quadratich...
Run Windows on Mac using Parallels: prf.hn/click/c... (affiliate)
Use coupon code: ZISKIND10
🛒 Gear Links 🛒
📺🧑‍💻 Monitor for coding 28": amzn.to/3XgFkaR
📺🧑‍💻 Monitor for coding 24": amzn.to/4dWhRlA
📺🧑‍💻 My LG Monitor: amzn.to/4dFpZ9t
📺🧑‍💻 My LG Monitor with ARM: amzn.to/3Mkbg7Y
* 🎧⚡ Great 40Gbps T4 enclosure: amzn.to/3JNwBGW
* 🛠️🚀 My nvme ssd: amzn.to/3YLEySo
* 📦🎮 My gear: www.amazon.com...
🎥 Related Videos 🎥
* 📺 About Vertical Monitors and Coding - • I Wish Someone Told Me...
* 👨‍💻 MacBook Air with 144Hz Display - • I didn’t know what I w...
* 👨‍💻 15" MacBook Air | developer's dream - • 15" MacBook Air | deve...
* 🤖 INSANE Machine Learning on Neural Engine - • INSANE Machine Learnin...
* 🛠️ Developer productivity Playlist - • Developer Productivity
- - - - - - - - -
❤️ SUBSCRIBE TO MY KZbin CHANNEL 📺
Click here to subscribe: / @azisk
Join this channel to get access to perks:
/ @azisk
- - - - - - - - -
📱LET'S CONNECT ON SOCIAL MEDIA
ALEX ON TWITTER: / digitalix
- - - - - - - - -
#softwaredevelopment #macbook #sqlserver

[@RobRitchie-bs1ql]

You know what - in spite not being a tutorial, it's a fairly good tutorial on what it takes to get this thing running. Thanks for posting this Alex.

[@ZhuJo99]

That's funny. Running Microsoft SQL server in a Mac is easier than in Windows 🤣

[@mojizze]

Not really. He would have gotten similar results if he used the docker version on Windows. Lol

[@MaavBR]

@@mojizze He would not. You can't load an AMD64 image on Docker for Windows on ARM. This works on Apple Silicon, however.

[@xBINARYGODx]

@@MaavBR the op is still entirely wrong because running it in Windows, even if only trye on x64, is the easiest - the newer arm windows being a bit behind the much less new mac on arm, is actually not really surprising even if it makes good memes.

[@MaavBR]

@@xBINARYGODx Windows on ARM is older than macOS on ARM. We've had Windows RT on the Windows 8 days, and Windows 10 had a full ARM release way before Apple Silicon was even announced. Besides, the fact that you have to go through this many hoops to get it running on Windows on ARM with Microsoft knowing how prominent ARM has become in the datacenter space in the last few years (plus themselves pushing ARM PCs now) is ridiculous. Just like with Apple, at the very least their entire first-party software library should run on ARM on release (even if through a translation layer for some apps).

[@dinbandhusharma4568]

That pain for first time setting up, after that, that will be easy

[@TalynOne]

If you run SQL Server Management Studio as Administrator (right click run as admin on the shortcut) it will work for windows authentication login, no need to create a new account, also it requires an additional registry addition (found it github issue discussion) to enable TCP connections from code. Once you have it running once you can create SA or other regular SQL account for future logins.

[@Z3rgatul]

This ^ If you start process without "Run as admin", your security token has no local administrator group And SQL server checks if your token has this group

[@CrisDevDotDot]

@@Z3rgatul omg omule mersi !!

[@emilfabrice]

No Windows machine with ARM (and not installing SQL just for the purpose of testing) but I was wondering why doing the whole logout-shenigans? If account is in admjnistrators, just right click to "run as administrator"?

[@JoeMilbachOnline]

I feel your pain Alex. This was a great video, loved the humor mixed in with the madness of getting things working.

[@Kitsune_Dev]

I NEVER CLICKED SO FAST

[@bassheadlife492]

Why?

[@nymbusDeveloper86]

Me too

[@PankajNikam]

+1

[@Winnetou17]

Is just me who, in a bad day would've gone into a SCREAMING MENTAL BREAKDOWN over that login not working over and over again ?

[@Dalamain]

Alex at some point in the future it would be worth updating the video title so others wanting to run SQL Server on ARM can find it, great video man!

[@WillemAsselbergs]

Fantastic detail and journey. We all feel your pain. And relief.

[@alokbomb]

This was long overdue, glad it's working on ARM now !! Now the next one....Native ARM SQL Server... 🙂

[@JoeBurnett]

I love the ARM platform. My favorite videos of yours are where you're using your Apple Silicon Mac and Parallels to run apps on Windows 11. I've been using my M2 Max MacBook Pro and Parallels 19 to use Windows 11 and have found the performance phenomenal! Oh, and I could never give one of your videos a thumbs down!

[@18PregnantAndProud]

did u find any compatibility problem with windows apps ?

[@alexanderruchkov7629]

Is running multiple vms and applications inside taxing on ram?

[@MrSparc]

Are you running Windows 11 for ARM or x64 I'm your Parallels VM?

[@SlyEcho]

Docker Desktop on macOS runs an Arm Linux virtual machine to run the containers and inside it it is using Rosetta, the Linux version

[@mazkanata7151]

Thanks Alex, it worked! I actually installed sql server on M1 without docker.Finally, next up is Microsoft server for ARM and its game over.

[@CraigCruden]

Never used SQL Server, but I am glad that I have been able to run both Postgres and Oracle RDBMS (via VMWare/Oracle Linux ARM/Oracle RDBMS ARM)

[@vadym8713]

This is the most entertaining channel for developers ) I, myself, working as an architect and mostly nowadays doing development in 'read-only' mode, but looking at you is both entertaining and much more helpful, than watching those tech KZbinrs mostly concerned with video editing

[@mudianyikevin7470]

Hi, we gonna need a proper tutorial for that. This was too fast for me. I wanted to get me a snapdragon laptop but wasn't sure it would run sql and ssms. Good thing i am subscribed to your channel

[@mponiedzialek]

Microsoft released SQL Edge which had support for ARM processors but for some reason they abandoned it in last year

[@seabird3896]

You're one intelligent dude figuring all this out 😂 99.1% of it flew over my head 😭😂

[@pytorche6206]

The "Boom" drink game. I am drunk. (Joking).

[@matthewblott]

What's amusing to me watching this is I remember migrating MSSQL from Windows to Linux as soon as it was viable a few years ago and being amazed at how much easier it is to run on Linux!

[@bara4067]

9:06 had me laughing so hard

[@weinbergfahrer4048]

Thank you for your unwavering optimism - and bringing us little nuggets like this so frequently! Would you consider it safe to move one's work as a dev to Windows on Arm at this time - or better wait for another six to twelve months?

[@xBINARYGODx]

the newer Intel and even AMD processors that are finally, actually mobile parts are what might be worth waiting for - maybe get arm like battery life with as good or better performance and never have to worry about compatibility.

[@mohammedmudassirshaikh557]

Thank you for showing this. Finally some way to run SQL Server stuff on Arm! I am still going to stick with x86 until MS supports (optimizes it to run) on ARM.

[@garynagle3093]

I felt your pain. So glad this works.

[@fshtank]

MS SQL is the DB I ‘grew up’ on (as it were) I’ve used Oracle, Sybase, Mongo, MySQL/Maria, PostgreSQL … SQL Server / TSQL is my favorite hands down

[@dinbandhusharma4568]

The way you solve the administrator problem access is amazing 🔥

[@bamqadem]

Thanks, Alex, for the good news. Did you try setting Encryption to Optional under Connection Security while logging into the SQL Server? It will accept your normal Windows user.

[@arthurmelo88]

You deserve a thumbs up just for the pain and suffering you went through manipulating users and authentication within Windows.

[@galvesribeiro]

Just FYI - there is a version of SQL Server which run on ARM natively which is the Azure SQL Edge. You can install from a container.

[@spdrasr007]

It's going to be interesting to see the new Intel processors. If they are even close to what they are being advertised as then it kind of kills the need for Snapdragons. Unless, they are going to be much more expensive. Looking forward to watching your reviews. Hopefully you'll get the Lenovo 7i.

[@alfajrdream]

love to watch your videos. super content. keep going.

[@prnva_]

Really like these videos Alex!

[@xiLeMaNiK]

Hi Alex, found your channel over the last year and I love the content you put out. One thing I'd like to see is an example of x86 code and the equivalent arm64 code for the same function, with some explanation on the differences. This talk of "translation layers" (Rosetta 2 on Mac) has me curious what's actually going on under the hood.

[@abusimbe]

Congrats!!!!

[@carambanoescacharrado9446]

In mac is just docker run and it works, I've been using it for years

[@june5646]

Now imagine if we got a PostGreSQL DB ARM version...

[@endaksi_channel]

Windows on ARM machines should be great for running Linux :)

[@arthurmelo88]

absolutelly

[@overburdeneddd]

Alex always makes a video which is related developer enviroment. this is smt unique

[@fullmetalindividualist7802]

Postgres has run natively on MacOS arm64 for years. `brew install postgresql`

[@petrzurek5713]

Now that it is half-ass working, people are gonna complain endlessly until it works “natively”, I’d call it a good start

[@techlitindia]

I loved the frustration 😂 because I thought you were smarter but now I know we all devs are the same. We have to go through this frustration phase everytime 😅 Keep exploring ❤

[@AZisk]

i can guarantee that im in the bottom 50% of the people that watch my channel:)

[@robertbutscher6824]

Great video, is it possible to run SSAS in such an environment? I‘m not sure, wether MS Data Tools will work in an Arm environment. Visual studio runs on Arm, but not the SSAS template. I think it‘s less stressful to use an ssql instance on Azure, isn‘t it.

[@AZisk]

depending on your situation, azure might be a better option.

[@robertbutscher6824]

Thanks, Alex ❤ your channel

[@BrandonLackey]

I'd settle for just an SSMS for Arm at this point lol

[@DanielHarrisCodes]

Azure Data Studio - better in some ways, worse in others

[@BrandonLackey]

@@DanielHarrisCodes yup, I use it everyday but need a RedGate plugin 😔

[@atomsbaza2]

@@DanielHarrisCodes agree

[@spadesman_the_first3296]

I use JetBrains DataGrip for all my querying needs and keep SSMS around for DB management

[@templarbr]

When using windows authentication qith Sql server management studio or azure data studio on windows, you can launch a process with runas command line or shift+right click over the target application shortcut, a prompt will appear, then introduce local account into it. .\local-username or full computer name. 😎

[@Egor9090]

In a world where Azure SQL Edge exists people still trying to run x86 SQL Server on ARM

[@SwissPGO]

Very secure ... having to log in as administrator

Alex, we need a video about that keyboard...

[@AZisk]

i’m liking it more and more.

[@melmartinez7002]

Oh my gawd. Watching you go through the torture of MS authentication shenanigans .... smh. It just shouldn't be that stupid.

[@ceruleous]

PostgreSQL has been natively running on ARM forever and it's better than SQL Server

[@BelarusianInUk]

You could use Colima to run x86 docker containers on arm

[@FlorinArjocu]

That looks a bit like torture. Maybe he should use some other db server.

[@PinoyDIY]

Humm, been using SQL Server on M1 for years. My dotnet integration test will automatically execute a docker-compose for initializing all the dependencies including the SQL server, and execute the migration script (table, sp, lookup data, etc), then run the test using the triple-A pattern. After the integration tests are completed, the SQL server instance is left intact. The reason I didn't tear down the data is if I need to inspect the data created by test results or use it as sample data for API I don't need to manually create it. On the succeeding run, the migration is no longer executed but tear down the data instead from the previous run before running the tests again. This same identical workflow is also performed in the CI pipeline.f

[@robertbutscher6824]

Great video, one month ago I failed in configuring sql server on Arm, i used the same script.

[@jorgesaravia8586]

The struggle at the end! Btw what's that keyboard?

[@mansoorbepar]

“Same same but different”

[@pmarkx84]

Well tbh the windows arm part is painful. Windows need to support arm stuff better...

[@nyambe]

This could actually be a skit, pure comedy, but it is not. It seem that the apple silicon installation was easier. I laughed when I remembered all those hacks to get things running on a windows machine, sorry about that. It reminded me of back in the day.

[@blevenzon]

Now I wish they made RSAT run on ARM

[@fallinginthed33p]

Power BI Desktop could be next.

[@hvishal44]

Really waiting for you to compare java computation between arm and x86. Lots of Indian guys are waiting for this

[@ranjitmandal1612]

Windows sometimes becomes so much pain

[@Thakkshan-d6g]

Hey man what are some coding IDES that you use your video are amazing

[@Kitsune_Dev]

Does this means you can run Windows on Arm? (what about Linux?)

[@AZisk]

yep. both

[@unjordi]

It actually runs better in Linux. You can have multiple independent instances running in their containers and keep track of them all with another docker container called Portainer

[@Trickey2413]

feet. thanks for reading my ted talk.

[@HadesTimer]

I'm sorry Alex, I hate MS SQL Server...

[@tnowak]

I wonder if MSDTC is working between these two machines :)

[@ovicwankenobi]

it should work if you change from Mandatory to Optional on the certificates

[@seenukarthi]

I used to run Azure SQL Edge docker image which is an arm image but in latest version of docker it’s crashing constantly

[@AZisk]

I haven’t used the Edge version, because I prefer all the features of full SQL server - hopefully this method works for you now

[@seenukarthi]

@@AZisk yes now I’m using the way you are using

[@paulh6933]

I run Azure SQL Edge also. Lately if i update the container, the next day the container no longer runs (i power off at night). If i don't update everything works fine.

[@seenukarthi]

@@paulh6933 it’s something to do with the kernel version in the latest docker. In macOS now you can run x64 containers in Rosetta 2

[@theontologist]

Ditto. My used Azure SQL Edge containers often fail to relaunch after stopping them, and sometimes I have to create a couple fresh containers before they work at all. I keep my data in a Docker volume that I aggressively back up. I wish I could keep the data in a volumized folder on my host Mac OS, but Docker on the Mac seems to handle host directory-based volumes poorly.

[@knightrider697]

I wonder who in the world would still use windows for development.. In fact, I wonder who would still use windows at all, if they had a chance not to

[@The_Penguin_City]

PostgreSQL in Debian for arm chips 😊

[@focus168168]

Do you think you could try installing Mac OS as the boot OS on a Snapdragon and run it like an M3 chip? lol. They are all ARM though MAC OS might not detect it.

[@paulh6933]

Installed Docker Desktop on M3 mac, ran the docker cmd, get the WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8). looking in Docker Desktop, container is not running, try and start it runs 3 seconds, fails. there is a warning triangle w/ AMD64 saying poor performance. Perhaps Alex is running some other software like Roseta 2?

[@rushabjain7485]

Can someone please summarise what this video is about? I am not very technical but got the yoga slim 7x snapdragon laptop recently.

[@shubhamsehgal2336]

@@rushabjain7485 return it back

[@AZisk]

really?

[@rushabjain7485]

@@AZisk 😂😅. Or you could suggest an AI tool that summarises this video

[@AZisk]

@@rushabjain7485why would anyone spend their time summarizing this for you when you’re too lazy and obviously don’t even really care about the topic.

[@rushabjain7485]

@@AZisk I have ADHD

[@fadoobaba]

WOnder how is PyTorch performance on Snapdragon chips? like for training simple multi layered perceptrons? at a hobbyist level..

[@ChrisBautista]

i don't like MSSQL simply because of the authentication problems you face when trying to connect to it

[@AZisk]

security vs convenience.

[@devavishka]

Hey I am a cs student starting next year I was wondering I have a laptop should I get a tablet with it or just the laptop is enough my laptop is a razer blade 15 brand new I just got.

[@Thulebeez]

Man i have been waiting for the exact video for past two weeks SQL Sever running on ARM now i just need my Biz app ERP to run on ARM, hey Alex can test and install SAGE 200 ERP on the Surface , Being trying to spin up ARM VM's on Azure but no luck.

[@oldmonkplays]

Sometimes you gonna threaten your computer "with the Administrator account" 😅

[@SwissPGO]

Sometimes that's not enough... NT AUTHORITY\SYSTEM is the ultimate god account.

[@DanielHarrisCodes]

I looked into trying to get this working previously on a new Mac, but had to go back to SQL Edge running in an emulated Linux container. Does the job still, but I'll revisit this to run natively as also interested in getting SQL running on Linux outside of my Mac

[@ambecki]

You can start SQL management by command runas with parameter noprofile or netonly (for domain login).. And I don't know why there is no simples way to do it....

[@dustsucker4704]

Is there a reason you use SQL Server? And not any other SQL Database?

[@spadesman_the_first3296]

I have been using the Azure SQL Edge arm build for several years now with no problems

[@AZisk]

different product, but ok

[@leolucas4922]

Azure SQL Edge no longer supports arm

[@spadesman_the_first3296]

@@leolucas4922 Ah, thanks for the update.

[@krccmsitp2884]

This was fun.

[@petereriksson6760]

If I am not wrong, Win Home can not run SQL Server regardless of x86 or ARM…

[@petereriksson6760]

Well, not without some trickery at least… I might remember wrong…

[@jerry9548]

Why not run Azure SQL Edge in Docker when developing locally? Has worked perfectly for me for over a year on my macbook.

[@AZisk]

different product

[@jerry9548]

@@AZisk Yes but for development purposes it has been working perfectly fine for replacing SQL Server on my MacBook.

[@AZisk]

@@jerry9548depends what you’re developing. if you need OLAP then you can’t

[@martimmourao]

This video represents my experience using Windows as a developer.

[@TakuCoding]

Yeah I will hold on the new arm pcs from now looks like too much work than it needs to be lol 😂😅

[@catalinpreda4666]

doesn't look much harder than x64 windows tbf MSSMS is just a pain to log into sometimes - most of the issue he ran into at the end I encountered with my normal windows installs

[@jw-works]

Do you have Rosetta 2 enabled ?

[@unjordi]

But I already run my own docker server at work with 8 instances to be able to use all the 48 cores with Express license (pro tip) 😎. What I need is SSMS everywhere!! EVERYWHERE! (In Linux, plz😢)

[@Ahmed-jj5qk]

Awesome video, as usual! I just have a quick question: How can I access the Visual Studio app (for example, the Swagger page) from macOS when using Parallels? Is there a way to set up port forwarding or something similar?

[@AZisk]

yes, you can configure networking in several different ways between the host and guest

[@Ahmed-jj5qk]

​@@AZisk Would it be possible for this to be the topic of a future video? 🥺 I use Visual Studio for the backend on Windows (running in Parallels) and run the front-end (Angular, React) on macOS itself. However, I've had a hard time connecting them, even with port forwarding, as it requires static hostnames.

[@davebraford7520]

Ok, couple of things. I've lost count the number of times I heard "Sequel Server" confused with "MY SEQUEL" due to the perceived interpolation of the short-tags "SQL" and "SEQUEL". Sequel is a Structured Query Language, there are others - like TSQL (which MS SQL Server supports). This is fine, when you speak in a group of data nerds - just not good practice in an instructional context. Running this bloated pile of garbage on ARM is just a waste of time - just use an Azure instance and be done with it. I can honestly say I would rather work as a Walmart greeter than interact with MS SQL Server in any context.

[@mr.nobody3862]

I want a full review of honor magic bookart 14

[@vinusuhas4978]

What about mongo db and its tools ? Also try other databses

[@scottsun345]

May I say this is why MacBooks don't use FaceID?🙃

[@catalinpreda4666]

they'll add it in a few years and call it groundbreaking Windows laptops started incorporating fingerprint readers around 2015-2016 with the introduction of Windows Hello in Windows 10. The first MacBook with a built-in fingerprint reader was the 2020 MacBook Pro

[@kangsan2014]

Does Quadratic function locally without internet connection? Notion is purely a dumpster fire trash program because it requires internet connection.

[@arastu1774]

what does sql do tho im not not a tech guy

[@jetman-x4e]

So stressful on windows

[@user-easycode-b8r]

nice keyboard

[@anshulsingh8326]

So you are Open WebUI user too

[@dhavalsavalia]

""We Truly Live in an Age of Wonders" - Craig Federighi " - Dhaval Savalia

[@nedeilse6994]

now ，another more years，lunar lake better