Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Discover how to quickly set up and utilize SQL-on-Linux containers in Docker with this informative 57-minute conference talk from PASS Data Community Summit. Learn to create and manage SQL Servers using just 5 lines of PowerShell code and Docker, enabling rapid deployment for development and testing environments. Explore the basics of containers, their application to SQL Server, and how they support QA and Dev workflows. Follow along with hands-on demonstrations covering Azure Data Studio, PowerShell Notebooks, container building, database management, and monitoring techniques. Gain practical knowledge to streamline your SQL Server development process and leverage the power of containerization in your projects.
Syllabus
Intro
Disclaimer
PowerShell Virtual Group
Bio
Azure Data Studio
Notebooks
Lets start
Get Azure Data Studio
Demos
Open folder
How to build containers with 5 lines of code
PowerShell Notebooks
Prerequisites
Redownload
Create docker run
Verify SQL connection
Moving database
Copying database to container
Restore database
Test container
Invoke Notebook
Trusting Containers
Destroying Containers
Monitoring Containers
Additional Info
Taught by
PASS Data Community Summit