Toolbox
A consolidated repository of various scripts and tools I’ve blogged about.
SQL Audit
Related Posts
- SQLAudit 101 – Creating a basic audit
- SQLAudit 102 – Reading audit output
- SQLAudit 201 – Creating an Audit Solution
- SQLAudit 301 – Using PowerShell to Manage Audits
- SQLAudit 302 – Deploying the Audit Solution with PowerShell
Download the SQLAudit scripts.
SQL Server Inventory
Related Posts
- The Importance of a SQL Server Inventory
- Building a SQL Server Inventory – Part 1
- Building a SQL Server Inventory – Part 2
Download the SQL Server Inventory scripts.
Update Statistics in Parallel
Related Posts
Download the Update Statistics scripts.
4 Responses
SQL Audit - User-defined Audit Events | Cleveland DBA - October 18, 2012
[...] Toolbox [...]
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?
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.
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.
Leave a Reply