Forum Replies Created

Viewing 15 posts - 9,181 through 9,195 (of 9,720 total)

  • RE: Script to remove old (.bak) files?

    FORFILES?

    I haven't heard of that command. It works in the command shell?

    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.

    January 8, 2008 at 3:46 am

    #765642

  • RE: Script to remove old (.bak) files?

    To address the original question (though xp_cmdshell can be a major security hole)...

    -- This code removes the previous day's backup from this folder

    --BIG NOTE: This code is dependent on 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.

    January 7, 2008 at 11:03 am

    #765448

  • RE: SSIS Data Flow slow on SQL 2000 Server insert

    Well, I updated my Batch size and Max Commit to 10000 and set my sources as queries. Started the run about 1 & 1/2 hours ago and already 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.

    December 19, 2007 at 10:45 am

    #761481

  • RE: SSIS Data Flow slow on SQL 2000 Server insert

    I am filtering in the source by Deselecting all the columns. DIdn't think about the effect that would have... I should probably change that to a query instead.

    I did...

    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.

    December 19, 2007 at 8:44 am

    #761430

  • RE: the 70-443 passing score

    Microsoft doesn't usually tell how they score the tests, but 700 or more has to be the total score you get in order to pass (I believe).

    Used to be 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.

    December 19, 2007 at 7:40 am

    #761398

  • RE: 70-447 coming up...

    Well, I passed. Should have rescheduled though. I hurt my back a few days before the exam, so didn't do as well as I wanted to because 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.

    December 17, 2007 at 3:48 am

    #760645

  • RE: What Would You Do?

    Timothy,

    You have a lot of good points. Unfortunately, per the privacy policy at my workplace, I have to inform X number of people to get the request signed off...

    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.

    December 14, 2007 at 12:47 pm

    #760432

  • RE: Practice Tests - Any preferences?

    There should be another thread in the Cerification forum about the Second Shot thing.

    Basically, there are certain times where MS gives you a code that you can take the test...

    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.

    December 14, 2007 at 12:07 pm

    #760416

  • RE: What Would You Do?

    Yeah, I heard about that. (the UK data breach) OUCH!

    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.

    December 14, 2007 at 8:58 am

    #760310

  • RE: What Would You Do?

    Just finished reading everyone's responses. Everyone says they want it in writing, which is good, but my comment about the email request still stands.

    Email is just too...

    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.

    December 14, 2007 at 8:10 am

    #760264

  • RE: What Would You Do?

    Posting this before I read the other replies...

    First, how did I hear about this request from the CIO himself or via email?

    If via email, I would be very suspicious 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.

    December 14, 2007 at 8:05 am

    #760255

  • RE: 70-446 Exam, Anyone pass?

    Go to microsoft's website and get the list of topics they cover. Then buy non-cert books that cover those topics.

    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.

    December 14, 2007 at 7:14 am

    #760230

  • RE: Interview Questions -BackUp

    Funny you should ask that... Just Tuesday, we had an article in the newsletter about that question.

    See the below link:

    http://www.sqlservercentral.com/articles/Administration/61591/

    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.

    December 14, 2007 at 6:19 am

    #760195

  • RE: 70-446 Exam, Anyone pass?

    Amazon has this book listed, but I haven't actually seen it for sale anywhere. And even Amazon doesn't seem to know where to find it:

    http://www.amazon.ca/MCITP-Self-Paced-Training-Exam-70-446/dp/0735623848

    That might give you 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.

    December 14, 2007 at 6:00 am

    #760184

  • RE: Practice Tests - Any preferences?

    I prefer transceder myself. That's after using the Self-Paced training kits and their included practice exams.

    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.

    December 14, 2007 at 5:56 am

    #760178

Viewing 15 posts - 9,181 through 9,195 (of 9,720 total)