{e-Squillace.com} Diagrams & Presentations Homepage

Diagrams & Presentations

If you click on the "source" link you will download the actual Visio file,
which you can open using the Visio Viewer

Download the Visio Viewer 2010

Download the Visio Viewer 2007

General & Miscellaneous diagrams
- Understanding DNS "Transparency Layers" [in progress], or source.
- How Do Computers Identify Services on Other Computers?
  A lesson on sockets and more, or source.
- Network Data Transfer Process A lesson on layered network communication.
  - "Layered" Communication, and source.
  - Communication within the Same Subnet, and source.
  - Communication across Subnets, and source.
- A revised OSI Model, or source.
- Public Key Infrastructure (PKI) Component Comparison, or source.
- An example of a Poor Replication Design (one which doesn't take the physical network into account), or source.
- RADIUS Concepts Model, or source.
- Relationship of Microsoft Official Curriculum [MOC] Courses to Microsoft Certified Professional (MCP) Exams, or source.
- Remote Access scenarios (two diagrams), or source.
- Routing & Routing Tables, or source.
- Virtual PC (& Virtual Server) File Relationships, or source.
- Visual Studio Solutions and Projects
- Web Services Architecture (coming soon [hopefully])
- What is the value of using an interface, or API (Application Programming Interface), and what are some real-life examples? (or source).
- Why Should I Learn a New Skill? A lesson on return on investment. (or source).

Windows Operating System & Active Directory related diagrams
- Accessing network resources via Shared Folders with NTFS Permissions, or source.
- Accessing a web resource through IIS, or source.
- DCPromo Scenarios, or source.
- Group Policy Acronyms & Relationships, or source.
- Diagrams related to Windows Groups
  - The significance (group memberships) of the
    Forest Root Domain Administrator Account
  - Recommended Windows Group Nesting Design
  - Windows Group Nesting Rules
- Network Access Protection (NAP) Enforcement Methods & Components
- What Happens (to Permissions, Compression and Audit Settings) When NTFS Files & Folders Are Moved Or Copied?

Exchange & Electronic Mail (eMail) diagrams
- Accessibility of Exchange Information 2000 & 2003 Store data (Mailbox and Public Folder data)
- Exchange 2000-2003 Organization Architecture
- Exchange 2007 & 2010: Firewall Rules Required to Support the Edge Transport Server Role (and source)
- Exchange 2000 & 2003 Front-End/Back-End Firewall configurations
- How Is Internet eMail Received?
- Relationship of Exchange Public Folder Tree roots and Public Folder Stores
- Exchange Development (Some screenshots of public folder development ideas and concepts)
- Exchange High Availability (HA) Technologies (Composite Diagram)
- Course 2400C, Module 3 (Security), Practice on pp. 42-46

SQL Server diagrams
- Accessing SQL Server Resources (a.k.a., the "Hurdles" diagram), and source.
- Agent Proxies & Credentials (relates to SQL Agent Jobs & Job Steps), and source.
- Database Construction Building Blocks (There are seven diagrams related to this topic...)
  - Core Building Blocks of an OLTP Database, and source.
  - Files & Filegroups, and source, which illustrates...
    - Multiple filegroups.
    - Multiple files per filegroup.
    - Uneven sized files.
    - Table on one filegroup, related non-clustered index on another filegroup.
    - Partitioned Table and Partitioned Index.
  - Database Application Building Blocks, and source, which illustrates...
    - ...the collection of components between front-end and back-end.
  - Programming Object Functionality Comparison, and source, which illustrates...
    - Sprocs v. Functions v. Views v. Triggers.
  - Permission Models, and source (Users, Windows Groups, and SQL Roles).
  - Database Environment "Landscape", and source of Roles & Responsibilities.
  - SQL Server File System Design Ideas, and source.
- SQL Server 2008 Certification Paths, and source.
- SQL Server High-Availability Technologies & Configurations (Composite diagram)
  - Windows Failover Clustering
  - Log Shipping
  - Database Mirroring
  - Database Replication
  - Network Load-Balance Clustering
- SQL Server Job Architecture, and source.
- SQL Server Alert Architecture
- SQL Server .mdf (.ndf) database file Anatomy, and source.
- SQL Server Ownership Chains, and source. {NEW}
- SQL Server Partitioned Table Architecture, and source.
- SQL Statement Categories, and source.
- SQL Server 2005 Security Scopes
- SQL Server Service Broker architecture, and source.
- SSAS (SQL Server Analysis Services) / OLAP diagrams (Composite diagram)
  - OLAP Cube Building Process
  - Standard OLAP Relational Schema
  - Advanced OLAP Relational Schema
  - Core Building Blocks of an OLAP Cube
- SSIS (SQL Server Integration Services) Package architecture diagrams (Composite diagram)
  - Simple PKG
  - PKG with Modest complexity
  - Complex PKG
- SSRS (SQL Server Reporting Services) diagrams (Composite diagram)
  - Reporting Services - Architecture
  - Reporting Services - External Access Designs
  - Reporting Services - Headers & Footers
  - Reporting Services - Report Execution Scenarios
  - Reporting Services - Working with Data (i.e., DataSources, DataSets)
- Structure of a Relational Database (to demonstrate table relationships), and source.

ISA Server diagrams
- How to Configure ISA Server 2004 & 2006 Interface Properties

Microsoft Course Setup diagrams
- Microsoft Course 2126, How to Set Up Glasgow (Here's a .pdf version)
- Microsoft Course 2274, Mod3-Creating & Managing Groups
- Microsoft Course 2275, How Does Your User Acquire the Required Rights & Permissions to Perform Administrative Tasks?
- Microsoft Course 2277, Implementing Win2003 Srvr Network Services, How Is the Classroom Network Set Up?
- Microsoft Course 2277C, Module 8, RRAS Lab
- Microsoft Course 2400C, Module 3 (Security), Practice on pp. 42-46
- Microsoft Course 2788, Designing High Availability, Virtual Machine Configuration
- Microsoft Course 2824B ISA Server 2004 (HTML) (PDF)
- Microsoft Course 5047B, How is the Virtual Machine Network Set Up
- Microsoft Course 5050A
  - Virtual Machine Configuration (first page)
  - Key components of Lab 1 (second page)
- Microsoft Course 6416B, Virtual Machine configuration
- Microsoft Course 6416C, Virtual Machine configuration
- Microsoft Course 6421A, Virtual Machine configuration
- Microsoft Course 6424A, Virtual Machine configuration
- Microsoft Course 10135A [Exchange 2010], Virtual Machine configuration (and source)

Any other diagram suggestions?