Creating Your Own Secure Sample Database - Azure SQL DB

In this video, we guide you through the process of creating your own secure sample database using Azure SQL Database. Learn how to quickly set up a logical Azure SQL Server and attach a sample AdventureWorks LT database to it. We'll also cover key steps in configuring security, managing access, and how to ensure your setup is cost-effective—perfect for demo and sample usage. Whether you're new to Azure or looking to enhance your understanding, this video will help you establish a solid foundation for your own Azure SQL environments. Stay till the end for additional tips on expanding your setup and utilizing Azure services effectively.

👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt

👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit https://prag.works/MANUEL40 for 40% off On-Demand Learning!

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

0:00 - Introduction to Secure Sample Databases
00:51 - Setting Up Azure SQL Server and Database
02:54 - Creating a Resource Group and SQL Server
05:24 - Configuring Authentication and Security
08:07 - Adding a Sample AdventureWorks Database
10:43 - Choosing Compute, Storage, and Network Settings
14:13 - Connecting to SQL Server via SSMS
17:01 - Managing Firewall Rules and IP Access
19:52 - Migrating Local Databases to Azure
22:10 - Final Thoughts and Cost Management

Let's connect:

✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks

Видео Creating Your Own Secure Sample Database - Azure SQL DB канала Pragmatic Works