Summary
In this module and throughout the activities, you learned how to deploy and configure Azure SQL. By learning about the predeployment planning guidance and best practices, you become more prepared going into the deployment of Azure SQL Database or Azure SQL Managed Instance. You also got hands on and learned about the deployment process through the Azure portal.
After deployment, you dove deeper into running verification checks and configuring Azure SQL to meet your scenario's requirements. Finally, you learned how loading data into Azure SQL is similar to the process for SQL Server, except you now have more options available.
After you've deployed and configured Azure SQL, you'll likely look to make sure it meets your security needs. In the next module, dive into the capabilities and tasks related to Azure SQL for securing your databases and instances.
Learn more
Video series: Azure SQL for beginners
People learn in different ways. With that in mind, a video series related to this learning path was created with Channel 9 on YouTube.
Predeployment planning and migration to Azure
To learn more about how to migrate to Azure SQL, review the Azure Database Migration Guide. It has custom guidance on how to migrate based on your source and target database. Also consider accessing the resources and support available through the Azure Migration and Modernization Program.
One part of predeployment planning is determining which service tier and size are best for your workload. The Data Migration Assistant tool has a SKU recommender that can help you determine the number of vCores and the size.
The hands-on exercises focused on Azure SQL Database. If you want to try out your new deployment and configuration toolbox in Azure SQL Managed Instance, see:
- Migrate to Azure SQL Managed Instance
- Quickstart: Create an Azure SQL Managed Instance
- Deploy Azure SQL Managed Instance to an instance pool
You can dive deeper into the resource limits based on service tier and configuration for SQL Managed Instance and SQL Database.
Deploy, verify, and configure
Two common command-line tools for deploying, verifying, and configuring Azure SQL are the Azure CLI and Azure PowerShell. You can also access both of these tools through Azure Cloud Shell, which is an integrated terminal that supports Bash and PowerShell in the Azure portal.
Data max size
For more information about the difference between data space used, data space allocated, and Data max size, see Manage file space for databases in Azure SQL Database.
Connectivity to Azure SQL
You can find more information on connectivity for Azure SQL Database and for Azure SQL Managed Instance. Upcoming sections and modules also cover connectivity.
Azure Marketplace terms
Similar to the Microsoft Software License Terms (EULA) for SQL Server, you must accept Azure Marketplace terms before you deploy Azure SQL.
Resource governance
Resource governance from the Azure side is something new to consider in Azure SQL. You can review how it works and read a blog post with more details.
Job management
To learn more about the differences between SQL Server Agent in SQL Server and in Azure SQL Managed Instance, see T-SQL differences between SQL Server and Azure SQL Managed Instance. To learn about elastic jobs for Azure SQL Database, see Create, configure, and manage elastic jobs.
Load data
For more information about using Azure Data Factory to load data into Azure SQL Managed Instance and SQL Database, see this documentation page. Also, here's a blog detailing how to use Spark to load efficiently into Azure SQL.