Azure Automation: Your SQL Agent in the Cloud
This is a session about Azure Automation service and how you can perform some of SQL Agent functionality against Azure SQL Database using runbook. I presented the session to following user groups and events.
- PASS DBA Virtual Chapter (Asia Pacific Region) on November 15, 2017
- PASS DBA Virtual Chapter on February 28, 2018
- Boston Azure DataFest on March 01, 2018
You want to migrate your on-premise SQL Database to cloud, taking advantage of PaaS offering of Azure SQL Database. Soon you recognize the SQL Agent is not available. You heard the promise of spinning up databases on demand and turn off/dial down when not in use. Do you have time to do this manually each time? Especially on the weekend. Azure Automation comes to rescue. Azure Automation is an Azure service for simplifying cloud management. 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.
In this demo intensive session, I will show you how to setup Azure Automation. I will walk you through a runbook (a compilation of routine procedures and operations), execute the runbook on demand and show how to schedule the same. At the end of this session you will have solid understanding about how to automate Azure services including replacing SQL Agent functionality using Azure automation, and conveniently encapsulate within the common Azure portal experience.
If you have any question regarding this presentation please feel free to send me a note.