SQL Server / Advanced

SQL Server β€” Advanced

Connect workload evidence to resilient operations and application design.

6 lessons Β· No account required

What you will learn

  • Investigate performance and dependency incidents.
  • Plan recovery, availability, monitoring, and idempotent application access.

  1. Query Store and performance investigation

    Investigate a regression using history, workload impact, and controlled comparisons. Understand Query Store state, parameter sensitivity, and the limits of plan forcing.

    Start learning

  2. Deadlocks, waits, and incident evidence

    Distinguish a dependency cycle from ordinary waiting and timeouts. Interpret deadlock evidence, identify root causes, and design bounded transaction retries.

    Start learning

  3. Backups, restore chains, and recovery models

    Design recovery from a concrete loss scenario. Connect recovery models, full/differential/log backups, restore sequencing, and an isolated recovery drill.

    Start learning

  4. High availability and disaster recovery

    Compare SQL Server availability groups, failover cluster instances, and log shipping from failure scope and business objectives. Include clients and instance dependencies in the design.

    Start learning

  5. Operations, integrity, and observability

    Build a SQL Server operating routine that detects threats before users discover them. Connect capacity, backup age, integrity checks, jobs, waits, and controlled maintenance.

    Start learning

  6. Application access and resilient workflows

    Integrate SQL Server into a reliable application boundary. Combine typed commands, bounded pools, idempotency, optimistic edits, pagination, and transaction-aware failure handling.

    Start learning
Back to course