Kun LeeKun 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. Title Category Date Getting more details with an enhanced xp_fixeddrives for SQL Server Database Administration2026-06-27 SQL Server Data Mining Add ins for Office 2007 to Predict Database Growth Part 2 Database Administration2026-05-19 Troubleshoot Slow SQL Server Replication due to Distributor Database Replication2026-05-10 Monitor SQL Replication Log Reader Agent Latency Replication2017-06-01 Script to Check and Auto Generate SPNs for SQL Server Security2017-05-08 SQL Server does not use all assigned CPUs on VM Virtualization2017-04-14 Manual cleanup Change Data Capture for a SQL Server database Database Administration2013-08-30 Customized SQL Agent Job Notifications SQL Server Agent2013-02-14 Providing SQL Agent Job Log Data for Developers SQL Server Agent2013-01-23 Monitoring Jobs on Multiple Servers by Using Multi Server Query SQL Server Agent2012-07-03 Steps to clean up orphaned replication settings in SQL Server Replication2012-06-27 Tracking Down SQL Server Replication Distribution Subsystem Agent (null) Failed Errors Replication2012-06-05 Managing SQL Server Agent Job History Log and SQL Server Error Log SQL Server Agent2011-01-14 Custom sp_start_job to delay next task until SQL Agent Job has completed SQL Server Agent2010-11-18 Replication Schema Option Across Different Versions of SQL Server Replication2010-10-13 Maintain Custom Indexes on Replication Subscriber Tables via Pre and Post Scripts Replication2010-09-20 Enable and Disable SQL Server Agent Jobs for Maintenance Mode SQL Server Agent2010-06-15 Customized Alerts for SQL Server Transactional Replication Replication2009-12-15 SQL Server Security Audit Report Auditing and Compliance2009-11-16 SQL Server Replication Configuration Scripts Replication2009-08-04 SQL Server Data Mining with Office 2007 to Predict Database Growth Part 1 Database Administration2009-06-25 Execute SQL Server query on multiple servers at the same time Central Management Servers2009-06-08 SQL Server Database Mail and SQL Agent Mail setup by using a script Database Mail2009-04-23 Gathering status and detail information for SQL Server Full Text Catalogs Full Text Search2009-02-05 Script to build a SQL Data Dictionary and report with Microsoft Excel Database Design2008-12-02 Build a SQL Server Data Dictionary with the Extended Properties Database Design2008-11-04 Free Microsoft Tools to Help Setup and Maintain PerfMon for SQL Server Tools2008-10-16 Creating SQL Server performance based reports using Excel Performance Tuning2008-06-09 Setup Performance Monitor to collect SQL Server performance stats Performance Tuning2008-04-11 Build a SQL Server 2005 Updatable Subscription Replication Topology Replication2008-03-10 Import Excel data into SQL Server using copy and paste Microsoft Excel Integration2008-02-08