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 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 Azure Innovate & Azure Migrate and Modernize.
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:
- What is Azure Database Migration Service?
- Quickstart: Create an Azure SQL Managed Instance
- Create an instance pool (preview) - Azure SQL Managed Instance
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.
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 Copy and transform data using Azure Data Factory or Import a bacpac file to a database in Azure SQL Database or Azure SQL Managed Instance.
Clean up your resources
You created resources in your Azure subscription as part of this exercise. If you leave them running, they can cost you money. To remove the resources you created, you can just delete the resource group you created at in this module's first exercise. Go to the resource group in the Azure portal and select Delete resource group in the toolbar at the top of the Overview page. Enter the resource group's name to confirm deletion, select Delete, then select Delete again to delete your resource group and its resources.