Forum Replies Created

Viewing 15 posts - 1,786 through 1,800 (of 3,221 total)

  • RE: What Counts for a DBA: Empathy

    I have to totally disagree with the following from the article:

    Database development has a subtle difference from application-development. It is not as easy to fake your completion dates, i.e. using...

  • RE: How Often Does Production Drift?

    This is almost as important to developers as it is to DBAs as this can lead to developers creating issues as what they are developing against isn't what they will...

  • RE: For Each - Remove-Item

    $_ is a DataRow as you previously highlighted. A DataRow is made up of data items. You can access an individual item using the index operator []. There are two...

  • RE: For Each - Remove-Item

    So what do you get from:

    Write-Output $_[0].ToString()

  • RE: For Each - Remove-Item

    I think that you need to know what you are dealing with i.e. what is $_?

    Instead of immediately using the following:

    Remove-Item $_-Force

    Perhaps you should be doing the following:

    Write-Output $_.GetType().ToString()

    Then you...

  • RE: Real World T-SQL Tricks

    No.

    Some of these things have come in with 2012 and I haven't developed much code on that. Certainly none on 2014.

  • RE: The SQL Server Container

    Charles Kincaid (11/20/2014)


    ...Don't take me wrong. I love the cat videos as much as the next person but I still think that servers should be dumb as a post...

  • RE: The SQL Server Container

    Steve Jones - SSC Editor (11/20/2014)


    Gary Varga (11/20/2014)


    I would suggest only allowing remote PowerShell sessions as a default position for operational duties. If the GUI is needed it must be...

  • RE: Achievement Unlocked: Balance 0

    All true, Ladies and Gentlemen. All true.

    PS Mrs Varga ensures that we do all holiday. I have to go as who else would carry the luggage 😉

  • RE: For Each - Remove-Item

    Gazareth (11/20/2014)


    Should

    $result | foreach $result {remove-item $result.fullname -force}

    be

    $result | foreach {remove-item $result.fullname -force}

    or

    $result | foreach {remove-item $_.fullname -force}

    The latter. The former doesn't use the current object in the loop i.e....

  • RE: For Each - Remove-Item

    You need to pipe through the result to the for each command.

    I am sorry but I have little time this afternoon but this might help:

    $database.ExecuteWithResults().Tables[0].Rows | ForEach-Object { Remove-Item...

  • RE: Achievement Unlocked: Balance 0

    Ed Wagner (11/20/2014)


    ...I figure my daughter will only be 12 once in her life. After that, it's gone forever. You can call me mushy, but I choose to...

  • RE: Achievement Unlocked: Balance 0

    erwin.oosterhoorn (11/20/2014)


    I have normally no problem here for getting day's off, or for taking holiday at all. When you have young kids it's for us cheaper to take the time...

  • RE: Achievement Unlocked: Balance 0

    GilaMonster (11/20/2014)


    I've been sitting with negative leave days available since July (about -0.5 at this point). No one in management is complaining, no pointed hints that I need to work...

  • RE: The SQL Server Container

    Charles Kincaid (11/19/2014)


    At a very large ISV company that I worked for we had a policy that one thing ran on one machine. One box for SQL Server, one...

Viewing 15 posts - 1,786 through 1,800 (of 3,221 total)