Toolbox 4

toolboxA consolidated repository of various scripts and tools I’ve blogged about.

SQL Audit

Related Posts

Download the SQLAudit scripts.

SQL Server Inventory

Related Posts

Download the SQL Server Inventory scripts.

Update Statistics in Parallel

Related Posts

Download the Update Statistics scripts.

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

4 thoughts on “Toolbox

  • Reply
    David Cobb
    Colleen, Your SQL Inventory scripts saved me a ton of time assessing around 20 SQL servers for a client. Thank you. Do you still maintain your SQL Inventory tool? I made changes to support Trusted Authentication, and thought of some other data I'd like to capture.. have you considered hosting on github and accepting community contributions to it?
  • Reply
    Colleen M. Morrow Post author
    Thanks David. I do maintain it, though pretty much just for personal use. My intention posting on this blog was to provide a jumping off point for other folks to take what I've done and customize it for their own environment. I'd love to hear what other data you're collecting, though.
  • Reply
    Kevin Zakoski
    Great tool, even as a Powershell newbie like myself I was able to convert it to Trusted Autentication and it's now collecting data from approx. 300 SQL boxes in our environment. However, the one problem I'm having and haven't found a solution for is the CommandTimeout. The default of 30 secs causes an exception error every now and them, but I can't find any way to set the value higher. There have been some posts around the subject but everything I try errors out with an invalid argument. Do you know of a way to set the value higher and can you provide an example, if possible? Thanks, Kevin Z.