Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    So my new machine is Win 7. I have SQL 2008 installed fresh. Interestingly enough, the Open File with New Connection icon is not on the toolbar in Win 7...

    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 12:20 pm

    #1646449

  • RE: Are the posted questions getting worse?

    Sean Lange (8/30/2013)

    Brandie Tarvin (8/30/2013)

    ARGGGGH!

    The crappy thing about a new computer?

    Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code...

    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 12:18 pm

    #1646447

  • RE: Communicating with Non-Technical Users

    You need to find common ground with them. What work culture thing or real life thing do they all have in common?

    For instance, when I was teaching kids about 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.

    August 30, 2013 at 12:10 pm

    #1646445

  • RE: Are the posted questions getting worse?

    ARGGGGH!

    The crappy thing about a new computer?

    Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. 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.

    August 30, 2013 at 11:57 am

    #1646443

  • RE: Are the posted questions getting worse?

    YAY! I have a new computer at work.

    Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now I have...

    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:41 am

    #1646421

  • 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

Viewing 15 posts - 3,421 through 3,435 (of 9,715 total)