Managing Azure SQL databases using Azure Automation
This guide will introduce you to the Azure Automation service, and how it can be used to simplify management of your Azure SQL databases.
What is Azure Automation?
Azure Automation is an Azure service for simplifying cloud management through process automation. Using Azure Automation, long-running, manual, error-prone, and frequently repeated tasks can be automated to increase reliability, efficiency, and time to value for your organization.
Azure Automation provides a workflow execution engine with high reliability and high availability, and that scales to meet your needs as your organization grows. In Azure Automation, processes can be kicked off manually, by third-party systems, or at scheduled intervals so that tasks happen exactly when needed.
Lower operational overhead and free up IT / DevOps staff to focus on work that adds business value by moving your cloud management tasks to be run automatically by Azure Automation.
How can Azure Automation help manage Azure SQL databases?
Azure SQL Database can be managed in Azure Automation by using the Azure SQL Database PowerShell cmdlets that are available in the Azure PowerShell tools. Azure Automation has these Azure SQL Database PowerShell cmdlets available out of the box, so that you can perform all of your SQL DB management tasks within the service. You can also pair these cmdlets in Azure Automation with the cmdlets for other Azure services, to automate complex tasks across Azure services and across third-party systems.
Azure Automation also has the ability to communicate with SQL servers directly, by issuing SQL commands using PowerShell.
The Azure Automation runbook gallery contains a variety of product team and community runbooks to get started automating management of Azure SQL databases, other Azure services, and third-party systems. Gallery runbooks include:
- Run SQL queries against a SQL Server database
- Vertically scale (up or down) an Azure SQL Database on a schedule
- Truncate a SQL table if its database approaches its maximum size
- Index tables in an Azure SQL Database if they are highly fragmented
Now that you've learned the basics of Azure Automation and how it can be used to manage Azure SQL databases, follow these links to learn more about Azure Automation.