Troubleshooting SQL Database Errors

Troubleshooting SQL Database Errors

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Overview/Description
Techniques can be used to troubleshoot, diagnose, and prevent SQL connection issues. Topics such as logging, troubleshooting, and resolving conflicts are covered in this course, which aligns with exam 70-473.

Target Audience
Database professionals interested in working with hybrid/cloud solutions and individuals who are preparing to take the 70-473 exam

Prerequisites
None

Expected Duration (hours)
1.1

Lesson Objectives

Troubleshooting SQL Database Errors

start the course

enable metrics and diagnostics logging using the Azure portal

stream metrics and diagnostic logs into Log Analytics

stream metrics and diagnostic logs into Event Hub

stream metrics and diagnostic logs into Azure Storage

troubleshoot transient errors

troubleshoot persistent errors

recognize common database connection errors

recognize common database copy errors

recognize common resource governance errors

describe common errors related to creating and using elastics pools

describe common errors that can be encountered when using SQL databases

troubleshoot SQL database issues

Course Number:
cl_dicp_a12_it_enus

Expertise Level
Expert