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