SQL
Code samples and articles on SQL Database methods and practices.
User-defined functions:
DSTBegin: Returns the date Daylight Savings Time begins for a specified year.
BigStringModulo: Applies Modulo arithmetic to values larger than SQL Server's BIGINT datatype
BitMask: Returns a bitmask representation of an integer
CompareText: Performs a fuzzy-search match between two strings.
FormatName: Parses and/or reformats a name string.
EncryptPassword: Encrypts a password using a one-way algorithm.
SQL ToolBox: (Handy scripts for database analysis)
Column Lister: Returns a customized list of table columns for cutting and pasting into code.
Articles:
How to create a comma-delimited string from a table of values.
How to truncate DateTime values