Provide examples of the most problematic values you're trying to convert.

For this, you can leverage sp_MsForEachDB. It will execute the specified batch of T-SQL across all databases. For each iteration, the token ? will be dynamically substituted with the database...

I know what you're talking about. If you have a stored procedure that accepts multiple parameters for performing searches (it seems every CRM type application has one), then dynamic SQL...

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...