Episode 12 of 15
For the full video series, click here: https://aka.ms/DP-300onYouTube
Learn about scripting repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration, automating error and resource alerts, and configuring notifications for failures. In the first lab, you’ll learn how to deploy an Azure SQL Database using an Azure Resource Manager (ARM) template. Discover how to automate deployments, ensure consistency, and streamline your infrastructure setup with ARM templates. Next, we’ll move on to a lab where you’ll learn how to monitor SQL Server performance by creating a CPU usage alert. We’ll guide you through setting up an alert that triggers when CPU usage exceeds 80%, helping you stay proactive and maintain optimal performance. Finally, we’ll walk through a lab where you’ll learn how to automate database maintenance by deploying an Azure Automation runbook to rebuild indexes. We’ll guide you through creating an Automation account, connecting to Azure SQL Database, configuring assets, writing a PowerShell runbook, and scheduling it for hands-free optimization.
Learn more about this course and take the certification exam to test your new skills: https://aka.ms/DP-300onLearn
Chapters
00:00 Video start
00:13 Automate database tasks for Azure SQL
01:01 Automate database deployment
01:14 Objectives
18:47 Knowledge check
19:25 Demo: Deploy an Azure SQL Database using an Azure Resource Manager template
30:22 Create and manage SQL Agent Jobs
30:36 Objectives
41:27 Knowledge check
42:04 Demo: Create a CPU status alert for a SQL Server
50:05 Manage Azure PaaS tasks by using automation
50:35 Objectives
1:03:36 Knowledge check
1:04:20 Demo: Deploy an automation runbook to automatically rebuild indexes
01:25:14 Learning Path Recap
