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
  

• SQL Server Security Audit Report (last update: 11/16/2009)
  

• Execute SQL Server query on multiple servers at the same time (last update: 6/8/2009)
  

• 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)
  

• 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)
  

• SQL Server Database Mail and SQL Agent Mail setup by using a script (last update: 4/23/2009)
  

• Gathering status and detail information for SQL Server Full Text Catalogs (last update: 2/5/2009)
  

• Import Excel data into SQL Server using copy and paste (last update: 2/8/2008)
  

• 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)
  

• 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)
  

• Script to Check and Auto Generate SPNs for SQL Server (last update: 5/8/2017)
  

• 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)
  

• Free Microsoft Tools to Help Setup and Maintain PerfMon for SQL Server (last update: 10/16/2008)
  

• SQL Server 2008 Upgrade Testing at the Microsoft Technology Center (last update: 3/4/2009)
  

• SQL Server does not use all assigned CPUs on VM (last update: 4/14/2017)