Forum Replies Created

Viewing 15 posts - 3,886 through 3,900 (of 9,715 total)

  • RE: Exact multiple items

    Pass in a delimited concateonated list as a string. Then you can either use a bit of dynamic SQL so you don't have to convert it or you can parse...

    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 19, 2012 at 10:37 am

    #1550958

  • RE: Is a job currently running and if so, what schedule kicked it off?

    You're welcome. BTW, sysjobhistory's run_date and run_time records when the job started, so that might also help you hook it up to a schedule.

    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 19, 2012 at 10:31 am

    #1550954

  • RE: How can I create registration and login in SQL server 2008?

    What have you already tried?

    How do you plan on tracking passwords & logins?

    This is really more of a programming question that a SQL Server question. Could you explain how you...

    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 19, 2012 at 10:28 am

    #1550951

  • RE: Is a job currently running and if so, what schedule kicked it off?

    Did you try SysJobActivity?

    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 19, 2012 at 10:25 am

    #1550946

  • RE: Should I become a DBA?!?

    As Grant Gus said earlier, you might have found the sweet-spot company where you can learn the trade and not actually get called a lot, despite being on 24/7 call....

    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 18, 2012 at 10:32 am

    #1550600

  • RE: Are the posted questions getting worse?

    A few years back, my team had the biggest problem with an auto policy that shut down our PCs in the middle of the night. It took us forever 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 18, 2012 at 9:41 am

    #1550569

  • RE: Automated backup plan

    Nevermind. I didn't read your last post correctly.

    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 18, 2012 at 7:42 am

    #1550488

  • RE: Are the posted questions getting worse?

    GilaMonster (10/18/2012)

    Brandie Tarvin (10/18/2012)

    Jeff Moden (10/17/2012)

    Jeez!!! I just went through interviewing another candidate. Resume says that, in the last 5 years, he designed databases, spent time normalizing/denormalizing depending...

    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 18, 2012 at 7:37 am

    #1550482

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/17/2012)

    Jeez!!! I just went through interviewing another candidate. Resume says that, in the last 5 years, he designed databases, spent time normalizing/denormalizing depending on whether or...

    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 18, 2012 at 7:21 am

    #1550464

  • RE: XSD Question

    Thanks, Matt. I appreciate the clarification.

    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 18, 2012 at 7:06 am

    #1550450

  • RE: Are the posted questions getting worse?

    GilaMonster (10/18/2012)

    Personally I think that guy made a bad choice, but hey, that's up to him

    http://www.sqlservercentral.com/Forums/Topic1372851-9-1.aspx

    24/7 on call as a complete novice with no support. Um, yeah....

    Not stressful at all....

    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 18, 2012 at 7:04 am

    #1550449

  • RE: Are the posted questions getting worse?

    Stuart Davies (10/18/2012)

    Stefan Krzywicki (10/17/2012)

    Brandie Tarvin (10/17/2012)

    It's a disgrace, a disgrace I say. Why do you want to know what I know I know? It's a disgrace, a disgrace 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.

    October 18, 2012 at 7:03 am

    #1550448

  • RE: Should I become a DBA?!?

    Honestly, it doesn't matter what you think it will be. It matters what they expect. That's why we keep telling you to talk to them.

    If you don't ask 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.

    October 18, 2012 at 7:02 am

    #1550444

  • RE: Automated backup plan

    Luis Cazares (10/17/2012)

    I'm not an expert in this area (I'm just learning) but an advice I've read says that you shouldn't have a backup plan. You should have a recovery...

    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 17, 2012 at 12:12 pm

    #1550174

  • RE: How do you admin your databases?

    This whole thing also depends on how segregated the workplace is. If you work in an environment where production DBAs are different from Dev DBAs are different from BI DBAs,...

    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 17, 2012 at 11:55 am

    #1550166

Viewing 15 posts - 3,886 through 3,900 (of 9,715 total)