Since the inception of SQL Server 2005 data encryption and cryptography functionality has elevated to a new level, this wasn't the case until SQL 2000 version. The overall security improvements within SQL 2005 is mainly with 'certficate' authentication, the 3 levels are: Authentication –...
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...