Mike Scalise (9/20/2016)

---

Hi,

I tried to search for this but I haven't seen the question asked explicitly--and that may be because it's kind of dumb, but I'm interested in knowing the...

Hopefully a job offer looking for a 10x DBA won't land you sitting alone in a server room with 9 empty chairs. :ermm:

Hopefully none of is have printed reports in our desk drawers containing personal information about customers. :ermm:

Case in point:

http://www.nytimes.com/2014/09/20/business/ex-employees-say-home-depot-left-data-vulnerable.html?_r=0

---

.. Several former Home Depot employees said they were not surprised the company had been hacked. They said that over the years, when they sought new software...

Essentially, DBA stands for "database administrator". If the organization has solutions deployed on SSIS, SSAS, or SSRS, then at the very least you'll be expected to manage those products on...

Steve Jones - SSC Editor (9/19/2016)

---

Eric M Russell (9/19/2016)

---

Most RDMS are air-tight from external hacking attempts when the DBA properly implements authentication and authorization.

At least based on news reports...

If using MS Access as the database, then you can improve security by implementing something like a web services based data access layer. Specifically, the service account that the web...

By default, only a member of SYSADMIN can execute xp_cmdshell when enabled. If your developers and application users are members of SYSADMIN, they can simply enable xp_cmdshell themselves... and then...

Most RDMS are air-tight from external hacking attempts when the DBA properly implements authentication and authorization.

At least based on news reports (and subsequent technical analysis by the industry), I'm...

Any programmer will be X times more efficient when given an assignment that matches their skillset, a clear set of specifications, sufficient managmement/QA/DevOps support, and sufficiently sized blocks of uninterrupted...

I'm not a freelancer, so I don't have the option of context switching to another client. So, when...

Rod at work (9/16/2016)

---

(We've been having network problems this week so am late in reading any email.)

I just read this. WOW, I am almost salivating reading about this Down Tools...

If this is something like a data warehouse, where you have very large tables that are sourced for reporting purposes from other transactional databases, then consider more of a Kimball...

jerry-621596 (9/15/2016)

---

I tried your script and get and error saying the request to stop the job was refused because the job is not currently running.

Seems like the mystery runs deeper...

I find it convenient to use xp_cmdshell to do things like execute NET or DOS commands for informational purposes, like in environments where the host server doesn't allow RDP connections....