Posts
49
Comments
50
Trackbacks
26
November 2006 Blog Posts
Useful index scripts

At this address

http://www.davidemauri.it/SqlScripts.aspx

i've released four scripts that simplify the usage of SQL Server 2005 DMVs to discover, analyze and understand indexes usage and health.

They are nothing exceptional, juts a shortcut to common (but long to write)
queries.

I use them a lot, maybe they're of some use to other DBAs :-)

posted @ Sunday, November 12, 2006 6:07 PM | Feedback (1)
DTLoggedExec v 0.1.2.0 released!

Finally I've realeased a new version of my DTLoggedExec tool.

A lots of improvement from the first public version:

-Switched to a fully pluggable architecture to support 3rd party plugins
-Added "LogEvent" command line switch to choose which events should be logged
-Added support for Expression logging
-Added "Package Name" and "Container ID" values in the console log

Download it from CodePlex!

posted @ Monday, November 06, 2006 5:34 PM | Feedback (1)
News