So I...

Adam, just out of curiosity, how many servers and logins are you dealing with?

Nadrek,

So you're saying to extract the hashes of the passwords (sys.sql_logins.password_hash which requires administrator privileges) and feed them into this oclHashcat. I presume that the way to calculate the hash...

You cannot use the extra or-clause and have both '0001' and '1000' in the password list.

Do one or the other, but not both.

The query below does what you are doing...

Uuuhhh, that would be scary!

I suppose Amazon's 1-click technology is more of an idea and cute name than a technology. And maybe Amazon really wants to hold on to that term '1-click' so that...

It's a simple and effective tool!

I would change it to include any databases whose last backup is older than X days.

It's also intesresting to see how restoring a database from...

Well, that 1-click patent by Amazon really ticks me. I'm a passionate customer of Amazon and I think I'll let them know my opinion on this absurd patent.

Where things have...

As Adi said:

delete a

from @a1 a

left join (select phone,min(id) id from @a1 group by phone) d on a.id=d.id

where d.phone is null

Why don't you simply use 'Enforce password policy' of SQL Server?

So what you're saying is that this software makes attempts to login using some sort of dictionary of bad passwords...

Here is a pretty cool script: http://www.sqlservercentral.com/Forums/Topic409505-690-1.aspx

Chris, what you say in your last sentence really intrigues me. Thus query below could, in theory, return one or more rows?

with

c1 as (select name from sys.databases),

c2 as (select name...

The last time I went to http://www.iegallery.com and clicked on search providers/all there were 855 choices.

And all I wanted was a simple 'pasta con ragu'. In Italy that's spaghetti with...

This problem was heavily discussed back in 2009. It only delt with multiple blanks and at the time I had proposed the best SQL solution. Naturally there were CLR solutions...

No matter how well you automate things there comes a time when SQL Agent gets stuck and just hangs and no jobs would start. This happened to me fairly recently....