Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 9,715 total)

  • RE: Here are some SQL Server Interview Questions

    Luis Cazares (5/15/2015)


    It's important for us that you'll be a good fit in our team, so the following question will define if you get the job or not.

    Leading commas 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.

  • RE: Here are some SQL Server Interview Questions

    GilaMonster (5/15/2015)


    Luis Cazares (5/14/2015)


    You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning....

    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.

  • RE: Here are some SQL Server Interview Questions

    Jeff Moden (5/14/2015)


    Alvin Ramard (5/14/2015)


    Here's an interview question:

    Name 10 of the parameters for DBCC TimeWarp. 😛

    I'd seriously consider asking a DBCC TimeWarp question at an interview, just to see...

    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.

  • RE: Are the posted questions getting worse?

    GilaMonster (5/14/2015)


    Question for the people here...

    Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when 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.

  • RE: Here are some SQL Server Interview Questions

    pietlinden (5/14/2015)


    Best milkshakes ever. I don't like that boss very much.

    And we're OFF TO THE RACES! Thank you. I did get a chuckle out of that.

    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.

  • RE: You know you're having a slow day when...

    yb751 (5/1/2015)


    So I'm browsing the forums and seeing the usual comments like "please provide code and sample data". I'm sitting there and thinking this isn't that hard. 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.

  • RE: Trace Flag 4299?

    It could be just set by default in their workplace (part of their install).

    Thanks, Gail. I appreciate the insight.

    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.

  • RE: Are the posted questions getting worse?

    SQLRNNR (5/8/2015)


    Lynn Pettis (5/8/2015)


    Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.

    What is dynamic sql?

    Doesn't it involve fireworks and music?

    ISTR there was...

    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.

  • RE: Uninstalling SQL 2012

    Perry Whittle (5/1/2015)


    Brandie Tarvin (4/30/2015)


    WHEE! I just got my new servers and am ready to install SQL 2012 when I discovered that one of these servers already has it installed...

    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.

  • RE: Uninstalling SQL 2012

    EMarkM (5/1/2015)


    Eirikur Eiriksson (5/1/2015)You could use System Restore to the earliest point available, patch the OS and then install the SQL Server.

    😎

    That's a pretty good idea!

    Otherwise, it'll be just 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.

  • RE: Uninstalling SQL 2012

    The problem is that I can't nuke the OS. Corporate has to build servers (we're not allowed) and we had to pull teeth in order to get our new servers....

    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.

  • RE: Running WinSCP in SSIS Task / .bat file

    And now it is working.

    Everyone has been incredibly helpful. Thank you. Here's the file Powershell script that I'm using.

    $erroractionpreference = "Stop"

    # Load WinSCP .NET assembly

    [Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\WinScp\WinSCPnet.dll")

    # Setup session...

    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.

  • RE: Running WinSCP in SSIS Task / .bat file

    jasona.work (4/30/2015)


    Brandie, I think your batch file is almost there, just a couple more tweaks and it should go.

    That being said, I'm 90% sure that DOS doesn't like single quotes...

    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.

  • RE: Running WinSCP in SSIS Task / .bat file

    Ed Wagner (4/29/2015)


    Brandie, a word of encouragement if I may. Your batch file is creating your WinSCP script file. You then invoke it by calling the WinSCP executable...

    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.

  • RE: Running WinSCP in SSIS Task / .bat file

    GAH. Now I get nothing at all in the log file. The only upside was I could see the issues in the command prompt.

    SIGH. Why can't this be easy?

    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.

Viewing 15 posts - 2,641 through 2,655 (of 9,715 total)