I've done something similar to this recently, and added it as part of a SQL Agent job to mail out the results:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Default',

@recipients =...

Having worked predominantly within support during my career I have to disagree with some of this editorial.

"At first, I suggested looking at recent graduates from local colleges for candidates,...

It's the 'cable repair van' camped outside your company office I'd be more worried about than a temp stealing passwords 😉

Thanks all, I'm tested out these solutions further as they are all bringing back slightly different run durations and run statuses each.

"I think I go through a keyboard every 18-24 months, though the mice seem to last longer."

What the heck are you doing to them? 🙂 Not sure I've ever broken...

I used to bang on to management about the vast amount of archived client data that was just sat doing nothing and big opportunities were being missed. Some bright lads...

David.Poole (8/4/2016)

---

In terms of physical data centre security I am pretty sure that Amazon's data centres are considerably more robust than many companies can provide.

I am also sure that economies...

Multi factor authentication over and above 2FA is becoming much more common too, with passphrase, shared secret, IP address, physical location, device type, browser type and version analysis all taking...

I travelled 88 miles for SQL Saturday #411 in Cambridge, just attending not speaking.

Also travelled 109 miles for SQLBits XIV in London, and 99 miles for SQLBits XV in Liverpool,...

cad.delworth (7/20/2016)

---

Anyone who is not a US citizen, or not a US company, should be aware that data owned by non-US citizens but held on servers under US jurisdiction is...

Iwas Bornready (7/7/2016)

---

Over forty years ago one of my advanced math classes had a problem about how to aim a moving sub's torpedo at a moving ship and hit it....

Having worked at a company who are supposed 'industry experts' in data security, I can tell you it is no better behind closed doors at such places. PCI audits were...

There's often a general...

In my mid thirties now and pretty much put off by the demands of IT. Previous roles working most weekends, evenings and through the nights on call has lessened my...