Creating Your Own Secure Sample Database - Azure SQL DB

In this video, Manuel, walks through the process of creating a secure and inexpensive sample database in Azure SQL Database. This guide is ideal for users looking to stand up a quick and easy database for personal demos or practice, without the complexity of a full production environment. The focus is on setting up a secure, low-cost Azure SQL Server and attaching the AdventureWorksLT sample database.

Overview of the Process

Manuel starts by explaining the benefits of setting up a personal sample database, which allows users to experiment and practice without relying on external resources. He emphasizes the affordability and ease of use, demonstrating how to create a sample database for as little as $5 a month.

Steps to Create a Sample Database

To create a secure and low-cost sample database in Azure, follow these steps:

1. Create a resource group in Azure, which acts as an organizational container for all your resources.
2. Provision a logical Azure SQL Server within this resource group. A logical server has no direct cost and is isolated from external access by default for security purposes.
3. Configure authentication for the server. Manuel recommends using Microsoft Entra (formerly Azure Active Directory) authentication for added security. However, SQL authentication can also be configured for broader access.
4. Enable access for Azure services to interact with the SQL Server if you plan to connect with other Azure tools like Azure Data Factory.
5. Create a sample database, such as AdventureWorksLT, by selecting the "Create Database" option. Manuel chooses a low-cost basic option, which provides 2 GB of storage and sufficient computing power for small-scale demos.

Security Considerations

By default, the newly created server is locked down and inaccessible from external IP addresses. Manuel demonstrates how to add your IP address to the firewall rules so you can connect to the database using tools like SQL Server Management Studio (SSMS). He explains how to find your IP address and add it to the server’s whitelist for secure access.

Additional Features and Expanding Your Database

Manuel also covers advanced options, including how to migrate existing databases from on-premise SQL servers to Azure SQL Database using the Data Migration Assistant or by uploading a .bacpac file. This allows users to extend the sample database or import other datasets for further exploration.

Conclusion

Setting up a secure sample database in Azure SQL Database is quick, affordable, and flexible, making it an ideal solution for personal demos and practice. Manuel provides clear guidance on configuring the server, securing access, and expanding the database as needed.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Azure and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.