Tutorials
DBA
Dev
BI
Career
Categories
Webcasts
Scripts
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
(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)
More SQL Server Solutions
