July 22, 2010 at 11:22 pm
Comments posted to this topic are about the item Auditing Foundation
July 22, 2010 at 11:23 pm
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.
July 23, 2010 at 4:34 am
Lucky guess - didn't know for sure. Good question!
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
July 23, 2010 at 5:11 am
What the heck is sql traps :w00t:???
July 23, 2010 at 6:29 am
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.
July 23, 2010 at 6:49 am
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.
July 23, 2010 at 7:03 am
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.
July 23, 2010 at 7:34 am
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.
July 23, 2010 at 8:41 am
I couldn't think of another plausible real item, so I came up with SQL Traps.
Great explanation from OCTom.
July 23, 2010 at 9:14 am
I haven't looked at SQL Audit (yet), but managed to get it right. Lucky guess, but based on some logic.
July 23, 2010 at 11:00 am
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
July 23, 2010 at 2:23 pm
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.
July 23, 2010 at 2:25 pm
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.
October 17, 2010 at 4:29 pm
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