Forum Replies Created

Viewing 15 posts - 3,436 through 3,450 (of 9,725 total)

  • RE: How to deny restore database in sql server to SA?

    Jeff Moden (8/29/2013)

    Brandie Tarvin (8/29/2013)

    K. Brian Kelley (8/29/2013)

    With the different accounts in different environments, they are all admin accounts. Just one works for dev and one works for prod and...

    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.

    August 30, 2013 at 10:39 am

    #1646420

  • RE: How to deny restore database in sql server to SA?

    K. Brian Kelley (8/29/2013)

    With the different accounts in different environments, they are all admin accounts. Just one works for dev and one works for prod and dev never has 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.

    August 29, 2013 at 7:59 am

    #1645994

  • RE: How to deny restore database in sql server to SA?

    das.saroj09 (8/29/2013)

    it can be a great help for this kind of situation and can it be as permanent for the server. where will change or it can only for 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.

    August 29, 2013 at 7:17 am

    #1645971

  • RE: How to deny restore database in sql server to SA?

    das.saroj09 (8/29/2013)

    That's one of the reasons I color code my instances' query windows in SSMS (green for Dev, yellow for Test, orange for QC, and red for Production). The colors...

    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.

    August 29, 2013 at 7:13 am

    #1645968

  • RE: How to deny restore database in sql server to SA?

    K. Brian Kelley (8/29/2013)

    A great product for ensuring the proper color coding based on server name, for instance, is Mladen's SSMS Tools Pack.

    I just use the regular OPTIONS available...

    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.

    August 29, 2013 at 6:59 am

    #1645957

  • RE: Are the posted questions getting worse?

    David Burrows (8/29/2013)

    Jan Van der Eecken (8/29/2013)

    Now, that's interesting. Was looking for a book on SSAS on Amazon. Found "Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX"....

    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.

    August 29, 2013 at 4:53 am

    #1645916

  • RE: How to deny restore database in sql server to SA?

    The main issue with having separate accounts and instances for Dev and Prod is that for one-stop shops like the one I work it, a sysadmin can still have multiple...

    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.

    August 29, 2013 at 4:39 am

    #1645909

  • RE: Are the posted questions getting worse?

    GilaMonster (8/28/2013)

    Can someone please help this poor gentleman deny restore rights to a sysadmin

    http://www.sqlservercentral.com/Forums/Topic1489312-359-1.aspx

    If I understand his OP, he did it to himself.

    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.

    August 28, 2013 at 11:58 am

    #1645693

  • RE: How to deny restore database in sql server to SA?

    You cannot prevent yourself from restoring a production database at any point in the future by any other method then double-checking your work before you hit the button.

    Sysadmin will ALWAYS...

    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.

    August 28, 2013 at 11:56 am

    #1645690

  • RE: Are the posted questions getting worse?

    jasona.work (8/27/2013)

    Brandie Tarvin (8/27/2013)

    GenCon was a working vacation. I worked 3 eight hour shifts in the Catalyst Game Labs booth, helping run the Shadowrun Experience (the interactive demo of our...

    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.

    August 27, 2013 at 11:46 am

    #1645287

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/27/2013)

    Brandie Tarvin (8/27/2013)

    GenCon was a working vacation. I worked 3 eight hour shifts in the Catalyst Game Labs booth, helping run the Shadowrun Experience (the interactive demo 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.

    August 27, 2013 at 11:44 am

    #1645285

  • RE: Are the posted questions getting worse?

    GenCon was a working vacation. I worked 3 eight hour shifts in the Catalyst Game Labs booth, helping run the Shadowrun Experience (the interactive demo of our fifth edition rules)....

    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.

    August 27, 2013 at 7:59 am

    #1645212

  • RE: Are the posted questions getting worse?

    BTW, I'm having a contest over on my blog. If you're interested in a free PDF of the Shadowrun Fifth Edition rules, stop on by and log a comment.

    http://brandietarvin.livejournal.com/102622.html

    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.

    August 27, 2013 at 7:42 am

    #1645200

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/27/2013)

    Brandie Tarvin (8/27/2013)

    Koen Verbeeck (8/21/2013)

    In the category of "Are the posted answers getting worse?"

    http://www.sqlservercentral.com/Forums/Topic1485861-1063-1.aspx

    From now on I shall answers questions in the following manner:

    "I have no flipping clue....

    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.

    August 27, 2013 at 7:35 am

    #1645196

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (8/21/2013)

    In the category of "Are the posted answers getting worse?"

    http://www.sqlservercentral.com/Forums/Topic1485861-1063-1.aspx

    From now on I shall answers questions in the following manner:

    "I have no flipping clue. Please post the solution...

    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.

    August 27, 2013 at 7:25 am

    #1645179

Viewing 15 posts - 3,436 through 3,450 (of 9,725 total)