Place me on the pile of doubters. I have yet to see a non-IT implementation so good that it could not have benefited from participation by someone with knowledge of...

please delete

Having been on both sides of this coin, I don't like to assign based on interesting vs. boring / easy vs. hard.

When someone starts, they may be the best DBA,...

To piggyback on consistency, are there dependencies that would make any particular batch of tables too large to fit within an acceptable window of time?

I was going to recommend SSIS for the same reasons, but it seemed like the conversation was focused on the solution we were discussing. It also sounds like a one...

Another consideration is whether the process/progress could/should be interrupted mid-stream. Some additional flexibility might come from using a real table instead of temp where you could add a field for...

If you have more than two users with differing rights and/or the need to control access to specific queries or objects on a user by user basis, your job will...

Jeff Moden (9/23/2015)

---

So will everything from 2005 and up. And, 2005 also had the "COPY...

+1 on DeWayne_McCallie's answer. I see a few incredibly knowledgeable folks advocating moving or copying the file. However, I know SQL 2012 will back up and restore from network drives.

I...

Steve Jones - SSC Editor (9/10/2015)

---

I think you're conflating two things. Embracing outside consultants and embracing outsouring. Neither necessarily has anything to do with the other.

Outsourcing has been looked at...

I am fascinated with the paradoxes businesses are willing to embrace right now (Ex: everyone is supposed to rush to put everything in the cloud at the exact moment providers...

I'll add in that some hiring managers get it and some don't. There's always unrealistic expectations.

I'd wager we're about six months from jobs that require 5 years experience on SQL...

SSC Veteran, I think what you point out is that SQL Server is not a version, but a wave. Being a great DBA is like surfing. There are certain skills...

The work will still need to get done. It's just a matter of who is doing it. There will need to be just as many skilled data scientists and database...

Gary Varga (5/27/2015)

---

I would be extremely surprised if they hadn't covered that legally e.g. only granted permission for non-destructive access and explicitly disallowed retaining or other use of data.

Also, remember...