Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 9,715 total)

  • RE: sql backup

    EdVassie (10/25/2016)

    One thing I did not see explicitly mentioned is the number of backup files.

    I don't know if this is true of all dedup technology, but the stuff we 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.

    October 25, 2016 at 6:05 am

    #1908570

  • RE: Can I do this?

    BLandry474 (10/21/2016)

    My apologies Brandi - you're right - you did say that in your edit. However, you also just addressed constraining the columns entry when I asked a very...

    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.

    October 21, 2016 at 7:07 am

    #1907945

  • RE: Can I do this?

    BLandry474 (10/21/2016)

    My thanks to all who responded, but please, in the future, read the question - I DID NOT say "Users are entering data", what I said was "We get...

    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.

    October 21, 2016 at 6:30 am

    #1907936

  • RE: Testing System DB backups

    Okay. Maybe it was the checks that screwed me up the last time I tried.

    Thanks for the verification. I appreciate 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.

    October 21, 2016 at 5:11 am

    #1907917

  • RE: Can I do this?

    HanShi (10/21/2016)

    Eric M Russell (10/20/2016)

    So, you're saying that the users are entering values that are considered invalid due to their excessive length? You can avoid this by implementing check constraints...

    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.

    October 21, 2016 at 4:23 am

    #1907898

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

    lindsayscott23 (10/20/2016)

    That was actually part of my rationale for separating out into two databases. To reduce cross querying.

    Lins,

    I think you misunderstand what Grant meant by cross-database querying.

    If you separate 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.

    October 20, 2016 at 9:03 am

    #1907686

  • RE: Are the posted questions getting worse?

    jasona.work (10/20/2016)

    Brandie Tarvin (10/20/2016)

    jasona.work (10/20/2016)

    Brandie Tarvin (10/20/2016)

    I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One 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.

    October 20, 2016 at 9:00 am

    #1907685

  • RE: Parameter on Powershell Script

    Luis Cazares (10/20/2016)

    mister.magoo (10/20/2016)

    I was wondering whether all this complexity is worth it...just to run a dtsx? But I'm not a DBA, so I assume this is a small part...

    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.

    October 20, 2016 at 8:57 am

    #1907683

  • RE: Are the posted questions getting worse?

    jasona.work (10/20/2016)

    Brandie Tarvin (10/20/2016)

    I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data,...

    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.

    October 20, 2016 at 7:58 am

    #1907660

  • RE: Are the posted questions getting worse?

    jasona.work (10/20/2016)

    Brandie Tarvin (10/20/2016)

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

    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.

    October 20, 2016 at 6:55 am

    #1907629

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

    October 20, 2016 at 5:49 am

    #1907617

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

    October 20, 2016 at 5:38 am

    #1907616

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

    October 20, 2016 at 5:37 am

    #1907615

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

    October 20, 2016 at 5:34 am

    #1907613

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

    October 20, 2016 at 5:31 am

    #1907612

Viewing 15 posts - 1,336 through 1,350 (of 9,715 total)