Forum Replies Created

Viewing 15 posts - 3,061 through 3,075 (of 9,725 total)

  • RE: SQL DBA knowing user passwords

    It is fair to say the concern that started this thread terrifies me.

    In our environment, we don't give users SQL logins. We use windows authentication. SQL Logins are reserved for...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Using SSIS

    Koen Verbeeck (11/21/2014)


    jacksonandrew321 (11/21/2014)


    so can't we use that SSIS funtions on that? If yes then its possible to use SSIS right from there.

    I'll repeat it again:

    if you want to use...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Accidental DB Designer ;)

    A few thoughts.

    1) Ask him what the primary purpose of his program is. He should be able to tell you this in one sentence. If he can't, then he hasn't...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Using SSIS

    If you don't have the Integration Services components set up on the machine in question, then SSIS won't work. Just because the Client Tools give you the option of logging...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: FCI and Availability Groups

    Thanks, everyone. I appreciate all this information.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Questioning the effects of 100% CPU usage

    The argument appears to be won without the expected inkshed and tantrums. The Dev in question has fixes for the issue.

    YAY!

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: FCI and Availability Groups

    Kevin, thanks for the links. Now I have more questions.

    Is Primary Replica the database of origin or just the first replica that was set up?

    Per the above link:

    As soon...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: FCI and Availability Groups

    Perry Whittle (11/13/2014)


    Brandie Tarvin (11/12/2014)


    1) Both FCI and AG require windows clustering in order to work.

    Yes, both technologies require a functional Windows Server Failover Cluster.

    Note that you may also use...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: FCI and Availability Groups

    Shawn Melton (11/12/2014)


    I will say that PASS Summit 2014 aired a quick start to AlwaysOn that I found very useful to fill in these types of gaps, check it out...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: FCI and Availability Groups

    Steve Jones - SSC Editor (11/12/2014)


    I've got limited knowledge here, but AFAIK, the Windows Cluster moves over those items that are clustered in Windows, which could be SQL Server. If...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: FCI and Availability Groups

    TheSQLGuru (11/12/2014)


    Hey Brandie!! Please do make sure you REALLY know what your objectives/needs are and that you are doing things correctly to get you there. There are SOOO...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Combining AlwaysOn Groups With Failover Cluster Instances

    I still need to re-read this article a few times to make sure I understand everything, but I do have one question after the first read through. When combining FCI...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Odd Percentage on Estimated Execution Plan

    Thank you for the link, Grant. There are indeed a lot of variables in this proc. So it sounds like you've hit the nail on the head.

    I'll take a look...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Questioning the effects of 100% CPU usage

    patrickmcginnis59 10839 (11/11/2014)


    Brandie Tarvin (11/11/2014)


    To clear up a misconception... we did stop the processes on the Test machine and I was immediately able to connect, as was the DBA sitting...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Questioning the effects of 100% CPU usage

    To clear up a misconception... we did stop the processes on the Test machine and I was immediately able to connect, as was the DBA sitting next to me. Plus...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 3,061 through 3,075 (of 9,725 total)