Curriculum planned

Stage 02 · Relational Databases

Microsoft SQL Server

A production-focused SQL Server curriculum covering T-SQL, storage engine internals, indexing, Query Store, intelligent query processing, security, backup/recovery, Availability Groups, replication, columnstore, in-memory OLTP, observability, and SQL Server 2025 capabilities.

25planned chapters
125reserved lesson paths
Intermediate → Advancedlearning level
Plannedcourse state
Coverage baselineSQL Server 2025 (17.x) baseline with current developer, security, HA, and AI/vector features

Course brief

From engine fundamentals to advanced production operations.

A production-focused SQL Server curriculum covering T-SQL, storage engine internals, indexing, Query Store, intelligent query processing, security, backup/recovery, Availability Groups, replication, columnstore, in-memory OLTP, observability, and SQL Server 2025 capabilities.

This syllabus deliberately separates conceptual foundations, hands-on SQL, engine internals, operational tooling, reliability, security, performance, and capstone work so future lesson generation can go deep without compressing advanced subjects into generic chapters.

By the end

You will be able to

  • Write production T-SQL and reason about storage, transactions, tempdb, indexes, and plans
  • Use Query Store, statistics, DMVs, wait analysis, and Extended Events for diagnosis
  • Design backup/PITR, Availability Groups, replication, and DR with explicit RPO/RTO
  • Apply SQL Server security, encryption, auditing, Agent automation, and integrity checks
  • Evaluate columnstore, In-Memory OLTP, vector/AI features, upgrades, and hybrid deployment choices

Complete planned syllabus

25 chapters · 125 lesson paths.

Every lesson path is reserved now but intentionally not linked until its lesson HTML is actually published. The sequence moves from foundations through internals, advanced features, administration, reliability, security, tuning, upgrades, and a production capstone.

01

Chapter 1

SQL Server Platform Foundations, Editions, Licensing Awareness, and Lab Setup

5 lessons
01
SQL Server Architecture, Database Engine Roles, Common Workloads, and Deployment ModelsPlanned lesson · reserved path Chapter01/Lesson1.html
Planned
02
Developer, Express, Standard, Enterprise, and Cloud-Aware Edition/Feature BoundariesPlanned lesson · reserved path Chapter01/Lesson2.html
Planned
03
SQL Server 2025 Platform Choices, Windows/Linux Support, Containers, and ToolingPlanned lesson · reserved path Chapter01/Lesson3.html
Planned
04
Install SQL Server and SSMS/Client Tools, Configure an Instance, and Verify ConnectivityPlanned lesson · reserved path Chapter01/Lesson4.html
Planned
05
Build a Reproducible Lab with Databases, Logins, Sample Data, Backups, and Safety RulesPlanned lesson · reserved path Chapter01/Lesson5.html
Planned
02

Chapter 2

Instance Architecture, Services, Configuration, Databases, and Files

5 lessons
01
SQL Server Services, Instances, Ports, Protocols, Endpoints, and Connection LifecyclePlanned lesson · reserved path Chapter02/Lesson1.html
Planned
02
System Databases: master, model, msdb, tempdb, and resource ResponsibilitiesPlanned lesson · reserved path Chapter02/Lesson2.html
Planned
03
Database Files, Filegroups, MDF/NDF/LDF, Autogrowth, Instant File Initialization, and LayoutPlanned lesson · reserved path Chapter02/Lesson3.html
Planned
04
sp_configure, Server Properties, Startup Parameters, Trace Flags, and Configuration GovernancePlanned lesson · reserved path Chapter02/Lesson4.html
Planned
05
Collations, Compatibility Levels, Database Options, Recovery Models, and Baseline SettingsPlanned lesson · reserved path Chapter02/Lesson5.html
Planned
03

Chapter 3

T-SQL Foundations, Data Types, NULL, Conversion, and Expressions

5 lessons
01
T-SQL Batch Semantics, GO, Variables, Expressions, NULL, and Three-Valued LogicPlanned lesson · reserved path Chapter03/Lesson1.html
Planned
02
Exact/Approximate Numerics, Strings, Unicode, Dates, Times, GUIDs, Binary, XML, and JSONPlanned lesson · reserved path Chapter03/Lesson2.html
Planned
03
Implicit vs Explicit Conversion, Data-Type Precedence, SARGability, and Conversion PitfallsPlanned lesson · reserved path Chapter03/Lesson3.html
Planned
04
CASE, COALESCE, NULLIF, TRY_CONVERT, String/Date Functions, and Error-Tolerant ParsingPlanned lesson · reserved path Chapter03/Lesson4.html
Planned
05
Design a Robust Domain Mapping Between Application Types and SQL Server TypesPlanned lesson · reserved path Chapter03/Lesson5.html
Planned
04

Chapter 4

Schema Design, Keys, Constraints, Sequences, and Temporal Features

5 lessons
01
Schemas, Ownership, Object Naming, and Security/Deployment BoundariesPlanned lesson · reserved path Chapter04/Lesson1.html
Planned
02
PRIMARY KEY, UNIQUE, FOREIGN KEY, CHECK, DEFAULT, and Constraint TrustPlanned lesson · reserved path Chapter04/Lesson2.html
Planned
03
IDENTITY, SEQUENCE, GUID Strategies, Ordered IDs, and Hot-Page ConsiderationsPlanned lesson · reserved path Chapter04/Lesson3.html
Planned
04
Computed Columns, Persisted Expressions, Indexability, and DeterminismPlanned lesson · reserved path Chapter04/Lesson4.html
Planned
05
System-Versioned Temporal Tables, History Retention, Temporal Queries, and Audit Use CasesPlanned lesson · reserved path Chapter04/Lesson5.html
Planned
05

Chapter 5

Core Querying: Joins, Subqueries, APPLY, CTEs, and Set Operations

5 lessons
01
SELECT Processing Order, Filtering, Ordering, TOP/OFFSET, and DeterminismPlanned lesson · reserved path Chapter05/Lesson1.html
Planned
02
INNER/OUTER/CROSS Joins, Cardinality, Join Predicates, and Duplicate MultiplicationPlanned lesson · reserved path Chapter05/Lesson2.html
Planned
03
Subqueries, EXISTS, IN, Correlation, Semi/Anti Join Patterns, and Scalar Subquery RisksPlanned lesson · reserved path Chapter05/Lesson3.html
Planned
04
CROSS/OUTER APPLY, Table-Valued Functions, and Lateral-Style Query PatternsPlanned lesson · reserved path Chapter05/Lesson4.html
Planned
05
CTEs, Recursive Queries, UNION/INTERSECT/EXCEPT, and Composable Query DesignPlanned lesson · reserved path Chapter05/Lesson5.html
Planned
06

Chapter 6

Advanced T-SQL: Windows, Aggregation, PIVOT, MERGE Alternatives, and JSON

5 lessons
01
Window Functions, Frames, Ranking, Running Totals, Gaps-and-Islands, and SessionizationPlanned lesson · reserved path Chapter06/Lesson1.html
Planned
02
GROUP BY, GROUPING SETS, ROLLUP, CUBE, and Advanced AggregationPlanned lesson · reserved path Chapter06/Lesson2.html
Planned
03
PIVOT/UNPIVOT vs Conditional Aggregation and Maintainable Cross-Tab ReportingPlanned lesson · reserved path Chapter06/Lesson3.html
Planned
04
INSERT/UPDATE/DELETE OUTPUT, UPSERT Patterns, MERGE Risk Awareness, and Concurrency SafetyPlanned lesson · reserved path Chapter06/Lesson4.html
Planned
05
JSON Functions, OPENJSON, JSON Construction, Indexing Strategies, and API WorkloadsPlanned lesson · reserved path Chapter06/Lesson5.html
Planned
07

Chapter 7

Transactions, Locking, Row Versioning, Isolation, and Deadlocks

5 lessons
01
Explicit/Implicit Transactions, XACT_STATE, TRY/CATCH, Savepoints, and Error SemanticsPlanned lesson · reserved path Chapter07/Lesson1.html
Planned
02
Lock Modes, Granularity, Intent Locks, Escalation, Key-Range Locks, and Metadata LocksPlanned lesson · reserved path Chapter07/Lesson2.html
Planned
03
READ COMMITTED, RCSI, SNAPSHOT, REPEATABLE READ, SERIALIZABLE, and AnomaliesPlanned lesson · reserved path Chapter07/Lesson3.html
Planned
04
Version Store, tempdb Impact, Long Transactions, and Snapshot CleanupPlanned lesson · reserved path Chapter07/Lesson4.html
Planned
05
Deadlock Graphs, Blocking Chains, Timeouts, Retry Policies, and Contention TestingPlanned lesson · reserved path Chapter07/Lesson5.html
Planned
08

Chapter 8

Storage Engine Internals: Pages, Extents, Heaps, B-Trees, and Transaction Log

5 lessons
01
8-KB Pages, Extents, Allocation Maps, IAM, PFS, GAM/SGAM, and File InternalsPlanned lesson · reserved path Chapter08/Lesson1.html
Planned
02
Heap Tables, RID Lookups, Forwarded Records, and Heap MaintenancePlanned lesson · reserved path Chapter08/Lesson2.html
Planned
03
Clustered Indexes, Nonclustered Indexes, Row Locators, and Page SplitsPlanned lesson · reserved path Chapter08/Lesson3.html
Planned
04
Transaction Log Records, VLFs, WAL Principles, Log Truncation, and RecoveryPlanned lesson · reserved path Chapter08/Lesson4.html
Planned
05
Ghost Records, Background Cleanup, Checkpoints, Recovery, and DBCC PAGE/IND ConceptsPlanned lesson · reserved path Chapter08/Lesson5.html
Planned
09

Chapter 9

Index Engineering: Rowstore, Filtered, Included, Computed, and Specialized Indexes

5 lessons
01
Clustered vs Nonclustered Design, Key Width, Selectivity, and Clustering-Key PropagationPlanned lesson · reserved path Chapter09/Lesson1.html
Planned
02
Composite Keys, Included Columns, Covering Queries, and Key Lookup TradeoffsPlanned lesson · reserved path Chapter09/Lesson2.html
Planned
03
Filtered Indexes, Computed-Column Indexes, Unique Indexes, and Constraint InteractionsPlanned lesson · reserved path Chapter09/Lesson3.html
Planned
04
XML, Spatial, Full-Text, and Vector-Oriented Indexing/Access ConceptsPlanned lesson · reserved path Chapter09/Lesson4.html
Planned
05
Index Usage/Operational Stats, Duplicate/Unused Indexes, Write Amplification, and Portfolio ReviewsPlanned lesson · reserved path Chapter09/Lesson5.html
Planned
10

Chapter 10

Query Optimizer, Cardinality Estimation, Plans, and Statistics

5 lessons
01
Parsing, Algebrizer, Optimization, Costing, Memo Search, and Plan CachingPlanned lesson · reserved path Chapter10/Lesson1.html
Planned
02
Estimated vs Actual Execution Plans, Operators, Properties, Warnings, and Runtime MetricsPlanned lesson · reserved path Chapter10/Lesson2.html
Planned
03
Statistics Histograms, Density, Auto Create/Update Stats, Incremental Stats, and SamplingPlanned lesson · reserved path Chapter10/Lesson3.html
Planned
04
Cardinality Estimator Behavior, Correlation, Parameter Sensitivity, and MisestimatesPlanned lesson · reserved path Chapter10/Lesson4.html
Planned
05
Plan Guides/Hints, USE HINT, Query Store Hints, and Responsible InterventionPlanned lesson · reserved path Chapter10/Lesson5.html
Planned
11

Chapter 11

Query Store, Parameter Sensitivity, and Intelligent Query Processing

5 lessons
01
Query Store Architecture, Capture Modes, Runtime Stats, Wait Stats, and StoragePlanned lesson · reserved path Chapter11/Lesson1.html
Planned
02
Plan Regression Detection, Plan Forcing, Query Store Hints, and Operational GovernancePlanned lesson · reserved path Chapter11/Lesson2.html
Planned
03
Parameter Sniffing, Parameter Sensitive Plan Optimization, RECOMPILE, and Dynamic SearchPlanned lesson · reserved path Chapter11/Lesson3.html
Planned
04
Memory Grant Feedback, Cardinality Feedback, Adaptive/Intelligent Processing FeaturesPlanned lesson · reserved path Chapter11/Lesson4.html
Planned
05
Build a Repeatable Workflow for Detecting, Explaining, and Correcting Plan RegressionsPlanned lesson · reserved path Chapter11/Lesson5.html
Planned
12

Chapter 12

tempdb, Memory Grants, Spills, Sorts, Hashes, and Workspace Performance

5 lessons
01
Tempdb Architecture, Metadata, Files, Allocation Contention, and Version StorePlanned lesson · reserved path Chapter12/Lesson1.html
Planned
02
Temporary Tables vs Table Variables, Statistics, Recompiles, and ScopePlanned lesson · reserved path Chapter12/Lesson2.html
Planned
03
Memory Grants, Sort/Hash Spills, Grant Feedback, and Concurrency PressurePlanned lesson · reserved path Chapter12/Lesson3.html
Planned
04
Spools, Worktables, Workfiles, Exchanges, and Hidden Tempdb ConsumersPlanned lesson · reserved path Chapter12/Lesson4.html
Planned
05
Design and Validate tempdb Layout, Capacity, Monitoring, and Incident ResponsePlanned lesson · reserved path Chapter12/Lesson5.html
Planned
13

Chapter 13

Stored Procedures, Functions, Views, Triggers, Dynamic SQL, and CLR Boundaries

5 lessons
01
Stored Procedures, Parameters, Result Sets, Recompilation, and Ownership ChainingPlanned lesson · reserved path Chapter13/Lesson1.html
Planned
02
Scalar/Table-Valued Functions, Inline TVFs, UDF Inlining, and Performance TradeoffsPlanned lesson · reserved path Chapter13/Lesson2.html
Planned
03
Views, Indexed Views, SCHEMABINDING, Updatability, and Abstraction CostsPlanned lesson · reserved path Chapter13/Lesson3.html
Planned
04
Triggers, inserted/deleted Tables, Multi-Row Correctness, Auditing, and RecursionPlanned lesson · reserved path Chapter13/Lesson4.html
Planned
05
sp_executesql, Safe Dynamic SQL, Metadata-Driven Code, and When CLR/External Logic FitsPlanned lesson · reserved path Chapter13/Lesson5.html
Planned
14

Chapter 14

Security: Logins, Users, Roles, Permissions, Encryption, and Auditing

5 lessons
01
Windows/Entra/SQL Authentication Concepts, Logins vs Users, Contained Databases, and IdentityPlanned lesson · reserved path Chapter14/Lesson1.html
Planned
02
Server/Database Roles, GRANT/DENY/REVOKE, Ownership Chains, EXECUTE AS, and Least PrivilegePlanned lesson · reserved path Chapter14/Lesson2.html
Planned
03
TLS, Force Encryption, Certificates, Keys, TDE, Backup Encryption, and Key LifecyclePlanned lesson · reserved path Chapter14/Lesson3.html
Planned
04
Always Encrypted Concepts, Client-Side Protection, Secure Enclaves, and Application ImplicationsPlanned lesson · reserved path Chapter14/Lesson4.html
Planned
05
SQL Server Audit, Extended Events for Security, Row-Level Security, Dynamic Data Masking, and HardeningPlanned lesson · reserved path Chapter14/Lesson5.html
Planned
15

Chapter 15

Backup, Restore, Recovery Models, and Point-in-Time Recovery

5 lessons
01
Full, Differential, Log, Copy-Only, File/Filegroup, and Tail-Log BackupsPlanned lesson · reserved path Chapter15/Lesson1.html
Planned
02
Simple, Full, and Bulk-Logged Recovery Models with Log Chain SemanticsPlanned lesson · reserved path Chapter15/Lesson2.html
Planned
03
Restore Sequences, NORECOVERY/STANDBY, STOPAT, Piecemeal Restore, and Online ScenariosPlanned lesson · reserved path Chapter15/Lesson3.html
Planned
04
Backup Compression, Encryption, Checksums, VERIFYONLY, Restore Validation, and Media StrategyPlanned lesson · reserved path Chapter15/Lesson4.html
Planned
05
Design Automated Backups, RPO/RTO, Retention, Offsite Copies, and Disaster-Recovery DrillsPlanned lesson · reserved path Chapter15/Lesson5.html
Planned
16

Chapter 16

Always On Availability Groups, Failover Cluster Instances, and HA Design

5 lessons
01
Windows Server Failover Clustering Concepts, Quorum, Nodes, Networks, and StoragePlanned lesson · reserved path Chapter16/Lesson1.html
Planned
02
Failover Cluster Instances: Shared Storage, Instance Failover, and Operational TradeoffsPlanned lesson · reserved path Chapter16/Lesson2.html
Planned
03
Availability Groups: Replicas, Synchronization, Endpoints, Listeners, and Failover ModesPlanned lesson · reserved path Chapter16/Lesson3.html
Planned
04
Readable Secondaries, Read-Only Routing, Backups, Lag, Seeding, and Application IntentPlanned lesson · reserved path Chapter16/Lesson4.html
Planned
05
Quorum/Fencing, Split-Brain Prevention, Planned/Unplanned Failover, and HA TestingPlanned lesson · reserved path Chapter16/Lesson5.html
Planned
17

Chapter 17

Replication, Log Shipping, Distributed Availability, and Data Movement

5 lessons
01
Snapshot, Transactional, and Merge Replication Architecture and Appropriate Use CasesPlanned lesson · reserved path Chapter17/Lesson1.html
Planned
02
Articles, Publications, Subscriptions, Agents, Latency, Conflicts, and MonitoringPlanned lesson · reserved path Chapter17/Lesson2.html
Planned
03
Log Shipping Architecture, Restore Delay, DR Use Cases, and Failover ProceduresPlanned lesson · reserved path Chapter17/Lesson3.html
Planned
04
Distributed Availability Groups and Multi-Site Disaster-Recovery ConceptsPlanned lesson · reserved path Chapter17/Lesson4.html
Planned
05
Choosing Between AGs, Replication, Log Shipping, ETL/CDC, and Application-Level ReplicationPlanned lesson · reserved path Chapter17/Lesson5.html
Planned
18

Chapter 18

Change Tracking, CDC, Service Broker, and Integration Patterns

5 lessons
01
Change Tracking for Lightweight Synchronization and Version-Based ReadsPlanned lesson · reserved path Chapter18/Lesson1.html
Planned
02
Change Data Capture Tables, LSNs, Capture/Cleanup Jobs, and ETL ConsumptionPlanned lesson · reserved path Chapter18/Lesson2.html
Planned
03
Service Broker Concepts, Queues, Services, Dialogs, Activation, and Reliable MessagingPlanned lesson · reserved path Chapter18/Lesson3.html
Planned
04
Linked Servers, OPENQUERY, Distributed Queries, MSDTC, and Coupling RisksPlanned lesson · reserved path Chapter18/Lesson4.html
Planned
05
Design an Integration Boundary for CDC, Messaging, ETL, and Cross-System ConsistencyPlanned lesson · reserved path Chapter18/Lesson5.html
Planned
19

Chapter 19

Columnstore, Batch Mode, Analytics, and Hybrid Transactional/Analytical Workloads

5 lessons
01
Columnstore Architecture, Rowgroups, Segments, Dictionaries, and CompressionPlanned lesson · reserved path Chapter19/Lesson1.html
Planned
02
Clustered vs Nonclustered Columnstore, Delta Stores, Tuple Mover, and MaintenancePlanned lesson · reserved path Chapter19/Lesson2.html
Planned
03
Batch Mode Processing, Aggregate Pushdown, Segment Elimination, and Plan ReadingPlanned lesson · reserved path Chapter19/Lesson3.html
Planned
04
Loading Patterns, Partition Switching, Index Reorganization/Rebuild, and FragmentationPlanned lesson · reserved path Chapter19/Lesson4.html
Planned
05
Operational Analytics, Hybrid Workloads, Resource Isolation, and When to Use a WarehousePlanned lesson · reserved path Chapter19/Lesson5.html
Planned
20

Chapter 20

In-Memory OLTP and Memory-Optimized Data Structures

5 lessons
01
Memory-Optimized Tables, Hash vs Range Indexes, Durability Options, and Checkpoint FilesPlanned lesson · reserved path Chapter20/Lesson1.html
Planned
02
Natively Compiled Procedures, Supported T-SQL, Compilation, and Performance ModelPlanned lesson · reserved path Chapter20/Lesson2.html
Planned
03
Transaction Semantics, Optimistic Concurrency, Validation Failures, and Retry LogicPlanned lesson · reserved path Chapter20/Lesson3.html
Planned
04
Migration Candidates, Memory Sizing, Garbage Collection, and Operational MonitoringPlanned lesson · reserved path Chapter20/Lesson4.html
Planned
05
When In-Memory OLTP Helps—and When Well-Tuned Disk-Based Tables Are BetterPlanned lesson · reserved path Chapter20/Lesson5.html
Planned
21

Chapter 21

SQL Server Agent, Maintenance, Automation, Policy, and Operational Governance

5 lessons
01
SQL Server Agent Jobs, Schedules, Steps, Proxies, Credentials, Alerts, and Failure HandlingPlanned lesson · reserved path Chapter21/Lesson1.html
Planned
02
DBCC CHECKDB, Integrity Checks, Scheduling, Repair Boundaries, and Restore-First PhilosophyPlanned lesson · reserved path Chapter21/Lesson2.html
Planned
03
Index/Statistics Maintenance Based on Evidence Instead of Blind Rebuild SchedulesPlanned lesson · reserved path Chapter21/Lesson3.html
Planned
04
Policy-Based Management, Central Management Concepts, and Configuration DriftPlanned lesson · reserved path Chapter21/Lesson4.html
Planned
05
Automate Runbooks with T-SQL/PowerShell, Capture Evidence, and Make Operations IdempotentPlanned lesson · reserved path Chapter21/Lesson5.html
Planned
22

Chapter 22

Observability: DMVs, Extended Events, Wait Stats, Perf Counters, and Incident Analysis

5 lessons
01
Key DMVs for Requests, Sessions, Connections, Transactions, Locks, and PlansPlanned lesson · reserved path Chapter22/Lesson1.html
Planned
02
Wait Statistics Methodology, Signal vs Resource Waits, Baselines, and Anti-PatternsPlanned lesson · reserved path Chapter22/Lesson2.html
Planned
03
Extended Events Sessions, Targets, Event Fields, Actions, Causality, and Low-Overhead TracingPlanned lesson · reserved path Chapter22/Lesson3.html
Planned
04
Performance Counters, OS Metrics, Storage Latency, Memory Pressure, and CPU SchedulingPlanned lesson · reserved path Chapter22/Lesson4.html
Planned
05
Build an Incident Timeline from Logs, XEvents, Query Store, DMVs, and Infrastructure MetricsPlanned lesson · reserved path Chapter22/Lesson5.html
Planned
23

Chapter 23

SQL Server 2025 Features: Vector Data, AI-Oriented Workloads, and Modern Development

5 lessons
01
Vector Data Type, Vector Functions, Similarity Workloads, and Data Modeling ChoicesPlanned lesson · reserved path Chapter23/Lesson1.html
Planned
02
Embedding Pipelines, Vector Search Architecture, Filtering, and Hybrid Relational/Vector QueriesPlanned lesson · reserved path Chapter23/Lesson2.html
Planned
03
JSON/REST/Developer Improvements and How Modern App Patterns Interact with the EnginePlanned lesson · reserved path Chapter23/Lesson3.html
Planned
04
Security, Governance, Observability, and Cost Controls for AI-Adjacent Database WorkloadsPlanned lesson · reserved path Chapter23/Lesson4.html
Planned
05
Evaluate Native Vector Capabilities vs Dedicated Vector/Search Systems Using Workload EvidencePlanned lesson · reserved path Chapter23/Lesson5.html
Planned
24

Chapter 24

Upgrades, Compatibility Levels, Migration, Cloud/Hybrid Paths, and Change Management

5 lessons
01
In-Place vs Side-by-Side Upgrade, Compatibility Levels, Breaking Changes, and Rollback StrategyPlanned lesson · reserved path Chapter24/Lesson1.html
Planned
02
Database Migration Assistant Concepts, Backup/Restore Moves, Log Shipping/AG Cutovers, and ValidationPlanned lesson · reserved path Chapter24/Lesson2.html
Planned
03
Cross-Platform Windows/Linux Considerations, Collations, Agents, External Dependencies, and ToolingPlanned lesson · reserved path Chapter24/Lesson3.html
Planned
04
Expand/Contract Schema Changes, Online Index Operations, Backfills, and Application CompatibilityPlanned lesson · reserved path Chapter24/Lesson4.html
Planned
05
Canaries, Query Store Baselines, Post-Upgrade Regression Analysis, and Production Acceptance CriteriaPlanned lesson · reserved path Chapter24/Lesson5.html
Planned
25

Chapter 25

Production Capstone: Design, Secure, Tune, Automate, and Recover SQL Server

5 lessons
01
Define SLOs, Workload Classes, Data Model, HA/DR Targets, Capacity, and Architecture RecordPlanned lesson · reserved path Chapter25/Lesson1.html
Planned
02
Implement Schema, Indexes, Security, Encryption, Agent Automation, and Migration PipelinePlanned lesson · reserved path Chapter25/Lesson2.html
Planned
03
Load Test and Tune Plans, Query Store, tempdb, Memory, I/O, Columnstore/In-Memory Where AppropriatePlanned lesson · reserved path Chapter25/Lesson3.html
Planned
04
Implement Backups/PITR, AG/DR, Monitoring, Integrity Checks, Alerts, and Incident RunbooksPlanned lesson · reserved path Chapter25/Lesson4.html
Planned
05
Execute Restore, Failover, Corruption, Performance, and Upgrade Drills—and Defend the Final DesignPlanned lesson · reserved path Chapter25/Lesson5.html
Planned

Keep knowledge open

Help the academy stay free and grow.

If these curricula save you planning time, a small donation supports new lessons, technical review, diagrams, examples, and long-term maintenance.

ETHEthereum / ERC-20 only
0x716c4Ab160C4B66F31a28AE2448BfF68fc3a2ef0

Send only assets compatible with the Ethereum/ERC-20 network. Do not send TRC-20/TRON assets.