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

Jamie Thomson et al has developed very useful Vista gadget that can be used to monitor the SQL Server database metrics information within your environment. In their words: The gadget does exactly what it says on the tin; it monitors a specified SQL Server database for various metrics and displays them on the Windows Vista Sidebar. It is provided ...