Great video as always. I've watched a lot of your courses on pluralsight over the years and you're the best teacher by far. Thanks for producing this concise, clear example of how to use docker for sql server
Thank you so much for making these videos, Shawn! I hope your channel grows exponentially and reaches more and more developers who are hungry for this kind of knowledge you are sharing.
Awesome video!!! Somehow, it always seems like your new videos are discussing exactly what me and my team have planned for our upcoming work. This was a great overview on this topic and has helped me understand it better and see the full big picture. Also, there is something about this video that feels extra great. It might be the editing, or just the great planning for this demonstration, but I love it. Keep it up!
We did this several years ago on a complex project and it was great. Not sure this is still the case, but using the SQL Server image that runs on Linux was way faster and took up 1/5th of the memory to run.
Great to revisit this. A few years back, I walked thru the equivalent of this (obviously your compose.yaml is far more concise than the raw docker run I was doing on the command line). At that time, Docker Desktop for Mac didn’t support non ARM and even platform distinction was in its infancy. So, the amd64 platform type was a non-starter for Apple M1. I conclude the official container is either published for ARM now or Rosetta2 is out of Beta and working. My work around was to use an Azure Database (which gave me MSSQL good enough for my tests) which did work (way back then) on ARM. Can’t wait to revisit this with your excellent stream-lined compose definition- Thanks! 🎉 Now to revisit trying out the equivalent on Oracle DB in a container 🤔
The timing of this video is uncanny. I am literally setting up Windows 11 ARM on Parallels on my M3 macbook pro right now. I was starting to work through setting up a SQL container on my Mac to use with my Windows VM. Great video!
Super useful. Most of the search results showed manually creating the database on docker CLI and then adding that image to docker compose. I needed a way to start with barebones Microsoft image and pass all the parameters to create the image. This way I could always be on the latest version. Request to do another video showing how to build a k8s cluster on the dev machine and how to map volumes in cloud environment, preferably Azure. And also how to attach existing database files if that's the right approach. Once again thanks. Super useful.
He didn't show it. Basically, you need to find where the folder he specified with -name in the volume was created and it will be there. I am pretty sure there was an option to specify a path in which to create the folder (so you tell it where to create it instead of it's default location) which I'm not sure why he didn't show it here.
Yeah, I didn't show that, sorry. It depends on what OS you're on, but usually docker desktop's data in your user folder. If you look in Docker Desktop, look for volumes and can nagivate to the specific folder (when you setup volumes, you can also specify where the volume is): imgur.com/a/hLbvDg6
Hey 👋 ... Can I ask you , how could I install SQLserver in GitHub codespace ? ... Because in final step , I got an error about python!? ... Can you help me?
@swildermuth I wanna learn to use docker SQLserver and try it in codespace, because unfortunately it's only vps that I have to access for testing for free ... Other providers like azure and digital ocean exits for trial but all of them need credit card identification for access to them , and I don't have one , because of , i born in country that under sanctions. Thank you for your reply 👋
Great video as always. I've watched a lot of your courses on pluralsight over the years and you're the best teacher by far. Thanks for producing this concise, clear example of how to use docker for sql server
Great to hear!
You're one of the best .NET-teachers on here. Great stuff.
Just a friendly suggestion: Maybe put the link to your webpage in the description?
Done!
Thank you so much for making these videos, Shawn! I hope your channel grows exponentially and reaches more and more developers who are hungry for this kind of knowledge you are sharing.
Awesome video!!! Somehow, it always seems like your new videos are discussing exactly what me and my team have planned for our upcoming work. This was a great overview on this topic and has helped me understand it better and see the full big picture. Also, there is something about this video that feels extra great. It might be the editing, or just the great planning for this demonstration, but I love it. Keep it up!
Happy to help!
We did this several years ago on a complex project and it was great.
Not sure this is still the case, but using the SQL Server image that runs on Linux was way faster and took up 1/5th of the memory to run.
Great to revisit this. A few years back, I walked thru the equivalent of this (obviously your compose.yaml is far more concise than the raw docker run I was doing on the command line). At that time, Docker Desktop for Mac didn’t support non ARM and even platform distinction was in its infancy. So, the amd64 platform type was a non-starter for Apple M1. I conclude the official container is either published for ARM now or Rosetta2 is out of Beta and working. My work around was to use an Azure Database (which gave me MSSQL good enough for my tests) which did work (way back then) on ARM. Can’t wait to revisit this with your excellent stream-lined compose definition- Thanks! 🎉
Now to revisit trying out the equivalent on Oracle DB in a container 🤔
Keep us posted if you get this working in Oracle (though they've been running on Linux a lot longer than SQL Server)
The timing of this video is uncanny. I am literally setting up Windows 11 ARM on Parallels on my M3 macbook pro right now. I was starting to work through setting up a SQL container on my Mac to use with my Windows VM. Great video!
Glad I could help!
Super useful. Most of the search results showed manually creating the database on docker CLI and then adding that image to docker compose. I needed a way to start with barebones Microsoft image and pass all the parameters to create the image. This way I could always be on the latest version.
Request to do another video showing how to build a k8s cluster on the dev machine and how to map volumes in cloud environment, preferably Azure. And also how to attach existing database files if that's the right approach.
Once again thanks. Super useful.
I'm working on an Aspire of that story, but not sure i'm expert enough on kube to show this. But I'll add it to my list of topics.
Clear and useful, even on Windows. I didn't understand how to access your persistent sql-data folder with Windows explorer ?
He didn't show it. Basically, you need to find where the folder he specified with -name in the volume was created and it will be there. I am pretty sure there was an option to specify a path in which to create the folder (so you tell it where to create it instead of it's default location) which I'm not sure why he didn't show it here.
Yeah, I didn't show that, sorry. It depends on what OS you're on, but usually docker desktop's data in your user folder. If you look in Docker Desktop, look for volumes and can nagivate to the specific folder (when you setup volumes, you can also specify where the volume is):
imgur.com/a/hLbvDg6
@@swildermuth thanks for replying with more info!
Thanks
ran into some issue w/ my m3: (linux/amd64) does not match the detected host platform (linux/arm64/v8)
You can turn on docker's virtualization framework. See this answer: github.com/microsoft/mssql-docker/issues/668#issuecomment-1436802153
Hey 👋 ... Can I ask you , how could I install SQLserver in GitHub codespace ? ... Because in final step , I got an error about python!? ... Can you help me?
I don't use GitHub codespaces unfortunately. Are there different codespace profiles that you can use? I am not sure.
@swildermuth I wanna learn to use docker SQLserver and try it in codespace, because unfortunately it's only vps that I have to access for testing for free ... Other providers like azure and digital ocean exits for trial but all of them need credit card identification for access to them , and I don't have one , because of , i born in country that under sanctions.
Thank you for your reply 👋