Forum Replies Created

Viewing 15 posts - 61 through 75 (of 194 total)

  • RE: Potential presentation idea: The role of documentation in disaster recovery

    Ray K (3/11/2016)


    I'll also mention that all of our documentation was in hardcopy format and stored as Word/Visio/PDF files. (At the time, online documentation was still a foreign concept.)...

  • RE: Byte Me: Spy Where?

    I don't think much about this new Facebook.

  • RE: Do Less

    Fortunately I managed to avoid the real minimalist of setting dip switches to enter the program and my experience of paper tape was limited to loading the OS for a...

  • RE: Do Less

    The main ones I see repeatedly are the lack of understanding of Boolean algebra or how data is stored and its implications particularly wrt floating point arithmetic.

  • RE: User shouldn't be able to run but can in production

    His AD account isn't a local admin for the windows box by any chance?

  • RE: SCAN vs. SEEK

    With the value being in a known position in the first table you could preprocess that table to extract the string you require into a new column and create an...

  • RE: Logging Tables

    In general for logging you want to store Who, What and When. The exact details of what needs to be included will depend on why you are logging.

    Who may be...

  • RE: Data Liability

    It would be somewhat clearer in the UK

    The Data Protection Act requires any organisation holding personal data to register. That registration specifies what data they may hold, who may access...

  • RE: Lockdown All Databases Except One

    Your other option would be to set up more instances as you can control access to each seperately. Ultimately you can go to the extent of one instance per database.

    Set...

  • RE: Lockdown All Databases Except One

    stanlyn (9/15/2015)


    tempBD was mentioned... Does that mean that all these efforts can be easily defeated by an accomplished dba? If so, what should I be considering?

    Thanks,

    Stanley

    If the dba...

  • RE: Lockdown All Databases Except One

    If merely being able to see the name of a database is a breach of confidentiality then surely the easiest way to avoid that is to use codenames for new...

  • RE: Remove String from column Post Code Field

    Just a short walk from Bradford lol.

    I suppose it could also be a badly written S - i.e. Bristol - shouldn't take them more than a few minutes. 😀

  • RE: Remove String from column Post Code Field

    Dealing with partial postcodes greatly complicates things

    Is B91 really B91 or is it supposed to be B9 1

    B91 is Solihull and B9 is Saltley about 10 miles apart and...

  • RE: Remove String from column Post Code Field

    Assume whoever input the postcode does not understand where the space should be - you probably wont be far off.

    Strip out all spaces then take last 3 chars, prepend with...

  • RE: Remove String from column Post Code Field

    A UK postcode is always formed of two parts

    The first part and will be of the form 1 or 2 letters indicating the posttown followed by 1 or 2...

Viewing 15 posts - 61 through 75 (of 194 total)