While this is a good illustration of how to leverage the output of sp_helptext, I would caution against using this in a production environment or without the benefit of a...

Very nice discovery script and remediation script. I hope the PCI compliance auditors like it too.

Jeff Bennett

St. Louis, MO

Thanks, Kevin,

I am not trying to be snarky or nit-picking. I am really curious. I have come across this a couple of times recently in third-party databases, and...

This response is directed at Kevin

I am curious how an non-clustered index that matches the clustered index could be more efficient. Can you elaborate on that,please?

Thanks

Jeff Bennett

Saint Louis, MO

Dropping the index removes the possibility of quickly pulling it back out of your hat, if you do end up needing it. Of course, these are duplicate indexes, so there...

Ed,

This is a terrific article, and should go into the "Troubleshooting Hall of Fame", if there ever is such a place. You clearly put a lot of work...

Thanks for the write-up. Most of the problems people have with linked servers are a result of permissions and remote logins. This article seems to deal with an...

I used your article to finally get started in Azure. Great write-up and very easy to follow.

A head's up regarding the IP configuration. I had...

It is really great to hear you say this on such an open forum, Steve. While Microsoft continues to push Azure down our throats, there are some caveats,...

Why don't you just add storage to the drive?

Also determine why your distribution database is growing so large. Check on the clean-up process. Try reviewing this link :...

I have to amend my suggestion:

If you use the batchfile/config file method, you need to include these values in the config file:

MEDIASOURCE="V:\"

You used to be able to blend in service...

Thanks for the write-up. It is a good review of the process.

I prefer to save the .ini file and call it from a small batch...

First: Thanks for the article. I appreciate that you took the time and made the effort.

BEGIN RANT

This is a good idea in an ideal world, where...

"Good question and the answer is that if you need a "very" secure system then you would turn this feature off. The recommendation are just that. You can easily show...

Your version of SQL Server is probably too old to recognize the MAX keyword. Are you using SQL 2000?

You could try doing a replace in the...