Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Auditing Foundation Expand / Collapse
Author
Message
Posted Thursday, July 22, 2010 11:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
Comments posted to this topic are about the item Auditing Foundation






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #957764
Posted Thursday, July 22, 2010 11:23 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:50 AM
Points: 2,163, Visits: 2,184
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.
Post #957766
Posted Friday, July 23, 2010 4:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 11,168, Visits: 10,933
Lucky guess - didn't know for sure. Good question!



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #957862
Posted Friday, July 23, 2010 5:11 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
What the heck is sql traps ???
Post #957878
Posted Friday, July 23, 2010 6:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 17, 2014 2:11 PM
Points: 2,411, Visits: 3,440
Ninja's_RGR'us (7/23/2010)
What the heck is sql traps ???


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.
Post #957908
Posted Friday, July 23, 2010 6:49 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:32 AM
Points: 845, Visits: 510
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.
Post #957919
Posted Friday, July 23, 2010 7:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
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.
Post #957928
Posted Friday, July 23, 2010 7:34 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 17, 2014 12:10 PM
Points: 3,766, Visits: 3,584
OCTom (7/23/2010)
Ninja's_RGR'us (7/23/2010)
What the heck is sql traps ???


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.
Post #957955
Posted Friday, July 23, 2010 8:41 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
I couldn't think of another plausible real item, so I came up with SQL Traps.

Great explanation from OCTom.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #958013
Posted Friday, July 23, 2010 9:14 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:53 PM
Points: 22,511, Visits: 30,236
I haven't looked at SQL Audit (yet), but managed to get it right. Lucky guess, but based on some logic.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #958035
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse