SQL Server Diagrams


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

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
=============================================
Azure and SQL Server Solutions
Azure Service Directory

Azure Data Center Regions

SQL Server data files in Microsoft Azure

How to use Azure Blog Storage for SQL Server Backup and Restore
by Autl Gaikwad at MSSQTips

Automatically upload SQL Server Database Backups to Azure with Integration Services
by Daniel Calbimonte at MSSQLTips
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