Frankie Yuen : Share my experience
SQL Server 2008 R2 - Data Level Audit Sample (Change Data Capture)
CREATE DATABASE SQL2008CDCGO USE SQL2008CDCGO EXEC sp_changedbowner 'sa'GO EXEC sp_cdc_enable_dbGO...
Date: 02/21/2012
SQL Server 2008 R2 - Power User Audit Sample (DDL Trigger)
-- Create a databaseCREATE DATABASE DDLTriggerGO USE DDLTriggerGO -- Create a table to hold...
Date: 02/21/2012
SQL Server 2008 R2 - User Action Audit Sample
-- Create Server AuditUSE masterGO -- Create Server Audit on FileCREATE SERVER AUDIT...
Date: 02/21/2012
PowerPivot - A sample of custom Median & Mode function
Please note the performance is not optimized for a very large dataset, try with your own data....
Date: 08/17/2010
SQL Server 2008 Cluster on a Windows Server 2008 Cluster
Here is a good step-by-step guide about how to setup SQL Server 2008 Cluster on a Windows Server...
Date: 03/17/2009