Taiob Ali: Azure SQL Database - Where is my SQL Agent?
Details
Join us on Thursday, Apr 30 for our second virtual meetup. We are combining forces with North Boston Azure user group: https://www.meetup.com/North-Boston-Azure-Cloud-User-Group/ to provide great virtual meetups with speakers from all over the world.
Featured talk: ": Azure SQL Database - Where is my SQL Agent?" by Data Platform MVP from the Boston area Taiob Ali.
## LOCATION
This event will be organized as a Live Event on Teams.
Attendees will be able to type their questions, but won't be able to use their mic or camera. We're currently experimenting with different formats, so we'll be waiting for your feedback after the event.
## AGENDA
6:00-6:10: Introduction, announcements
6:10-7:00: Featured talk and Q&A
## MAIN TALK
You migrate your on-premise SQL Database to cloud, taking advantage of the PaaS offering of Azure SQL Database. You heard the promise of spinning up databases on demand and being able to scale up resources during high peak and scale down when not in use. You also want to make sure you are performing integrity checks, index defragmentation, and statistics updates when necessary. There is no SQL Agent, so how do you automate your jobs? Do you have time to do this manually each time? No. There are different options available to automate these long-running, manual, error-prone, and frequently repeated tasks to increase reliability, efficiency.
In this demo intensive session, I will show you different options on how to automate these tasks. Some of these solutions use on-prem infrastructure and services in Azure, which are conveniently encapsulated within the collective Azure portal experience.
At the end of this session, you will have a solid understanding of how to automate SQL Server Maintenance tasks, including replacing SQL Agent functionality with multiple options.
## SPEAKER BIO
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.