SQL Development Made Easy with Docker - Install SQL in 5 minutes or less!

Поделиться
HTML-код
  • Опубликовано: 29 июл 2024
  • C# and Microsoft SQL were made for each other. Where you find one, you often find the other. However, as a developer, getting a full copy of SQL Server on your development machine can be tricky. Or at least, that used to be the case.
    In this video, I am going to show you how to get SQL up and running on your development machine in about five minutes using Docker.
    But we aren't going to stop there. Maybe you have SQL backups running either personally or at your company. How do you know they work? The only way you can be sure they work is to test them.
    We will create an automated script to install SQL, restore the backup, and even sanitize the data if desired.
    With these tools, you can make working with SQL Server quick, simple, and automated. I bet those aren't words you normally associate with SQL Server.
    Getting Started with Docker course: www.iamtimcorey.com/p/getting...
    Video Resources: 1drv.ms/u/s!At1NLb9LVKy4iIYmy...
    Newsletter signup (with exclusive discounts, giveaways, and more): signup.iamtimcorey.com/
    Thanks to Ralfs HBK for the timestamps:
    0:00 - Intro
    1:49 - Prerequisites
    4:04 - SQL server setup: PowerShell command line explained
    10:57 - SQL server: connecting, running, stopping. deleting containers
    19:57 - Data Base restore: creating the dockerfile
    35:11 - Data Base restore: using the dockerfile
    39:27 - Data Base restore: running the image built form the dockerfile
    41:01 - Production Data Base copy: downsides
    42:51 - Production Data Base copy: protecting sensitive data
    47:37 - Production Data Base copy: creating and running the image
    53:14 - Summary and concluding remarks

Комментарии • 249