Forum Replies Created

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

  • RE: Using SSIS

    psc032802 (12/2/2014)

    if the packages are to be run against a single database/server, then it would be best to install ssis on that same machine, correct?

    then bids/ssis needs to be installed...

    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.

    December 2, 2014 at 12:37 pm

    #1762204

  • RE: Are the posted questions getting worse?

    Jack Corbett (12/2/2014)

    We are all anti-RBAR, but I would bet at some point early in our careers we wrote RBAR code because we didn't know better, I know...

    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.

    December 2, 2014 at 11:46 am

    #1762190

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/2/2014)

    Brandie Tarvin (12/2/2014)

    I feel for you, Gail. We're going 'round and 'round with our corporate tech department.

    Us: We need a SQL Server 2012 deployment with X instances in this...

    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.

    December 2, 2014 at 8:33 am

    #1762112

  • RE: Are the posted questions getting worse?

    Ed Wagner (12/2/2014)

    SQLRNNR (12/2/2014)

    <sarcasm>EFW is the bomb and must be worshiped because it saves certain dev types a ton of time to develop. </sarcasm>

    And reading that makes me want...

    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.

    December 2, 2014 at 8:25 am

    #1762102

  • RE: Are the posted questions getting worse?

    I feel for you, Gail. We're going 'round and 'round with our corporate tech department.

    Us: We need a SQL Server 2012 deployment with X instances in this configuration, which is...

    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.

    December 2, 2014 at 8:15 am

    #1762093

  • RE: SQL DBA knowing user passwords

    Been on PTO for a week, so didn't catch up to this thread until now...

    Regarding the app that doesn't prompt for SQL password changes, depending on how big your company...

    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.

    December 1, 2014 at 11:48 am

    #1761827

  • RE: Using SSIS

    psc032802 (12/1/2014)

    the end users in this scenario are people wanting to run the data profiling features. my original question was what needs to be installed and where does it...

    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.

    December 1, 2014 at 11:39 am

    #1761822

  • RE: SSIS File System Task Copy works in BIDS but not in job

    This is getting seriously annoying. I tried switching out to a Script Task and again, this works in BIDS without an issue, but the SQL job seems to hate me...

    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.

    November 21, 2014 at 9:04 am

    #1760195

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

    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.

    November 21, 2014 at 8:07 am

    #1760159

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

    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.

    November 21, 2014 at 8:02 am

    #1760154

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

    November 21, 2014 at 7:35 am

    #1760128

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

    November 21, 2014 at 5:51 am

    #1760083

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

    November 21, 2014 at 5:48 am

    #1760081

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

    November 21, 2014 at 5:33 am

    #1760076

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

    November 20, 2014 at 6:06 am

    #1759807

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