Forum Replies Created

Viewing 15 posts - 1,141 through 1,155 (of 1,202 total)

  • RE: How to momentarily stop SQL Server 2005 Transactional Replication?

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: How to momentarily stop SQL Server 2005 Transactional Replication?

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: Preventing usage of "SELECT *..."

    Peter_Beery (11/5/2009)


    This solution seems to solve the wrong problem. The real question should be not "how do we tie our own hands", but rather "how do we enforce code review".

    Pete,

    I...

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: How to momentarily stop SQL Server 2005 Transactional Replication?

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: How to momentarily stop SQL Server 2005 Transactional Replication?

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: How to momentarily stop SQL Server 2005 Transactional Replication?

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: Preventing usage of "SELECT *..."

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: Preventing usage of "SELECT *..."

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: Afraid of Help

    The work environment is so over-comparmentalised with walls between different functions that the problem can't be solved without an organisational change...

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: Simple SQL Server Interview Questions that people have a hard time answering...

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • RE: Simple SQL Server Interview Questions that people have a hard time answering...

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

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

Viewing 15 posts - 1,141 through 1,155 (of 1,202 total)