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