Finding Missing Indexes in Your Ill-Begotten Databases

Last night I presented at (and won!) the Baton Rouge SQL Server and .net User Groups Speaker Idol Competition Summer 2011.  My topic was a humor-ridden presentation of nonclustered indexing strategies for SQL Server and how indexes impact application performance, geared towards a majority-developer audience.

Thanks to all who attended and voted, and a big congrats on a job well done to the other contenders!

Click here to download the slidedeck and sample scripts, in a zip file.

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

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