Russ Thomas – SQL Judo

The Art of SQL Server Database Administration, Development, and Career Skills for the Technically Minded

SSMS Day 25: Database Diagramming

31 Days of SSMS: Table of Contents

Hi – It’s my Birthday (one more year to the big 40).  I’ve taken the day off.  Writing 31 posts in 31 days is a lot more challenging that I thought it would be.  If you want to read about Database Diagramming I highly recommend reading up on it here.

http://www.mssqltips.com/sqlservertip/1816/getting-started-with-sql-server-database-diagrams/

I may come back at some point and write my own article – or I may not – I’m not really sure what else I’d add to the article above.

To be perfectly honest I’m not a big fan of the SSMS implementation of diagramming.  At all.  I look at diagrams as a way to model and architect design.  The inability to sort or auto-arrange into hierarchies bugs me.  Also, the fact that modifications to the diagram are immediately pushed all the way to the database scares me.  I much prefer Embarcadero ERStudio for diagraming both new projects and reverse engineering existing databases.  I like that I can both analyze and solidify design and then create a script to push it to the physical layer.

See you tomorrow – I won’t mail it in again – I promise.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: