Auditing Foundation

  • Comments posted to this topic are about the item Auditing Foundation

  • Nice question, thanks! I like the questions that bring up new features to help keep us up to date even if we might not have had the chance to upgrade yet.

  • Lucky guess - didn't know for sure. Good question!

  • What the heck is sql traps :w00t:???

  • Ninja's_RGR'us (7/23/2010)


    What the heck is sql traps :w00t:???

    They catch the rodents running around the database. You have your choice of humane live traps, which became available in SQL Server 2008, or, the old spring-loaded traps which kills the rodent instantly.

    What we do here is use the live traps and release them in a database on a server that's disconnected from the network. They eventually get released into the cloud.

  • SQL 2008 R2 adds the ability to use the captured rodents to automatically find missing indexes and delete those no longer used with no overhead other than the occasional cheesy snack. Unfortunately that's only available in the Enterprise Edition.

  • Good question thanks. I had to read just a bit to confirm what I thought I knew. Keep pushing newer features with QoTD, it helps us all stay/get current and become even better.

  • OCTom (7/23/2010)


    Ninja's_RGR'us (7/23/2010)


    What the heck is sql traps :w00t:???

    They catch the rodents running around the database. You have your choice of humane live traps, which became available in SQL Server 2008, or, the old spring-loaded traps which kills the rodent instantly.

    What we do here is use the live traps and release them in a database on a server that's disconnected from the network. They eventually get released into the cloud.

    Nice. Thanks for the laugh this morning.

  • I couldn't think of another plausible real item, so I came up with SQL Traps.

    Great explanation from OCTom.

  • I haven't looked at SQL Audit (yet), but managed to get it right. Lucky guess, but based on some logic.

  • I think this one goes with a little logic like Lynn and Paul said. Nice question.

    I wonder if the QOTD will be on auditing next friday as well.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Cliff Jones (7/23/2010)


    OCTom (7/23/2010)


    Ninja's_RGR'us (7/23/2010)


    What the heck is sql traps :w00t:???

    They catch the rodents running around the database. You have your choice of humane live traps, which became available in SQL Server 2008, or, the old spring-loaded traps which kills the rodent instantly.

    What we do here is use the live traps and release them in a database on a server that's disconnected from the network. They eventually get released into the cloud.

    Nice. Thanks for the laugh this morning.

    You're welcome.

  • Steve Jones - Editor (7/23/2010)


    I couldn't think of another plausible real item, so I came up with SQL Traps.

    Great explanation from OCTom.

    Thanks Steve. SQL Traps WOULD be a good name for some tool, though.

  • OCTom (7/23/2010)


    Steve Jones - Editor (7/23/2010)


    I couldn't think of another plausible real item, so I came up with SQL Traps.

    Great explanation from OCTom.

    Thanks Steve. SQL Traps WOULD be a good name for some tool, though.

    Nice comments. Oh, and a good question.

    Tom

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply