Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 3,221 total)

  • RE: Why Use the Principle of Least Privilege?

    GilaMonster (1/19/2016)


    Gary Varga (1/19/2016)


    I agree with your sentiments here but that is not the appropriate way to call a stored procedure from .NET.

    No kidding, since I posted it as a...

  • RE: Why Use the Principle of Least Privilege?

    GilaMonster (1/19/2016)


    roger.plowman (1/19/2016)


    Stored procedures (and no dynamic SQL in them) are the way to go

    No, they're not necessary. Parametrising calls is necessary. That's all.

    If the app developer doesn't know what...

  • RE: Is Change Coming?

    This has been a long time coming and I see more and more acceptance of remote work, albeit sometimes on a temporary basis, even at the more staid of places.

  • RE: Why Use the Principle of Least Privilege?

    GilaMonster (1/4/2016)


    roger.plowman (1/4/2016)


    SQL, on the other hand, makes it hard to *avoid* accidental code execution inside parameters...

    It's not hard at all.

    Always parameterise queries (no, stored procs aren't required, parameterised...

  • RE: The DBA Tax

    It seems that as always some people will read the "near zero administration" or "self-administering" as zero work. It depends on the complexity of the scenario. I have been aware...

  • RE: Turn Out the Lights

    jarick 15608 (1/18/2016)


    ...I used to work for a guy who was a PHD in mathematics and he would work constantly to eliminate extra code or even white space in his...

  • RE: Muting the Immutable

    J Livingston SQL (1/18/2016)


    david.dilworth (1/18/2016)


    'Cornish' AS TheLanguage

    Well there's something that you don't see every day 😉

    I think Phil meant "Welsh" not "Cornish"

    Must have done as the Cornish equivalent of the...

  • RE: Muting the Immutable

    It restricts the users to writing only DDL build scripts and spits out any DML it finds.

    I hate it when languages and systems do this type of restriction. It should...

  • RE: Turn Out the Lights

    As for who pays, when it isn't the IT department it is usually the IT department who make the recommendations and do so on the least risk basis. This is...

  • RE: The SQLite alternative to NoSQL

    Definitely one to bear in mind. Often forgotten. Ever present.

  • RE: Sharing Code

    It is easy to attribute the work

    It is morally right to give credit.

    It is often a legal requirement to specify the origins.

    So we should just to it.

  • RE: Sharing Code

    Iwas Bornready (12/29/2015)


    If you don't want your code reused, don't share it.

    One difficulty in this area is that some developers feel that they can do what they like with what...

  • RE: Byte Me: Three Wise Men

    Trick question. The new Systems Administrator is not a wise man :w00t:

  • RE: Changing entries in a .ini file using powershell

    You are most welcome.

  • RE: Tracking Professional Athletes

    Eric M Russell (1/14/2016)


    Gary Varga (1/14/2016)


    Jeff Moden (1/14/2016)


    Insurance companies are already doing this although I don't know if they actually track geo-location but it seems logical they would because they...

Viewing 15 posts - 1,126 through 1,140 (of 3,221 total)