Published Articles
These database articles were written by Brian Walker as a hobby. If you have any questions or comments you can contact him at Wingenious.
SearchSQLServer Web Site   04/01/2005   TEXT  CODE   Generate and apply a table of sequence numbers
SearchSQLServer Web Site   05/11/2005   TEXT  CODE   List database objects by selected types
SearchSQLServer Web Site   06/20/2005   TEXT  CODE   Retrieve filtered file lists from a specified directory
SearchSQLServer Web Site   07/21/2005   TEXT  CODE   Find columns by name and see a distribution of values
SearchSQLServer Web Site   08/18/2005   TEXT  CODE   Perform specified operations on tables and objects
SearchSQLServer Web Site   09/15/2005   TEXT  CODE   Search character columns for a given string
SearchSQLServer Web Site   10/06/2005   TEXT  CODE   Create crosstab results very similar to Access
SearchSQLServer Web Site   10/20/2005   TEXT  CODE   Execute T-SQL code from a file without using xp_cmdshell
SearchSQLServer Web Site   11/03/2005   TEXT  CODE   Create fixed-width data files from T-SQL
SearchSQLServer Web Site   11/17/2005   TEXT  CODE   Create comma-separated value (CSV) files
SearchSQLServer Web Site   12/01/2005   TEXT  CODE   Examine SQL Agent job run history
SearchSQLServer Web Site   12/15/2005   TEXT  CODE   Keep track of SQL Agent job details
SearchSQLServer Web Site   01/19/2006   TEXT  CODE   Easily filter SQL Server connection information
SearchSQLServer Web Site   02/16/2006   TEXT  CODE   Generate T-SQL code for ad hoc data operations
SearchSQLServer Web Site   01/05/2006   TEXT  CODE   A Surrogate Key Architecture and Support Tools
SearchSQLServer Web Site   02/02/2006   TEXT  CODE   Standard Columns and Standard Objects for a Surrogate Key Architecture
SearchSQLServer Web Site   03/02/2006   TEXT  CODE   Utility Routines to Maintain a Surrogate Key Architecture
SSWUG Web Site   08/26/2005   HTML   Surrogate Keys, Primary Keys and IDENTITY
SSWUG Web Site   09/09/2005   HTML   Surrogate Keys, Primary Keys and IDENTITY Revisited
SQL Server Professional Newsletter   09/2004   Self-Referencing Tables
SQL Server Professional Newsletter   12/2004   T-SQL Coding Standards
The free Database Architecture e-book includes the content of these two articles and much more.