pointers, solutions and scripts for the SQL DBA
not intended to replace common sense

6/06/2011

Forward Engineering from Visio 2010

As we noted in a previous blog post, the lack of so-called "enterprise architect" edition in versions of Visio since 2007 is a pain.  The Visio 2007 solution is decent - though it requires a specific version of .net 1.1, XP compatibility mode, and some custom .xslt.  Visio 2010 has a great third-party Forward Engineering solution from Alberto Ferrari, which is really, really, really easy. 

Install the codeplex project, install.net 4.0 if you haven't already, activate the add-on (not an obvious step) and you're done.  It integrates into the Office 2010 ribbon and you're a couple clicks away.

Here's the project: http://forwardengineer.codeplex.com/

Unfortunately, this solution also doesn't pick up the "notes" for Visio, which would be click if created as Extended Properties, but I can't complain.

"All truths are easy to understand once they are discovered; the point is to discover them." -Galileo Galilei

6/04/2011

DMV Overview Presentation from SQL Saturday #77 Pensacola 2011

Here's the link to a .zip file of my slidedeck and all sample demo files from today's SQL Saturday Pensacola.  This is my DMV Overview presentation from room 2171 at 1:45pm. 

Download here