The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Sign in to Subscribe

Azure Automation: Your SQL Agent in the Cloud

Thu, Nov 16 2017 01:30 UTC

Azure Automation: Your SQL Agent in the Cloud

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

Taiob Ali, MVP Data Platform, is an accomplished technical leader with a proven record of success. For 14 years, he has worked with the Microsoft Data Platform and MongoDB both on-premise and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects, massive data migration, intricate process design, testing and deployment, performance tuning, long term capacity planning. Taiob is currently working at “GMO LLC” as a Database Solution Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual PASS chapters, SQL Saturdays, and Azure conferences.

Interested in Presenting at the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to DBA VG Leadership Team.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact DBA VG Leadership Team, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to DBA VG Leadership Team.


Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Back to Top