Frankie Yuen : Share my experience

  • Article

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

Author: Frankie Yuen 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...

Author: Frankie Yuen Date: 02/21/2012

SQL Server 2008 R2 - User Action Audit Sample

-- Create Server AuditUSE masterGO -- Create Server Audit on FileCREATE SERVER AUDIT...

Author: Frankie Yuen 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....

Author: Frankie Yuen 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...

Author: Frankie Yuen Date: 03/17/2009