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.

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:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#PragmaticWorks