I've had an issue with this script duplicating columns when there is a gap in the colid of the syscolumns table in SQL Server 2000.

Is there an easy fix for...

By the way... I put javascript on the list BEFORE I read this...

http://www.ewherry.com/2012/06/the-recruiter-honeypot/

The craziness will probably have died down before I ever learn it.

Thanks for the input.

I'm definitely going to do a deep dive on Powershell, as it is very relevant to my current job.

On a more personal note I'm looking...

Professionally I help manage 500+ small SQL Server installations. We have 5 to 100 devices per install. I'm trying to automate manual processes and collect data for verification and troubleshooting

So this is what all those cash registers in Mexico are running?

another vote for Powershell. Though the hyperlink wasn't totally obvious in the editorial. Perhaps edit it to read: Now if I only had a "Powershell script" button right next to...

The biggest challenge I have with tools is licensing. The tools themselves are usually pretty cool. Figure out if I can use them... not so much.

I use the sysinternals suite of utilities virtually every day. I'm more like a production dba and troubleshooter then a developer. I'd like to start using a wikii at home,...

You actually had it right.... The banks lose a holiday when it falls on a Saturday...

Here is the quote from the web site:

http://www.federalreserve.gov/aboutthefed/k8.htm

"For holidays falling on Saturday, Federal...

This line needs an edit:

If a holiday falls on a Saturday, the Federal Reserve will be open for business as usual on the Friday before. But if a...

I've seen a lot of databases where the flags were typed as var/char fields. I was even mildly concerned that the column name in the question (column1) didn't match the...

How would you title this article to make it more innocuous?

A Non-Production Index Error Checker?

What are your usage permissions on this script? Can I republish it internally?

Thanks!

-Robert

I've worked with someone who takes out a calculator. He uses it to approach the data from a different angle. It often works.

A really neat product, I'm especially interested in how you came up with this list of performance counters, and if the list is considered proprietary:

Machine: processor time

Avg. CPU queue length

Machine:...