Coding Shorts

Those of us who is use SQL Server, often rely on local db to handle local development. But since our teams are getting more and more OS diverse, we needed to have a way to run the same .NET code on the Mac and Linux. That's where the SQL Server Container can help. Let me show you.
00:00 Start
01:34 The Problem
02:38 Using Docker Compose
05:28 Understanding Volumes
07:25 Updating the new SQL Server
07:52 Using SQL Server Authentication
08:17 Looking at the Data
08:57 Shutting down the Server
09:31 Wrapping Up
For more information about my training and coaching, visit:
- wildermuth.com
If you like this video, you might like other videos in my Instructional Videos:
- • Instructional Videos

[@Simon-th6jj]

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

[@hemant-sathe]

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.

[@swildermuth]

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.

[@FortranCastle]

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.

[@larrye]

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.

[@LUNTE1337]

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?

[@swildermuth]

Done!

[@Octopie18]

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!

[@BrianHallmanac]

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!

[@swildermuth]

Glad I could help!

[@olivier0003]

Clear and useful, even on Windows. I didn't understand how to access your persistent sql-data folder with Windows explorer ?

[@vr77323]

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.

[@swildermuth]

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

[@vr77323]

@@swildermuth thanks for replying with more info!

[@paulh6933]

ran into some issue w/ my m3: (linux/amd64) does not match the detected host platform (linux/arm64/v8)

[@rd_45]

Thanks