SQL performance issues can be crippling to an application. That's why knowing how to properly troubleshoot queries and manage logging and alerting is crucial to administering an Azure SQL database. Azure provides a rich feature set for observing and alerting on performance on SQL. It also allows cloud engineers and developers to quickly scale up SQL environments with the push of a few buttons.
In this lab, you will explore optimizing a SQL query, scale a SQL Database, and configure logging and alerts for Azure SQL.
Upon completion of this Lab you will be able to:
This lab is intended for:
You should possess:
The following content is sufficient to fulfill these prerequisites:
Luke is a Site Reliability Engineer at Microsoft. His background is infrastructure development using Terraform and in 2021 he was awarded the HashiCorp Ambassador award. He is an Azure DevOps Engineer Expert, Azure Administrator Associate, and HashiCorp Certified - Terraform Associate.