Oh I can script out replication and drop and rebuild it, that is not a problem. However, as my post stated earlier though, I am looking for an easier way...

Reading is fundamental. We do test in DEV and QA before moving code to production, as I already stated earlier in this thread. Just because a block change has been...

Pete,

I...

Ok thanks, but i was hoping not to remove/drop replication and recreating it every time we push to production which sometimes can be daily. That would be a real pain...

No, not possibly just data changes, schema changes and functions,stored procs,etc. We do have QA and DEV environmnts and yes, those block changes have been tested beforehand, but we still...

Ok, just stopping/disabling distribution agent seems to be the smart thing to do here but what if after my changes to the published database I decided they are not working...

princess.lipscomb (11/5/2009)

---

It may not seem like a pausible solution for some but it is a way to prove the point of how to stop Select * from happening especially when...

It is articles like this that cause me to pause and remember what a very smart mentor of mine once said when I first got into Database Administration years ago....

This has been my experience as well, and I would...

Tim Mitchell (10/28/2009)

---

jjarupan (10/27/2009)

---

IMHO, reply to the question, How many DBAs Does it take to manage infrastructure? It should be 0 (zero) in nearly future.

No need DBA for infrastructure in...

crookj (10/28/2009)

---

I am also in agreement that you cannot put numbers to it. I would say that you need enough to get the job done without burning out the...

skelly-806234 (10/27/2009)

---

There's no way you can come up with even a ballpark number of DBA's per server. With the right tools, a well set up infrastructure, reliable networks and well...

Elliott W (10/26/2009)

---

I think this depends greatly on the infrastructure you have in place. If you don't have a good infrstructure the number of servers that any single DBA...

Maybe just maybe I am missing something, these are supposed to be simple interview questions, out of this list of questions. I have been asked the following.

*Difference between delete and...

repent_kog_is_near (10/21/2009)

---

if Senior DBA's do not know the answers to these questions, what were they doing at work, while gathering their experience?

I would expect the junior DBA with a modest...