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
MSSQLTips award

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)

Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Kun Lee

More SQL Server Solutions