Shawn Wildermuth
Shawn Wildermuth
  • 267
  • 767 297
Coding Shorts #102: Using SQL Server Containers for Dev
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:
- ua-cam.com/play/PLtOvnDRdH12e3vOq4zvpI2cKsancIwMcP.html
Переглядів: 2 075

Відео

Coding Shorts #101: Getting More Out of Your ASP.NET Core HealthChecks
Переглядів 1,3 тис.14 днів тому
I've been delving into HealthChecks lately (as evidenced by my recent blog post on wildermuth.com. In this video I show you how to use different types of health checks as well as how to write your own! For more HealthChecks from the Open Source community, check out: github.com/Xabaril/AspNetCore.Diagnostics.HealthChecks?tab=readme-ov-file#health-checks 00:00 Introduction 00:53 Adding the Defaul...
Coding Shorts: 100 & More
Переглядів 66214 днів тому
Thanks for sticking with me for 100 Coding Short videos!
Coding Shorts: Making Sense of Stack vs. Heap
Переглядів 1,6 тис.21 день тому
This is a different kind of video that I usually make. The topic of how memory is handled in a variety of languages is a key concept every developer should have a handle on. In this quick tutorial, I try and explain how it works. Take a look! If you like this video, you might like other videos in my Instructional Videos: - ua-cam.com/play/PLtOvnDRdH12e3vOq4zvpI2cKsancIwMcP.html
Coding Shorts: C# Dialects and Idioms
Переглядів 3,1 тис.28 днів тому
I had a conversation recently with Jeremy Clark about C# and how different developers see the language differently. That's had me thinking for a couple of months about this. Let's walk through a history lesson in C# and talk about dialects and idioms: 00:00 Introduction 01:27 C# 1 06:25 C# 2 08:06 C# 3 10:09 C# 7.3 (.NET Framework) 12:38 C# 8 (.NET Core) 14:32 C# 9 15:23 C# 13 (Latest) 17:01 Wr...
Coding Shorts: Running Async Jobs in ASP.NET Core
Переглядів 3,8 тис.Місяць тому
I recently needed to run long task in the background in ASP.NET Core. For our particular need, we couldn't do this in a distributed fashion (e.g. fire up a bus and a project to monitor the bus and accomplish the task). Instead, I found a great library for firing asynchronous jobs off. Let me show you how it works! 00:00 Introduction 01:08 Getting Started 02:10 Introducing Quartz.ASPNETCore 02:3...
Coding Shorts: Ahead-of-Time Compilation in C# (AOT)
Переглядів 1,6 тис.Місяць тому
I've been looking at Source Generators as a solution to reflection. This is important for AOT compilation. So, I thought it might be useful to see what AOT is all about: 00:00 Introduciton 00:37 Compiling C# 01:30 Using ILSpy 02:19 Viewing IL 03:59 Self Contained Compilation 05:22 Publishing in AOT 06:51 AOT Results 09:05 Wrapping It Up Project Repo: github.com/shawnwildermuth/codingshorts/tree...
Coding Shorts: .NET Aspire - Using OpenTelemetry
Переглядів 1,2 тис.Місяць тому
You ready to learn .NET Aspire? My workshop is coming June 12th: shawnl.ink/day-of-aspire Use the coupon code: DAYOFASPIRE for 20% off While I covered telemetry in an earlier episode (ua-cam.com/video/0gdf9_CwyG8/v-deo.html), I wanted to show how you can use it in .NET Aspire too. For development, the Dashboard will allow you to monitor your application with metrics and tracing! See how I do it...
Micro Coding Short: Simple Status Results in Minimal APIs
Переглядів 618Місяць тому
This is my first UA-cam short where I'm calling "Micro Coding Short" - Instead of the usual 10-15 minutes, these are around one minute. Let me know if you like these
Man Enough to Heal (2024) 30 Second Spot
Переглядів 30 тис.2 місяці тому
In this feature-length documentary, we will tell the stories of men who are healing from the scars of childhood sexual abuse. While the statistics are horrifying for both sexes, the media and society seem to treat boy victims different from girl victims and this film will shine a light on the disparity. Lives full of shame, lack of self-worth and body dysmorphia as well as an often-continual fi...
Man Enough to Heal (2024) Full Trailer
Переглядів 1842 місяці тому
Coming May 31st to iTunes, Amazon and UA-cam. In this feature-length documentary, we will tell the stories of men who are healing from the scars of childhood sexual abuse. While the statistics are horrifying for both sexes, the media and society seem to treat boy victims different from girl victims and this film will shine a light on the disparity. Lives full of shame, lack of self-worth and bo...
Coding Shorts: Methods, Funcs & Actions...Oh, My!
Переглядів 2,2 тис.2 місяці тому
You ready to learn .NET Aspire? My workshop is coming June 12th: shawnl.ink/day-of-aspire C# doesn't have explicitly first-class functions. But methods and wrappers help you get close. Let me show you how that works! 00:00 Introduction 00:38 Getting Started 01:34 Using Methods 02:35 Using Func 04:39 Using Action 07:01 Static vs. Instance Methods 08:12 Method Expression Syntax 09:09 Waxing Poeti...
Coding Shorts: .NET Aspire - Databases
Переглядів 3 тис.2 місяці тому
You ready to learn .NET Aspire? My workshop is coming June 12th: shawnl.ink/day-of-aspire Now that I covered the hosting in Aspire, let's talk about using Databases in your Aspire application. Let me show you how that works! 00:00 Introduction 00:31 Getting Started 01:26 Sharing Environment Variables 02:43 Sharing Connection Strings 03:53 Connection String Resouces 04:43 Using Containers 07:46 ...
Coding Shorts: .NET Aspire - The Host
Переглядів 2,2 тис.2 місяці тому
A lot of demos of .NET Aspire have been made, but I wasn't getting it until I stripped it bare. The host project is really interesting and I think it makes sense now. Let me show you how that works! 00:00 Introduction 00:47 The Project 02:23 Adding the Host 03:56 Adding a Project 04:38 The Dashboard 05:36 Adding a Node App 07:42 Using References 07:59 Using Environment Variables 12:22 Wrapping ...
Coding Shorts: Sharing Variables in .http Files
Переглядів 1,3 тис.2 місяці тому
Coding Shorts: Sharing Variables in .http Files
Coding Shorts: Use Open Telemetry in ASP.NET Core
Переглядів 3,9 тис.3 місяці тому
Coding Shorts: Use Open Telemetry in ASP.NET Core
Coding Shorts: .NET Core CLI Tips and Tricks
Переглядів 1,9 тис.3 місяці тому
Coding Shorts: .NET Core CLI Tips and Tricks
Coding Shorts: DaisyUI
Переглядів 1,1 тис.3 місяці тому
Coding Shorts: DaisyUI
Coding Shorts: Nuxt without Nuxt - Components and Imports
Переглядів 2683 місяці тому
Coding Shorts: Nuxt without Nuxt - Components and Imports
Coding Shorts: Using Azure Entra ID to Protect Your APIs
Переглядів 2,3 тис.3 місяці тому
Coding Shorts: Using Azure Entra ID to Protect Your APIs
Coding Shorts: C# Type Inference or, How I Learned to Love 'var'
Переглядів 1,2 тис.4 місяці тому
Coding Shorts: C# Type Inference or, How I Learned to Love 'var'
Coding Shorts: Nuxt without Nuxt - Paged Based Routing and Layouts
Переглядів 3214 місяці тому
Coding Shorts: Nuxt without Nuxt - Paged Based Routing and Layouts
Coding Shorts: Adding HTTP Cache Headers to Your ASP.NET Core Project
Переглядів 1,2 тис.4 місяці тому
Coding Shorts: Adding HTTP Cache Headers to Your ASP.NET Core Project
Coding Shorts: Nuxt without Nuxt - Routing
Переглядів 3585 місяців тому
Coding Shorts: Nuxt without Nuxt - Routing
Coding Shorts: Bulk Updating and Deleting with Entity Framework Core
Переглядів 1,4 тис.5 місяців тому
Coding Shorts: Bulk Updating and Deleting with Entity Framework Core
Coding Shorts: Custom Property Validation with FluentValidation
Переглядів 1,7 тис.5 місяців тому
Coding Shorts: Custom Property Validation with FluentValidation
Coding Shorts: Entity Framework Core 8: Improve Your Query Performance with SQL
Переглядів 3,2 тис.6 місяців тому
Coding Shorts: Entity Framework Core 8: Improve Your Query Performance with SQL
Coding Live: Building SightReadCode.com - Dec 2, 2023 - edited
Переглядів 4977 місяців тому
Coding Live: Building SightReadCode.com - Dec 2, 2023 - edited
Coding Shorts: Bun.js on WSL - It's Pretty Good!
Переглядів 1,2 тис.7 місяців тому
Coding Shorts: Bun.js on WSL - It's Pretty Good!
Coding Shorts: ASP.NET 8 - New Exception handling
Переглядів 15 тис.7 місяців тому
Coding Shorts: ASP.NET 8 - New Exception handling

КОМЕНТАРІ

  • @briannewman9285
    @briannewman9285 День тому

    Respectfully, I'd like you to not move the cursor around randomly when showing a page. It makes it difficult for people with ADHD to focus on what you're saying when you are distracting them. I realize that moving the cursor around randomly is a common practice as if to say "here, look at this." It is better to move the cursor to a specific location only when there is something specific at that location to pay attention to. Thank you for listening and for a generally great video.

    • @swildermuth
      @swildermuth 21 годину тому

      This has been a problem I have for years now. It's a nervous habit. I'll try, but I can't guarantee I can stop.

  • @Will-uk8se
    @Will-uk8se 2 дні тому

    Thanks for the helpful video. When I attempt to upgrade the controllers, the drop down menu where controllers should appear is empty. Same for classes. Do you have any idea what could be causing this issue?

  • @paulh6933
    @paulh6933 2 дні тому

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

  • @sarthakchauhan4163
    @sarthakchauhan4163 4 дні тому

    Your hairs got cut from thumbnail to actual video 😅 Nice video btw

    • @swildermuth
      @swildermuth 4 дні тому

      It's there, just in a pony tail.

  • @sanglin9387
    @sanglin9387 4 дні тому

    my opinion no unit test junk , integeration test

  • @Simon-th6jj
    @Simon-th6jj 5 днів тому

    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

  • @olivier0003
    @olivier0003 6 днів тому

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

    • @vr77323
      @vr77323 6 днів тому

      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
      @swildermuth 6 днів тому

      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
      @vr77323 5 днів тому

      @@swildermuth thanks for replying with more info!

  • @hemant-sathe
    @hemant-sathe 6 днів тому

    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
      @swildermuth 6 днів тому

      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.

  • @BrianHallmanac
    @BrianHallmanac 7 днів тому

    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!

  • @Octopie18
    @Octopie18 7 днів тому

    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!

  • @LUNTE1337
    @LUNTE1337 7 днів тому

    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?

  • @rd_45
    @rd_45 7 днів тому

    Thanks

  • @FortranCastle
    @FortranCastle 7 днів тому

    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
    @larrye 7 днів тому

    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.

  • @aron-gx9mh
    @aron-gx9mh 8 днів тому

    i understand all this but how do i add this to my project? i want to run a website that gets data from an Api. unfortunately, this didn't help me

  • @vitalina1807
    @vitalina1807 8 днів тому

    Helo, can you help me please? i use Typescript, and in Main.tsx : import React from 'react' import ReactDOM from 'react-dom/client' import App from './App.tsx' import './index.css' ReactDOM.createRoot(document.getElementById('root')!).render( <React.StrictMode> <App /> </React.StrictMode>, ) how i can have "id=app"?

  • @AceSyntaxx
    @AceSyntaxx 8 днів тому

    Thanks Shawn for a succinct explanation of the basics.

  • @reallifegambits
    @reallifegambits 9 днів тому

    Awesome video. So in one of my project I am using Microsoft.ApplicationInsights.AspNetCore to connect with Azure Application Insights with method AddApplicationInsightsTelemetry() with instrumentation key. At end of your video, were you suggesting to migrate to opentelemetry because application insights is getting depricated? If yes, can you point me to any official doc?

  • @ChrisBrandsma
    @ChrisBrandsma 11 днів тому

    Just to add, be sure to do code reviews after you add this endpoint. I built and api, added health checks, and then a couple frontend developers decided that absolutely HAD to call the healthcheck before every single call they made to my api.

  • @mohamedbalighhamdi1931
    @mohamedbalighhamdi1931 13 днів тому

    Great work shawn. It is may be useful to mention that the same github repository exposes another package called health check UI. A website will be hosted along with the web api, summarising the state of the configured health checks. An extra work is to be done too on the site css to match the solution’s web design requirements. I do this extra to all my clients requiring a health check and they are generally happy to see this visual representation of what is exposes by the readiness endpoint.

  • @willembeltman
    @willembeltman 13 днів тому

    I love how we end up writing more code in order to safe writing code. There is a good reason why you should create a new class for the result: It allows you find out you are writing a lot of the same classes.

    • @swildermuth
      @swildermuth 13 днів тому

      But does it need to be a 'class'? I find this issue where everyone wants to think everything is a class in C#. Could be a struct, a tuple, a record. Data structures matter.

  • @oh-digital
    @oh-digital 13 днів тому

    Thanks Shawn, i've been googling how to do this and was thinking I might have to learn Svelte until i found your video. How would you keep the store scoped to each instance? We are doing an event feed that is going to be embedded on external websites and there may be multiple instances on the same page, so filtering would need to be kept separate

    • @swildermuth
      @swildermuth 13 днів тому

      Each component should be isolated, you have to do extra work to share usually.

  • @event-sourcing
    @event-sourcing 13 днів тому

    Another great, useful video. The redesigned site looks good!

  • @syedhoque9057
    @syedhoque9057 14 днів тому

    For next one, blast that IDE font size up

  • @ehvlullo
    @ehvlullo 14 днів тому

    Thanks. The website redesign looks great. A few times already now some of your articles have been a great help for some specific issues I was running into.

  • @EricOnYouTube
    @EricOnYouTube 14 днів тому

    I am still very new to your channel. Do you provide this as a download or a github link? I'd like to read this on my own time. Just wondering. Thanks! :)

    • @swildermuth
      @swildermuth 13 днів тому

      Forgot to include it this time. I'll add it to the description. Give me 30 minutes.

    • @EricOnYouTube
      @EricOnYouTube 12 днів тому

      @@swildermuth Thank you very much. :)

  • @ahjsbkdjhavkcjhvac
    @ahjsbkdjhavkcjhvac 14 днів тому

    amazing video! very insightful! I think you deserve more recognition!

  • @saefulrahman3478
    @saefulrahman3478 14 днів тому

    thanks shawn,

  • @user-mp2vx3ss1c
    @user-mp2vx3ss1c 14 днів тому

    Keep doing what you're doing, Shawn!

  • @_rcs
    @_rcs 15 днів тому

    Thanks for putting this useful knowledge out here for free.

  • @rogerpence
    @rogerpence 15 днів тому

    Keep at it Shawn. Your videos and knowledge are very much appreciated.

  • @n8wrl
    @n8wrl 15 днів тому

    Love the content, thank you! I'm a retired developer and still like to keep up with personal projects. I'm also an amateur radio op so I build a lot of tools related to controlling radios, antenna switches, databases, etc. Anyway, I have several older WinForms apps I'd like to "modernize" and am very confused by the landscape - and /Build wasn't much help. There is a new version of WinForms coming with .NET 9, WinUI3 is supposedly the new-hotness but it seems to be missing a lot of controls. In fact, I've seen videos from Microsot pushing WinUI3 and WPF at the same time. Do you have any insight into where this is going? What is the "UI of choice" for desktop development? The last 20 years of my career were all web developmnet. I really don't want to do that again with Blazor. Thanks for all you do!

    • @swildermuth
      @swildermuth 15 днів тому

      Both are xaml based, so you can't go wrong with either. But if you already know webdev, you might consider PWAs

  • @hozmannew896
    @hozmannew896 15 днів тому

    thank you for all what you learned me and still.

  • @antondoit
    @antondoit 15 днів тому

    Thanks

  • @olivier0003
    @olivier0003 15 днів тому

    Good work

  • @montana3426
    @montana3426 15 днів тому

    Thanks Shawn!

  • @rollthers3157
    @rollthers3157 16 днів тому

    Keep 'em coming!

  • @kstddrd
    @kstddrd 16 днів тому

    Thank you for your good work.

  • @tifactlong7431
    @tifactlong7431 18 днів тому

    That's a great tutorial. Short and straight forward no wasting time

  • @aaqilansari5702
    @aaqilansari5702 18 днів тому

    Shawn, everything works fine except for the identity default api endpoints which are protected e.g. manage/info doesn’t work with the bearer token and it works only with the generated cookie. Login endpoint is working fine. But once we are logged in and get the bearer token then all the identity api endpoints should be accessible with that bearer token. But the protected ones aren’t working. Any suggestions how to get it working with that bearer token and not the cookies which are http only tokens

  • @michaeIbonq
    @michaeIbonq 20 днів тому

    thank you so much!!!

  • @anascimento
    @anascimento 20 днів тому

    Thank you so much for this content, it helped me a lot. Regards from Brazil.

  • @kinsondigital
    @kinsondigital 20 днів тому

    Great explanation!! Love it!

  • @thygrrr
    @thygrrr 20 днів тому

    Lol, historical refactoring / back porting to various dialects? Super nerd content. I love it.

  • @RobertSagoe
    @RobertSagoe 21 день тому

    Your explanation is clear and concise, making the process easy to understand. Thank you for the details and excellent graphical explanation .. really helpful

  • @theAutomaTom
    @theAutomaTom 21 день тому

    Thanks for this part of the chat! I would love to hear more about how the Asp project must be acting as the pwa's server. It's got me a little stumped, and the plugin's deploy docs don't include .Net. You are the best! 👉👉💯

  • @nickguerra8460
    @nickguerra8460 22 дні тому

    Nice explanation. It helped clarify a few things. Thank you for your efforts!

  • @otrieZ
    @otrieZ 22 дні тому

    This is really useful thanks!

  • @LUNTE1337
    @LUNTE1337 22 дні тому

    Excellent explanation and visualization!

  • @adsfaedaer
    @adsfaedaer 22 дні тому

    when the stack pops what happens to a struct - which is a value type - that contains a string. is the string immediately culled (because the struct has been cleaned up) or does it wait around for the GC? - also how many pancakes where consumed after you did this ?

    • @swildermuth
      @swildermuth 22 дні тому

      any reference types that the struct is holding on to will be released to the GC but not disappear immediately. The Struct is a value type but it doesn't promote members of the struct to value types, remember the reference types in the struct are just the addresses of the reference types in the heap. Does that make sense?

    • @heavypeki
      @heavypeki 21 день тому

      @@swildermuth Perfectly makes sense. Struct in itself is a value type, but isn't responsible for its own members which could be address pointer.