|
|
Browse by Tags
All Tags » 2008 » cdc (RSS)
-
Can we audit the activity inside the SQL Server 2008 to capture SELECTs activity?
For the first time I though CDC will be useful to DBAs in auditing the activity on the database, but its not entirely. It is equivalent to auditing functionalities and in short CDC is more poised towards the ETL for incrementatl data load and that uses an ...
-
Let us talk briefly about the new feature that is introduced within SQL Server 2008 aka Katmai.
Change Data Capture (CDC) is (similar to triggers: INSERTED & DELETED tables) the 'new boy in SQL Server town' that records the DML activities applied to the database objects with an easy relational format. Further the column ...
|
|
|