• (disco) in reply to Jaloopa

    And college students on break who worked only from May to September? They wouldn't be in last year's backup or this year's current.

  • (disco)

    Take the backup in July, then you're bound to get all of the seasonal workers.

    What is your business, by the way? I can offer more personalised advice if I know stuff like the number of employee hours worked per 21 days

  • (disco) in reply to Jaloopa

    So, the "solution" is to compare backups taken all year long to find all the employees that have ever worked at the company but are not currentyly active? Hmmmm...... I see where TRWTF is here.....

  • (disco) in reply to Bananafish

    Actually, that's not my preferred option. I would have a delete trigger on the HR table to insert a record into a new deleted users table, probably in a separate database to prevent bloating the main data store. A delete from this table would only need to happen if the employee is discovered to have been an undercover policeman or other undesirable

  • (disco) in reply to Jaloopa
    Jaloopa:
    A delete from this table would only need to happen if the employee is discovered to have been an undercover policeman or other undesirable

    In which case you would you use a different type of trigger

  • (disco) in reply to IngenieurLogiciel

    :rimshot:

  • (disco) in reply to Jaloopa
    Jaloopa:
    A delete from this table would only need to happen if the employee is discovered to have been an undercover policeman or other undesirable

    *chortles* You know, some of us work for companies who have their own private, fully-sworn police forces...

  • (disco) in reply to tarunik
    tarunik:
    companies

    A real company, or Amtrak?

  • (disco) in reply to boomzilla
    boomzilla:
    A real company, or Amtrak?

    The US Class I freight railroads maintain their own sworn police forces...

  • (disco) in reply to tarunik
    tarunik:
    US Class I freight railroads

    So, a real company.

  • (disco) in reply to HardwareGeek

    But is Class I the lowest, shittiest class? Or the best class!?

    EDIT: also the dinky local transit system here has its own police force, as did the small university I attended. Not very impressive, frankly.

  • (disco) in reply to blakeyrat
    blakeyrat:
    But is Class I the lowest, shittiest class? Or the best class!?

    Class I are the biggest, in terms of revenue: http://en.wikipedia.org/wiki/Railroad_classes#Classes

    blakeyrat:
    the dinky local transit system here has its own police force, as did the small university I attended.

    The primary purpose, AFAIK, of railroad cops is to chase away trespassers, or arrest them if necessary. I'm not sure what, if any, other purpose they have. However, they have been known to overstep their bounds an harass people observing train operations from public property, especially train buffs taking pictures. People like that raving lunatic in the video that was posted here (Bad Ideas topic?) a while back.

  • (disco) in reply to tarunik
    boomzilla:
    Amtrak
    tarunik:
    US Class I freight
    HardwareGeek:
    Class I are the biggest, in terms of revenue:

    I suppose this thread was on track to get derailed.

  • (disco) in reply to HardwareGeek
    HardwareGeek:
    The primary purpose, AFAIK, of railroad cops is to chase away trespassers, or arrest them if necessary. I'm not sure what, if any, other purpose they have.

    I presume they began as ways to keep the unions from messing with the mail.

  • (disco) in reply to Groaner
    Groaner:
    I suppose this thread was on track to get derailed.

    I was a freight it might

  • (disco) in reply to Jaloopa

    :rimshot:

  • (disco) in reply to boomzilla

    Or to prevent train robberies.

    http://img2.wikia.nocookie.net/_cb20120813055006/breakingbad/images/4/42/5x5_Dead_Freight(02).jpg

  • (disco) in reply to Mariachi
    Mariachi:
    Or to prevent train robberies.

    But robbing / impeding the mail is why the Feds would care enough to give them actual police power.

  • (disco) in reply to boomzilla
    boomzilla:
    But robbing / impeding the mail is why the Feds would care enough to give them actual police power.

    Good point, but that depends on whether they are empowered by the Feds or by the individual states. I don't know that.

  • (disco) in reply to HardwareGeek

    http://en.wikipedia.org/wiki/Railroad_police#United_States

  • (disco) in reply to HardwareGeek
    HardwareGeek:
    The primary purpose, AFAIK, of railroad cops is to chase away trespassers, or arrest them if necessary. I'm not sure what, if any, other purpose they have.

    They do deal with trespassers quite a bit, yes -- hobos are a far uglier bunch than the books of yore lead you to believe. They also interface with other law enforcement agencies (state, local, tribal) regarding a variety of issues, from trespassers to parade floats and oversized loads.

    HardwareGeek:
    However, they have been known to overstep their bounds an harass people observing train operations from public property, especially train buffs taking pictures.
    Just stay clear of the RR ROW, and all's fine in my book -- main problem is that the ROW isn't all that clearly delineated in most parts of the US, unlike the UK which fenced all their railroads in.
  • (disco) in reply to tarunik
    tarunik:
    unlike the UK which fenced all their railroads in.

    The UK's really fond of fences, so our railroads are too…

  • (disco) in reply to dkf
    dkf:
    > unlike the UK which fenced all their railroads in.

    The UK's really fond of fences, so our railroads are too…

    Apparently they're not. At least one drunk managed to find one that wasn't and so his family are demanding that all the ones that aren't fenced in, be so. Because.

    Commentary:

    http://thylacosmilus.blogspot.co.uk/2015/03/well-i-bloody-wouldnt.html

    Original "all must suffer and pay because of one idiot" article:

    http://www.dailyecho.co.uk/news/11823004.Devastated_family_of_tragic_train_death_footballer_launch_rail_safety_petition/

    Said the deseased's sister:

    “Even if he wasn’t drunk and accessed the tracks it would still have happened.

    I'm betting it wouldn't have.

    This post wouldn't have been better off in the Bad Ideas Thread.

  • (disco) in reply to PJH
    PJH:
    Said the deseased's sister:
    Even if he wasn’t drunk and accessed the tracks it would still have happened.
    So… the poor dead guy's sister is calling him a braindead moron? Smooth :unamused:
  • (disco) in reply to tarunik
    tarunik:
    Just stay clear of the RR ROW, and all's fine in my book

    Unfortunately, not all the cops in the field share your viewpoint. I've read of people standing on public sidewalks being harassed and told it was illegal to take pictures of trains because **scary terrorists**.

  • (disco) in reply to Job_Ross
    Job_Ross:
    I saw a much better solution (in Oracle) which also can be implemented in sql server 2012.

    Create a single sequence in your schema. For every table in your schema, add a column (call this column ROWSTAMP) that stores the next value from your schema sequence. For each table in your schema, create a row-level trigger that fires on insert/update, that gets the next value from the sequence object and sets the ROWSTAMP using that value. All Update and delete statements must include a clause that says "and ROWSTAMP = @Original_ROWSTAMP' or something similer, this prevents updates/deletes from completing unless it is still the same starting record.

    I once used a database that had a built-in string-valued pseudocolumn called ROWID which performed three functions:

    1. It encoded an insert index. This could detect when a row was deleted.
    2. It encoded an update index. This could detect when an existing row was updated.
    3. It encoded the physical data location. If the insert and update indices checked out, this allowed the engine to go directly to the data location.

    A typical DELETE statement therefore looked like

    DELETE FROM tbl WHERE ROWID = :rowid
  • (disco) in reply to urkerab
    urkerab:
    built-in string-valued pseudocolumn called ROWID

    String valued? WAT?

  • (disco) in reply to dkf
    dkf:
    String valued? WAT?

    Oracle ROWIDs are stringy in nature, but are their own type...perhaps these pseduo-ROWIDs are base64ed somethings? (Which is what Oracle's ROWIDs look like, too)

  • (disco)

    Yeah, ROWID sounds like oracle

Leave a comment on “SearchGuard”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article