Forum Replies Created

Viewing 15 posts - 3,031 through 3,045 (of 3,220 total)

  • RE: Old Dog, New Tricks

    jcb (2/13/2012)


    GSquared (2/10/2012)


    ...

    My point is simply that protecting the code when it's on their server is impossible. Can't be done

    ...

    Sure, even a hardware token can be cracked.

    The only way to...

  • RE: Encryption in Production

    As a developer, I often attempt to follow best practices for developing against/using databases, however, it is rarely within my remit to configure or maintain a database. In fact usually...

  • RE: API Changes

    Revenant (2/9/2012)


    TravisDBA (2/9/2012)


    I read something once about using APIs as Standard Operating Procedure that stills makes alot of sense to me.. "Even if all APIs were standardized, there would still...

  • RE: API Changes

    I have always seen my job as a programmer more akin to an enabler. I haven't always described it in those terms but always with the same meaning. I would...

  • RE: Going Solo

    I have worked freelance since the last millennium...oh ok 1999. Anyway, I have dealt with many people running their own companies, working freelance, temps and permanent employees. The ones who...

  • RE: Old Dog, New Tricks

    cengland0 (2/6/2012)


    GSquared (2/6/2012)


    Running the SQL code inline, instead of in procs, doesn't actually help with that. Well, unless the people stealing it have never heard of Profiler or traces,...

  • RE: Old Dog, New Tricks

    cengland0 (2/3/2012)


    jcb (2/3/2012)


    I dislike using dynamic SQL but for .net I sugest using @

    String sqlcode = @" /*this

    ill keep

    the break lines

    no need to fancy concatenations */

    select *

    from

    mytable

    where

    myfavoritesqlresource = 'SSC';

    ";

    😎

    I...

  • RE: Old Dog, New Tricks

    cengland0 (2/3/2012)


    tsceurman (2/3/2012)


    Until recently, I was using AS. I switched to using =, exactly because of the readability. Of course, I am also rather..... particular when it comes...

  • RE: Old Dog, New Tricks

    Uppercase was just convention as opposed to a compiler requirement.

  • RE: Old Dog, New Tricks

    jcb (2/3/2012)


    I find funny when someone complain about by *= versus explict outer join and stills write code in upper case and complains about lower case.<Snip />

    Casing of SQL is...

  • RE: Change Management

    Working as a freelance developer for over a decade I have worked for differing sized clients from multinationals to small local companies where you can keep your shoes on and...

  • RE: Old Dog, New Tricks

    I agree with davidandrews13 that it is a preference thing, however, there is plenty of empirical evidence that states that the smaller element of code should appear before the larger...

  • RE: Old Dog, New Tricks

    Let's face it, until there is a BIG effort for SQL standardisation there will not be portable SQL. Of course the "our syntax is better so lets all standardise on...

  • RE: Old Dog, New Tricks

    Rod at work (2/2/2012)


    Semicolons will at some point be required in T-SQL? Really? I've seen it used in some cases, but am completely uncertain as to when they...

  • RE: Old Dog, New Tricks

    Gazareth (2/2/2012)


    Gary Varga (2/2/2012)

    I totally understand that. Following reading the article, if I was part of designing the SQL as a new language then with the old 20:20 hindsight I...

Viewing 15 posts - 3,031 through 3,045 (of 3,220 total)