Forum Replies Created

Viewing 15 posts - 3,046 through 3,060 (of 9,712 total)

  • RE: SQL DBA knowing user passwords

    Markus (11/21/2014)


    Our main system was just upgraded from SQL2000 to 2008R2 in May. There was no way to have the user change their password in SQL2000 and/or make it...

  • RE: SQL DBA knowing user passwords

    sqldriver (11/21/2014)


    Every application I support uses SQL logins, and they all require at minimum the dbcreator role assigned.

    Yikes! What kind of application spawns its own databases? And how many databases...

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

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

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

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

  • RE: FCI and Availability Groups

    Thanks, everyone. I appreciate all this information.

  • 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!

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

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

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

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

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

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

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

Viewing 15 posts - 3,046 through 3,060 (of 9,712 total)