Forum Replies Created

Viewing 15 posts - 31 through 45 (of 2,838 total)

  • RE: Using reserved words as column names

    j-1064772 (4/29/2016)


    Sioban Krzywicki (4/28/2016)


    I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Using reserved words as column names

    John Mitchell-245523 (4/29/2016)


    Sergiy (4/28/2016)


    There is nothing wrong with objects or columns named Number, Version, Join, etc.

    The names don't affect performance or quality of the code anyway.

    It's not a bad coding...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Using reserved words as column names

    The problem is the system is littered with this kind of bad naming. It's an established and large database. They've got columns like

    number

    version

    start_date

    and many more. They won't approve renaming unless...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Using reserved words as column names

    I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's all pipes like...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Using reserved words as column names

    Yeah, but this is an existing column that I want to rename and they're going to want a performance reason

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Rogue Software Changes

    Management throwing people under the bus. Again. Nothing more.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Powershell Permissions

    anthony.green (10/28/2015)


    Might be related, but has the agent account changed since setup? And if so was it done via services.msc or SQL Server Config Manager?

    If services.msc, go to SQL...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Powershell Permissions

    Shawn Melton (10/27/2015)


    It depends on what is your script doing, can you provide the script or an example? What version of SQL Server?

    It never gets to the script. It is...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Hiring for Culture

    djackson 22568 (7/29/2015)


    Sioban Krzywicki (7/29/2015)


    GeorgeCopeland (7/29/2015)


    I have been on a lot of development teams. On every single one, the culture was this: if you can't program, we will eat you...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Hiring for Culture

    GeorgeCopeland (7/29/2015)


    Programmers resent efforts to make them fit in with people who can't program.

    I'm just saying, if you want bonding, good mentoring is the way to do it. And each...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Hiring for Culture

    GeorgeCopeland (7/29/2015)


    I have been on a lot of development teams. On every single one, the culture was this: if you can't program, we will eat you alive.

    And that's too bad....

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Hiring for Culture

    The biggest problem in IT today is the "can they fit in" problem. The problem is that people use this to justify racism, sexism, homophobia and transphobia. One of the...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    GilaMonster (7/23/2015)


    I don't know how things are done in the US, but here 75% is the threshold for a degree to be awarded "With Distinction"

    Congratulations

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Wondering what you all would say if you were presented with a NoSQL system being developed for all your data and were told "It isn't meant to be ACID"

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: The New DBA

    It has long bothered me that this is such a vague, catch-all term. We're supposed to be about precision, but can't bother to be precise about the different specialties in...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

Viewing 15 posts - 31 through 45 (of 2,838 total)