SQL Server Certification diagrams | |
============================== | =============== |
SQL Server 2008 Certification Paths |  |
SQL Server 2012/2014 Certification Paths |  |
SQL Server 2016 and later Certification Paths |  |
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) |  |
Network Load Balancing (NLB) |  |
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 Agent – Job Architecture |  |
SQL Server Agent – Alert Architecture |  |
SQL Agent Service – Job Step Security |  |
SQL Server Agent – Job Step Proxies & Credentials |
|
SQL Server – High Availability and Disaster Recovery diagrams | |
============================== | =============== |
AlwaysOn Failover Clustering Instances (FCIs) |  |
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 | |
============================== | =============== |
Database Construction – Core Building Blocks |  |
SQL Statement Categories |  |
Database Construction – Multiple Files & Filegroups |  |
Database Construction – Database Application Building Blocks |  |
Database Construction – Programming Object Functionality Comparison |  |
Constraint versus Index Design Matrix |  |
Database Environment Landscape |  |
Database Construction – File System Design Ideas |  |
SQL Server Function Taxonomy |  |
SQL Server – Partitioned Table Design |  |
Classifying Dynamic Management Objects (DMOs / DMVs / DMFs) |  |
Breaking Down the GROUP BY and HAVING Clauses – A Flowchart |  |
Service Broker Architecture |  |
SQL Server Analysis Services (SSAS) diagrams | |
============================== | =============== |
OLAP Cube Building Process |  |
Standard Data Warehouse Relational Schema |  |
OLAP Dimension Usage Types |  |
Core Building Blocks of a UDM / OLAP Solution |  |
SQL Server Integration Services (SSIS) diagrams | |
============================== | =============== |
SSIS Package Anatomy – Simple Package |  |
SSIS Package Anatomy – Modestly Complex Package |  |
SSIS Package Anatomy – Complex Package |  |
Anatomy of the SSIS Catalog |  |
SQL Server Reporting Services (SSRS) diagrams | |
============================== | =============== |
Reporting Services – Native Mode Deployment Scenarios |  |
Reporting Services – Report Development Process |  |
Reporting Services – Report Execution Scenarios |  |
Reporting Services – Header & Footer Options |  |
Reporting Services – External Access Design |  |
SQL Server Security diagrams | |
============================== | =============== |
Accessing SQL Server Resources
(a.k.a. “The “Hurdles diagram”) |  |
SQL Server Security Scopes |  |
SQL Server Database Permission Models |  |
SQL Server Ownership Chains |  |