SQL Server 2005 Microsoft Visio Stencils

If you work with Microsoft SQL Server and are a visual type, then you might be interested in these free Microsoft Visio stencils for SQL Server 2005.

The set contains 6 stencils, 6 templates, 102 master shapes and 34 sample drawings.

You can preview the look and feel of the shapes and sample drawings in this article, then go off and download them for your own person use!

I was browsing Twitter yesterday for visio-related tweets, and a link to a bunch of stencils containing Microsoft Visio shapes for SQL Server 2005 was getting retweeted quite a lot.

I followed a convoluted path to get to the shapes. The tweets first led to SSIS Junkie: Visio stencils for SSIS , which sent me off to Josh’s Stuff: Useful Visio stencil set for SQL Server 2005. Josh had a direct link to the zip file that contains the shapes. The shapes are evidently hosted on Visio Toolbox, but I could not find a page on that site that presented the shapes. So follow that zip link to get them.

Isn’t the Internet FUN?!?

If that zip link ever stops functioning, try SSIS Junkie’s site, as he’s copied the files to his Sky Drive. If that ever fails, leave a comment below and I’ll upload a copy of the files on this site. I tend to shy away from hosting other people’s stuff without asking, but I figure links are OK 🙂

The trouble with all these free downloads is that you have to…well…download them to see what’s inside.  I figure that at least a few of you out there are like me, and like to browse a bit before committing. So I’ve put together some preview images of everything that’s inside the 5MB download. Hope you enjoy the visuals!

You can view the shapes sets immediately below, or jump to the sample drawings.

SQL Server 2005 Stencils for Microsoft Visio

The DFS Replication Shapes stencil contains these shapes:

Branch Office, DFS Link, DFS Link 2, DFS Root, Folder Connector, Hub Site, Replication Pipeline, Server

The Enterprise Service Shapes stencil contains these shapes:

Application Services, Branch Server, Branch Site, Core Client Services, Core Management Services, Data Services, Directory Services, Extended Management Services, File Services, Firewall Services, Hub Servers, Hub Site, Messaging Services, Name Resolution Services, Network Addressing Services, Network Services, Pipeline Connection Print Services, Storage Services, Terminal Services, Virtualization Services, Web-based Collaboration Services

The Local Information Store Data Structure stencil contains these shapes:

Disk, Folder, Folder 2, Folder 3, Folder Callout, Folder Connector, Mirror,Open Folder, Raid

The OLAP Shapes stencil contains these shapes:

Action, Calculated Cell, Calculated Member, Connector, Cube, Database, Dynamic Connector, HOLAP Cube, Level, Loose Relationship, Measure, Member,Mining Model Dimension, MOLAP Cube, Multidimensional Mining Model, Named Set, Parent-Child Dimension, Parent-Child Level, Predicted Member, Private Dimension, Property, Relational Mining Model, ROLAP Cube, Shared Dimension, Strong Relationship, Write – Enable Flag,  Virtual, Virtual Dimension,

The SSIS Shapes stencil contains these shapes:

Data Pump, Derived Column, FlatFile Destination, FlatFile Source , For Each Loop, For Loop, Lookup, Merge, Merge Join, Multicast, OleDb Source, OleDb Destination, OleDb Command, On Completion, On Completion 2, On Failure, On Failure 2 On Success, On Success 2, Union All, Slowly Changing Dimension, SQL Destination, SQL Task

The Service Design Reference Shapes stencil contains these shapes:

Considerations, Design Consideration, Consideration Connector, Design Model, Design Stage, Design Option, Dynamic connector, End Design Model, Off-page reference, Options, Option Connector, Stages, Starting Design Model

SQL Server 2005 Sample Drawings for Microsoft Visio

The download contains 9 vsd files, that contain 34 sample drawings (some files have multiple pages)

Below is a selection of sample drawings from the download.

BIOS LISDS Sample.vsd

BOIS ENS working sample.vsd

SQL Server Analysis Services.vsd

SQL Server Data Mining.vsd

SQL Server Integration Services.vsd

SQL Server Notification Services.vsd

SQL Server Reporting Services Architecture.vsd

SQL Server Replication.vsd

SQL Server Service Broker.vsd

Again, you can get the SQL Server 2005 shapes, stencils and sample drawings for Microsoft Visio here!