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   Generate and apply a table of sequence numbers

SearchSQLServer Web Site   05/11/2005   List database objects by selected types

SearchSQLServer Web Site   06/20/2005   Retrieve filtered file lists from a specified directory

SearchSQLServer Web Site   07/21/2005   Find columns by name and see a distribution of values

SearchSQLServer Web Site   08/18/2005   Perform specified operations on tables and objects

SearchSQLServer Web Site   09/15/2005   Search character columns for a given string

SearchSQLServer Web Site   10/06/2005   Create crosstab results very similar to Access

SearchSQLServer Web Site   10/20/2005   Execute T-SQL code from a file without using xp_cmdshell

SearchSQLServer Web Site   11/03/2005   Create fixed-width data files from T-SQL

SearchSQLServer Web Site   11/17/2005   Create comma-separated value (CSV) files

SearchSQLServer Web Site   12/01/2005   Examine SQL Agent job run history

SearchSQLServer Web Site   12/15/2005   Keep track of SQL Agent job details

SearchSQLServer Web Site   01/19/2006   Easily filter SQL Server connection information

SearchSQLServer Web Site   02/16/2006   Generate T-SQL code for ad hoc data operations

There may be more tips on the SearchSQLServer.com web site that are not yet listed here.

SearchSQLServer Web Site   01/05/2006   A Surrogate Key Architecture and Support Tools

SearchSQLServer Web Site   02/02/2006   Standard Columns and Standard Objects for a Surrogate Key Architecture

SearchSQLServer Web Site   03/02/2006   Utility Routines to Maintain a Surrogate Key Architecture

There are potentially several more articles in this series. The articles include dozens of useful stored procedures that demonstrate the many advantages of a consistent surrogate key approach to database design. Please let Brian know what you think of the articles.

SSWUG Web Site   08/26/2005   Surrogate Keys, Primary Keys and IDENTITY

SSWUG Web Site   09/09/2005   Surrogate Keys, Primary Keys and IDENTITY Revisited

Visit the SSWUG.org web site, which references many of the articles listed here.

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 these two articles and much more.