Volume Shadow Services
On other sites
SQL Server Central
Tips & Techniques
One Month Calendar
Next Year Calendar
HTML Color Codes
Hex Graph Paper
JLION.COM - SQL Server
SQL for cleaning data
It's spring, and that means spring-data-cleaning time. Here are some functions that help break text in a last-name-first field into separate last name, first name and middle name components.
Extended WHOIS for SQL Server
Extended WHOIS procedure that includes buffer contents. Works with all versions of SQL Server 2000 and newer.
SQLAutoDoc database & monitoring utility
The second version of the SQLAutoDoc database & monitoring utility has been released. This new release includes much new functionality including versioning, compare, and status monitoring for size, blocking, connections and waitstates.
Working with Time Frames in T-SQL
This is an article I wrote for SQLServerCentral about querying data for time frames. IE: Finding activity that took place during a specific minute/hour/day when most activity is several minutes/hours/days in length.
SQL Server Date Handling
A general overview of date handling with SQL Server
Adding a foreign key with Transact SQL
Examples of using Transact SQL to add foreign key and primary key constraints
Creating Foreign Keys for SQL Server using Transact SQL
A quick guide to using DDL to create foreign keys.
Some thoughts on how best to measure the distance between two addresses + a haversine function for sql server.
Small SQL Snippets for various tasks.
How to set up SQL Server 2000's SQL Mail to use SMTP/POP instead of Exchange Server
The SQL Server documentation isn't clear on how to configure SQL Server 2000 to support SQL Mail and the xp_sendmail command. This guide fills in some of the gaps in the documentation.
Created by Joe Lynds 2002-2008.