Kun Lee
Kun is a database administrator in Washington, DC. His areas of interest are database administration, architecture, data modeling and development. He loves technologies of all kinds.
2012 Awards
2012 Awards

Auditing and Compliance
- SQL Server Security Audit Report (last update: 11/16/2009)
Central Management Servers
- Execute SQL Server query on multiple servers at the same time (last update: 6/8/2009)
Database Administration
- Getting more details with an enhanced xp_fixeddrives for SQL Server (last update: 9/11/2013)
- Manual cleanup Change Data Capture for a SQL Server database (last update: 8/30/2013)
- SQL Server Data Mining Add ins for Office 2007 to Predict Database Growth Part 2 (last update: 7/9/2009)
- SQL Server Data Mining with Office 2007 to Predict Database Growth Part 1 (last update: 6/25/2009)
Database Design
- Build a SQL Server Data Dictionary with the Extended Properties (last update: 11/4/2008)
- Script to build a SQL Server Data Dictionary and report with Microsoft Excel (last update: 12/2/2008)
Database Mail
- SQL Server Database Mail and SQL Agent Mail setup by using a script (last update: 4/23/2009)
Full Text Search
- Gathering status and detail information for SQL Server Full Text Catalogs (last update: 2/5/2009)
Microsoft Excel Integration
- Import Excel data into SQL Server using copy and paste (last update: 2/8/2008)
Performance Tuning
- Creating SQL Server performance based reports using Excel (last update: 6/9/2008)
- Setup Performance Monitor to always collect SQL Server performance statistics (last update: 4/11/2008)
Replication
- Build a SQL Server 2005 Updatable Subscription Replication Topology (last update: 3/10/2008)
- Customized Alerts for SQL Server Transactional Replication (last update: 12/15/2009)
- Maintain Custom Indexes on Replication Subscriber Tables via Pre and Post Scripts (last update: 9/20/2010)
- Maintain SQL Server Replication using Source Control (last update: 6/16/2011)
- Monitor SQL Replication Log Reader Agent Latency (last update: 6/1/2017)
- Replication Schema Option Across Different Versions of SQL Server (last update: 10/13/2010)
- SQL Server Replication Scripts to get Replication Configuration Information (last update: 8/4/2009)
- Steps to clean up orphaned replication settings in SQL Server (last update: 6/27/2012)
- Tracking Down SQL Server Replication Distribution Subsystem Agent (null) Failed Errors (last update: 6/5/2012)
- Troubleshooting Slow SQL Server Replication issue due to Distributor Database Growth (last update: 8/25/2009)
Security
- Script to Check and Auto Generate SPNs for SQL Server (last update: 5/8/2017)
SQL Server Agent
- Custom sp_start_job to delay next task until SQL Agent Job has completed (last update: 11/18/2010)
- Customized SQL Agent Job Notifications (last update: 2/14/2013)
- Enable and Disable SQL Server Agent Jobs for Maintenance Mode (last update: 6/15/2010)
- Managing SQL Server Agent Job History Log and SQL Server Error Log (last update: 1/14/2011)
- Monitoring Jobs on Multiple Servers by Using Multi Server Query (last update: 7/3/2012)
- Providing SQL Agent Job Log Data for Developers (last update: 1/23/2013)
Tools
- Free Microsoft Tools to Help Setup and Maintain PerfMon for SQL Server (last update: 10/16/2008)
Upgrades and Migrations
- SQL Server 2008 Upgrade Testing at the Microsoft Technology Center (last update: 3/4/2009)
Virtualization
- SQL Server does not use all assigned CPUs on VM (last update: 4/14/2017)