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!
Al Edlund says
Chris, thanks for capturing this, Al
Visio Guy says
Also gives me something to test some of my arrangement tools that I’ve been working on.
Brett Newman says
We developed those stencils here at Visimation for Microsoft and the direct link to the download page on VisioToolbox is http://visiotoolbox.com/downloads/Tools/Visio_Stencils_-_For_All_Your_Diagramming_Need_562.aspx
Thank you VERY much!!!! 😀
Alternative Power says
I am doing a radiant floor heat looping diagram in Visio, is there any way to measure each loop as i am creating it?
It is very important to have equal (or close to it) loops for in-floor heating applications.
A reference to your site must be made available in Visio itself.
Thank you for the amazing site and content
Kavee Wijayasekara says
Thanks you very much for creating these and making them available.
Thanks so much for posting these! I believe I was going down the same convoluted path!
Joshua Moldover says
As of 3/19/12, the file was no longer available on SSIS Junkie’s SkyDrive site. Can you post it directly?
Visio Guy says
Thanks for the heads-up, Joshua. I’ve added it to my Tasks, no idea when I’ll get to it, though.
would you be so kind to help me locate the SQL Server visio stencils?
So the shapes are up on http://sqlblog.com/blogs/jamie_thomson/archive/2010/02/03/visio-stencils-for-ssis.aspx
I’ve also started building up my own set.
It’s continually a work in progress, but I currently have:
Analysis Services (MultiDimensional)
Analysis Services (Tabular)
Data Quality Services
Master Data Services
These are icons I completely made up myself so *far* from official, but open for anyone to use if you need them. I’ll probably add SSIS and SSRS at some point as well. Feel free to leave a comment on my blog if there are ones you want
Hi there i am kavin, its my first occasion to commenting anyplace, when i read this article i
thought i could also make comment due to this good post.
I have read so many articles about the blogger lovers but this
article is in fact a good post, keep it up.