Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 6,038 total)

  • RE: WHERE 1 = 1,who uses this besides me

    Resender (2/2/2015)


    ok this is something of a best practice of mine in my queries

    I always do

    WHERE 1 = 1

    I can't remember where I picked this habit up and I'm one...

  • RE: DBA vs. Developer Question / Issue

    butcherking13 (2/18/2015)


    I was hoping the tenured DBA’s would chime in on this. I work with a developer who has more experience as I am a very junior DBA. She is...

  • RE: SQL Injection, Still?

    djackson 22568 (2/18/2015)


    ...

    It is also against the law to kill and steal, but people do it. Laws don't prevent anything, they discourage. Governments and corporations across the...

  • RE: SQL Injection, Still?

    call.copse (2/18/2015)


    Eric M Russell (2/17/2015)


    GoofyGuy (2/17/2015)


    It eliminates the need to eat.

    Liquid bread, it is!

    Which makes we wonder: Maybe Brits do have better beer options in a typical bar, but...

  • RE: SQL Injection, Still?

    GoofyGuy (2/17/2015)


    It eliminates the need to eat.

    Liquid bread, it is!

    Which makes we wonder: Maybe Brits do have better beer options in a typical bar, but how does the bar...

  • RE: SQL Injection, Still?

    GoofyGuy (2/17/2015)


    IT these days looks more like a craft brewery where we keep changing the recipe: sometimes it works, and sometimes it's disgusting.

    I'm tempted to make a comparison between American...

  • RE: SQL Injection, Still?

    But are most data breaches the result of SQL injection or even ad-hoc database access by outsiders?

    From what I've seen, most of these massive data breaches are done by:...

  • RE: Kill Processes

    Kev Charlatan (2/17/2015)


    'Use it carefully'

    Understatement of the year!

    Yeah, you definately want to first test fire it on the development server a few times just to make sure you know how...

  • RE: SQL Injection, Still?

    However there are two big problems that prevent us from eradicating SQL Injection: aging code and bad habits.

    I know it gets old, but we should never assume we're preaching...

  • RE: Can I roll my database forward

    This would be more of a solution going forward, but we can also use DDL Triggers to audit all database schema changes. I've personally never done this, but as the...

  • RE: Can I roll my database forward

    aaron.reese (2/17/2015)


    Preaching to the converted mate!

    Currently have 40+ customers all with modified databases that do not match the release standard and the test database may or may not match the...

  • RE: Kill Processes

    Igor Micev (2/16/2015)


    bgrossnickle (2/10/2015)


    won't you get an error if you try to kill system processes?

    This is a good notice. System databases' process should be avoided.

    @author: What about if you want...

  • RE: Closer to the Heart

    I would love a job where I could spend half my time behind the computer and the other half outdoors in the field, traveling and getting my hands dirty. Perhaps...

  • RE: Closer to the Heart

    david.gugg (2/13/2015)


    Being an avid fisherman, I've always thought there would be great value in a site where you could share fishing results and in return, receive other people's results. ...

  • RE: Super long running queries (bad users)

    It sounds like in your case the users are actually working for external clients, so unfortunately you're in a position where both you and your managers have to tread lightly....

Viewing 15 posts - 4,141 through 4,155 (of 6,038 total)