SqlServer-QA.net

  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 – subjects (persons, devices, ...

What is the Kerberos Authentication?  What are the security features difference between Windows 2000 and 2003 versions? How it is behaved within Failover Clustering? How to enable Kerberos Authentication Including SQL Server Virtual Servers on Server Clusters? Let us see how the user access to SQL Server resources is controlled by ...

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 ...