SqlServer-QA.net

Audit trace is very helpful when you want to monitor a particular processes on your SQL Server, even for the successful logins and recent users activity on the databsaes. But the default trace would have many columns with the information and you need to know which column and table you need to get the relevant information. There is a difference ...

Are you aware whether your Enterprise has legal compliance on Sarbanes-Oxley or HIPAA? First off what you should know about legal compliance is when it comes to the compliance matter on almost every business person's mind, Sarbanes-Oxley, there's good news and not so good news. The good news? Compliance can be an opportunity to help ...

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

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