Forum Replies Created

Viewing 15 posts - 1 through 15 (of 459 total)

  • Reply To: Where Do You End Up as a DBA?

    I'm in this specific position right now.  I've been a bit restless, and on-call support is wearing me down.  The work is pleasant enough, but not stimulating, and initiatives for...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Table Space Used in DB

    Psst...we can still see your table names, not sure if you're okay with that.  It's not 100% opaque..

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Is this way of writing code flexible enough for many administrative tasks?

    Grant Fritchey - Thursday, July 19, 2018 7:32 AM

    Oh, the love/hate relationship with PowerShell will only deepen, on both sides.

    LOL...yeah.  I'm focusing...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Is this way of writing code flexible enough for many administrative tasks?

    Grant Fritchey - Thursday, July 19, 2018 4:59 AM

    Yeah, that's an approach that will work and get done what you're looking for....

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Looking for general advice on next phase of career, from SQL Server DBA to...

    Arjun Sivadasan - Wednesday, July 18, 2018 12:01 AM

    Local meetup sounds fantastic Gaby. I learn Microsoft R and Python on edX. Their...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Looking for general advice on next phase of career, from SQL Server DBA to...

    Arjun Sivadasan - Tuesday, July 17, 2018 1:14 AM

    Pretty much my questions too, so I'm following.

    My 2 cents:
    I have had a 10...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Active-Active cluster + AlwaysOn HA

    Oops, I mean KEEP the cluster, but evict the nodes at the end after I've copied over to the new instances. Will definitely take a look at that. Thanks!

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Active-Active cluster + AlwaysOn HA

    gotcha...so, to use existing hardware, I'd need to break the cluster. Would the best recommendation be to create two new instances, one on each server, migrate from each active...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Generate a random password

    So it's been a while, since the last comment, and I've changed companies. Revisited this code because we have the PERFECT scenario where it is useful, as we spin...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Appropriate sample sizes for UPDATE STATISTICS?

    Thanks Gail and Jack for your input. As I'm finally getting exposure to live 2014, I need to unlearn some things in 2008 (non-R2). I would use Ola's...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Best resources to provide fellow IT support who need to troubleshoot SQL Server

    Thanks everyone for the tips. Jonathan's book for the team, but maybe Kalen's book for myself. 😀

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: Yet another way to defrag indexes

    ggeier (7/25/2014)


    What advantages does this script have over Ola Hallengren's index maintenance solution?

    Sometimes, I want a script without too many bells and whistles. That was mainly it.

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: After changing port on a cluster the proper way, default connection without port specified still working

    DeadScorpius (8/2/2013)


    SQL Browser service turned on possibly?

    No, it's off...it seems that 1433 indeed was not listening. However, we had to let the network admins open up our new port....

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: After changing port on a cluster the proper way, default connection without port specified still working

    Anyone? 🙁

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • RE: After changing port on a cluster the proper way, default connection without port specified still working

    Attached are three lines that might be important from the Errorlog. Not sure if the \pipe connections matter.

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

Viewing 15 posts - 1 through 15 (of 459 total)