Skip to content

SQL Server Diagrams


Database Engine SQL Server Agent High Availability Database Development Security
SSAS SSIS SSRS Certification

SQL Server Database Engine and General Database Diagrams

Don’t forget my Azure ☁ page

Structure of a Relational Database
(to demonstrate basics of relational design, table structure, primary and foreign key constraints, and more)
SQL Server Data File Anatomy (.mdf and .ndf files)
Business Intelligence Landscape



The second diagram, more simplified, I found at Matthew Roche’s website


SQL Server – Agent Service diagrams

SQL Server – High Availability and Disaster Recovery diagrams

AlwaysOn AvailabilityGroups (AGs)
Both of these diagrams come from Microsoft sites; they’re not my own
(I’d like to create my own diagram. Perhaps soon?)
Log Shipping
(see also these configuration screenshots)
Database Mirroring
(see also these configuration screenshots)
Database Replication
(a form of High Availability, as something gets duplicated)

SQL Server – Database Development & Querying diagrams

SQL Server Analysis Services (SSAS) diagrams

SQL Server Integration Services (SSIS) diagrams

SQL Server Reporting Services (SSRS) diagrams

SQL Server Security diagrams

Accessing SQL Server Resources

(a.k.a. “The “Hurdles diagram”)

SQL Server Certification diagrams

SQL Server Certification diagrams
SQL Server 2016 and later Certification Paths

AltStyle γ«γ‚ˆγ£γ¦ε€‰ζ›γ•γ‚ŒγŸγƒšγƒΌγ‚Έ (->γ‚ͺγƒͺγ‚ΈγƒŠγƒ«) /