Forum Replies Created

Viewing 15 posts - 8,191 through 8,205 (of 9,715 total)

  • RE: Just SQL Auth

    danjam (11/21/2009)

    When you install SQL Server 2008, you have to specify the Widows accounts that you want to have initial administrator access. If you specify none, then you have no...

    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 23, 2009 at 5:28 am

    #1082887

  • RE: Just SQL Auth

    Irish Flyer (11/20/2009)

    DoD only allows SQL Server authentication for those cases where it is mandatory, such as service accounts (the accounts under which you run the SQL Server Services). ...

    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, 2009 at 12:02 pm

    #1082408

  • RE: Just SQL Auth

    Darren Wallace (11/20/2009)

    I think you could effectively turn off Windows Authentication by explicitly denying BUILTIN\Everyone but I haven't tried it as I don't have a server handy that I 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.

    November 20, 2009 at 11:54 am

    #1082399

  • RE: Just SQL Auth

    BackupGuy (11/20/2009)

    Reality is that there are several other SQL engines that run just fine on the Windows platform and don't necessarily require AD domain authentication, although, most support it.

    I won'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 20, 2009 at 11:49 am

    #1082392

  • RE: Just SQL Auth

    BackupGuy (11/20/2009)

    The responses so far are, typically, M$-centric...as if nothing exists outside of the AD domain where the SQL server resides that would ever require access to data in 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.

    November 20, 2009 at 5:19 am

    #1082116

  • RE: Just SQL Auth

    Maybe I'm smoking something, but isn't SQL Server--and many things it now does--so tightly integrated into the OS that if Windows Authentication were removeable, it would break most of SQL...

    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, 2009 at 5:09 am

    #1082112

  • RE: Transactions & Cursors

    Thanks, Garadin, for both the response and the test code. It's appreciated.

    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, 2009 at 4:47 am

    #1082103

  • RE: why i can't shrink tempdb data file

    Microsoft has responded to that feedback thread with a request for more information. Were you the one who posted 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 20, 2009 at 4:11 am

    #1082089

  • RE: why i can't shrink tempdb data file

    briansalentine (11/19/2009)

    I found that a department was running reports for a very large date range, so, this brought our normally 7GB- 10GB database up quite a bit. We basically...

    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 19, 2009 at 10:47 am

    #1081719

  • RE: Speed Phreaks

    This topic is also for those of us serving in the "Jack-of-All-DBA-Jobs" role. @=)

    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 19, 2009 at 10:43 am

    #1081717

  • RE: xpsmtp80.dll PROBLEMS

    Did you try the solution I posted above?

    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 19, 2009 at 10:41 am

    #1081714

  • RE: Attach/Dettach - automate

    And if this sort of thing will happen more than once, consider storing your .mdf and .ldf names in a table on a database that doesn't tend to get moved....

    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 18, 2009 at 1:14 pm

    #1081173

  • RE: Speed Phreaks

    Sorry, GSquared. I have an anti-ditto (of a sort) to your list.

    RE: Indexing. Yes, index. But don't OVER index.

    Pet Peeve = developers add an index to an existing table just...

    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 18, 2009 at 8:49 am

    #1080966

  • RE: Commvault backup tool creates proprietary backup files

    Ah, I misunderstood your post.

    Good luck with the battle.

    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 5, 2009 at 7:44 am

    #1075339

  • RE: Commvault backup tool creates proprietary backup files

    If you're the network tech, why are you responsible for the log shipping? I would think that it (and testing backup software) would be the responsibility of the DBA team.

    Unless...

    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 5, 2009 at 7:01 am

    #1075311

Viewing 15 posts - 8,191 through 8,205 (of 9,715 total)