Eric M Russell (8/23/2016)

---

I hate "security questions". If I'm a hacker and want to know your grandfather's first name or your mother's mainden name, I can just go to ancestry.com....

Hmm.... kind of an interesting to see MS trying to make platform agnostic tools, I'm wondering how much of the value is lost by not being so closely tied to...

Have you tried using bcp to extract the data?

You could still set up a powershell wrapper to parse your input file and generate the bcp commands and run them.

It really depends on the deployment, depending on the components involved tests could be to run a complete system test to just making sure no errors were thrown during migration...

Eric M Russell (8/18/2016)

---

Government IT departments, at least at the state and federal level, are well funded, and IT platform tools they use are similar to what you would find...

I think there's a huge difference between archiving data and deleting data. Yes that one audit log record out of millions from 10 years ago might mean that it...

Quantum

GilaMonster (7/27/2016)

---

Eric M Russell (7/27/2016)

---

It can be especially difficult for an organization when the recruiting effort is too focussed on conformity and cultural fit rather than experience and talent relevent...

Phil Parkin (7/26/2016)

---

ChrisM@Work (7/26/2016)

---

BrainDonor (7/26/2016)

---

Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the...

I tend to find that if something can't be unit tested easily and effectively it's because of some fundamental design problem. Usually i see this when a developer tries...

How long do all those individual queries you're using to populate those temp tables take?

Think about it like this, they'll likely be more than happy to take your development work and move forward with it without you no reason you can't do the same...

I stayed at my last job far longer than I should have career wise mostly because I got comfortable there which can be a very dangerous trap. After I'd...

Should be relatively straight forward.

SELECT refEmail, MAX(LastContactDate), MIN(LastContactDate), DATEDIFF(day, MAX(LastContactDate), MIN(LastContactDate)) FROm trial_contacts GROUP BY refEmail

So no you can't make a view that was something like

CREATE VIEW MY_VIEW AS(

EXEC sp_order 'ABC'

)

But there are some things you could do depending on what your SP is doing....