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.
Taiob Ali, an accomplished technical leader with proven record of success. His experience includes three major business sectors: financial industry, e-commerce and healthcare. He is a Microsoft and MongoDB certified Data professional with over 11 years of IT experience both on premise and cloud. Hands on experience in managing large database projects including large data migration, complex process design, testing and deployment, performance tuning, long term capacity planning.
Taiob is currently working at “GMO LLC” as a DBA lead. Focusing on automation, improving and streamlining operational workflow, plan and prepare for cloud migration. He is a regular speaker at user groups and SQL Saturday events.