Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 9,720 total)

  • RE: What is the right way to design a data flow between development and production dbs?

    lindsayscott23 (10/20/2016)


    ...our workflow goes like this:

    Build in Dev

    Unit Test in Dev (this is done by the developers)

    Add to appropriate folder in TFS (we have monthly releases and each release folder...

    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: sql backup

    Jeff Moden (10/19/2016)


    Steve Jones - SSC Editor (10/19/2016)


    Jeff Moden (10/18/2016)


    Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3 TeraBytes to...

    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: Parameter on Powershell Script

    Luis Cazares (10/19/2016)


    Brandie Tarvin (10/19/2016)


    Have you tried renaming the folders to use underlines instead of hyphens?

    I think the hyphens are the problem. That powershell might see them literally as a...

    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: Are the posted questions getting worse?

    On a fun note, my past 24 hours has been taken up by an AG issue which has caused one secondary replica not to synchronize, which caused the log files...

    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: Are the posted questions getting worse?

    Gazareth (10/19/2016)


    Gazareth (10/19/2016)


    Eirikur Eiriksson (10/18/2016)


    Just had a Blast from the past

    😎

    First line: "Version 4.2 also lets you nest triggers"

    I didn't get any further due to blacking out; came to 10...

    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: With recompile in the master stored proc

    river1 (10/18/2016)


    Separated sql tasks means that each species is executed inside is sql tasks. Task are connect through success arrows ( green arrows). So, exactly as the sp I...

    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: log is full due to Availability Replica

    Perry Whittle (10/19/2016)


    Brandie Tarvin (10/19/2016)


    Are you taking log backups of your primary AG database? If not, then expect it to fill up and not clear.

    you can offload log backups to...

    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: log is full due to Availability Replica

    patrickmcginnis59 10839 (10/19/2016)


    Brandie Tarvin (10/19/2016)


    patrickmcginnis59 10839 (10/19/2016)


    Anything could cause the secondary to not be synchronized. Things like taking differential database backups of the primary, which will disrupt the flow of...

    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: Parameter on Powershell Script

    Have you tried renaming the folders to use underlines instead of hyphens?

    I think the hyphens are the problem. That powershell might see them literally as a switch "notifier" kind of...

    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: log is full due to Availability Replica

    patrickmcginnis59 10839 (10/19/2016)


    Anything could cause the secondary to not be synchronized. Things like taking differential database backups of the primary, which will disrupt the flow of data from primary to...

    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: Are the posted questions getting worse?

    ThomasRushton (10/19/2016)


    Brandie Tarvin (10/19/2016)


    ThomasRushton (10/19/2016)


    Brandie Tarvin (10/19/2016)


    ThomasRushton (10/19/2016)


    rodjkidd (10/19/2016)


    ThomasRushton (10/19/2016)


    In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

    at which point I lost the...

    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: Are the posted questions getting worse?

    ThomasRushton (10/19/2016)


    Brandie Tarvin (10/19/2016)


    ThomasRushton (10/19/2016)


    rodjkidd (10/19/2016)


    ThomasRushton (10/19/2016)


    In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

    at which point I lost the plot.

    are you sure...

    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: Are the posted questions getting worse?

    BLOB_EATER (10/19/2016)


    rodjkidd (10/19/2016)


    ChrisM@Work (10/19/2016)


    BLOB_EATER (10/19/2016)


    Brandie Tarvin (10/19/2016)


    ThomasRushton (10/19/2016)


    rodjkidd (10/19/2016)


    ThomasRushton (10/19/2016)


    In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

    at which point I lost the...

    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: Are the posted questions getting worse?

    ThomasRushton (10/19/2016)


    rodjkidd (10/19/2016)


    ThomasRushton (10/19/2016)


    In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

    at which point I lost the plot.

    are you sure it wasn'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: Are the posted questions getting worse?

    ThomasRushton (10/19/2016)


    In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

    at which point I lost the plot.

    Oh, oh, oh.

    May I steal this for a...

    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 - 1,351 through 1,365 (of 9,720 total)